Copy a table to another instance

[Stewe Lundin]

Hallo Braintrust!

I have a table in an instance that are created  and changed over time. 
I now want to copy this table structure (not the data) to an other instance. 

Fining all the related Update sets are more or less impossible. 
It will probably be faster just to recreate the table manually in that case. 

But before I do that(it's several tables), I just need to check if its possible to some how move it in one go. 
Is there a utility of some other magic I can use for this 🙂 

Thanks in advance.

[sachin_namjoshi]

You can go to sys_update_xml.LIST table and find all dictionary updates related to this table.

Create new update and capture these changes in your update set and then move this update set to next instance.

Regards,

Sachin

[miked_jones]

Finding the individual updates (as outlined above) might be your best option.  

You could try a quick and dirty XML export/import by going to Tables and exporting the table record itself, and then going to the sys_dictionary table, filtering on that table, and exporting that list to XML, then importing both to your instance. That would get the table structure itself, but you wouldn't get things like modules, roles and ACLs that might have been created along with the table. 

I've only used this method to drop a table into a personal dev instance for quick testing, so depending on why you're looking to move the table, this might not be a good option for you.

Tables are always a pain to migrate after the fact, unless you keep them carefully separated from other updates and tracked. 

[Niveditha Arula]

Hi Stewe,

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,

[Christian74]

Hey, Niveditha Arularasan

I´m wondering if you mean by exporting 3 xml files, etc by exporting it into an xml file by forcing the records into an update set.

If it´s not through an update set xml file, how do I import into into the instance? I have tried through the retrieve update set option, but it doesn´t import it since it´s just an xml file and not an udpate set xml file.