How to move custom table from one instance to another

[dhruva]

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

[Mihir Mohanta]

If your table is already created without any update set then you can export the table and its field as XML format and import it in different instance.

Thanks,

Mihir

[dhruva]

Hi Mihir, i tried this approach, unfortunately not all comuns and fields are getting captured in XML. any reasons why ?

[Mihir Mohanta]

Please follow below steps.

1.Go to the System Definition --> Tables and export the table record as XML   and import in other instance.

2.Go to sys_dictionary.LIST .Filter the entries for the table name exported in the step 1. Export as XML and import in other instance.

3.Go to System Definition --> Modules . Filter the module you want to move.Export as XML and import in other instance.

4.Now you need to export all configurations like   Business rule, client script etc used for the table and import them in other instance.

5.If you want to move the records created in that table then like wise you need to export and import.

As you have missed to capture the customization in update set so you need to follow below procedure to move them.

Please mark it as Helpful/Correct according to its impact.

Thanks,

Mihir

[dhruva]

Hi Mihir

let me check and get back to you

[dhruva]

Hi

The problem i face is xml export and import is broken . it is not capturing all the fields from source to destin.