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

Thanks anurag , let me try this . but can you clarify one thing. Here i want to capture the entire structure, modules, scripts etc. how i can include it in the above script. can you give ma n example pls.


All these things you have created, scripts tables etc. are they part of any scope or all in global?


-Anurag

They are all in global .


Then you already know how to capture the data,



Now open a record, right click -> configure-> ALL


here you will get all the br, client scripts, ui policies, ACL etc and you will have to capture each manually(just toggle the active flag on each, ui policy action and ACL roles will hacve to be captured separately)


-Anurag

Hi Anurag, rest of the things i know to do it, the problem i ma facing is to move the table structure since when i am trying to move its broken . half of data is not present. so wanted to know how to move the table structure with xml since it is giving a broken structure