How to move custom table from one instance to another

dhruva
Kilo Contributor

I have a requirement where i have a custom table having overall 80 columns and 4 custom modules created under it. i need to move this to another instance of snow. what is the best approach ?kindly help t_anurag

1 ACCEPTED SOLUTION

If you have related fields on this table, then those will cause problems for sure, as the related data will not be in the other instance. and i dont think there is any way to do it also as you cant just move all the data, it would be as good as a clone.


-Anurag

View solution in original post

22 REPLIES 22

Ashutosh Munot1
Kilo Patron
Kilo Patron

you can move it with update set. but this will only have skeleton of table ie columns and field,


but data will not be copied.


to copy data take unload of data through xml.



simliarly,


you can have xml of table and transfer it from instance to instance


The custom table is already created and present in dev insatnce   . how to i add this to new update set. just by making any updates on the table will help in capturing the entire table ?


what you want to move to new update set


i want to add the table structure