How to export/import table structure to another instance ?

Yusuf5 · ‎11-01-2017

Hi,

I wonder if there is any way to export a table structure to another instance, so I don't have to go through the table recreation in another instance.

Any help is appreciated.

Regards

Yusuf

Khanna Ji · ‎11-01-2017

Yusuf CELIK wrote:

I created the table in DEV environment and I didn't create an update set.

And I've gone through another update sets no clue, I think I have to go with the traditional way, just create.

Thanks

Regards

Yusuf

In this case create a Local Update set and then go to sys_update_xml table. This table contains all customer updates. Under the Update set field for your record update your newly created local update set name.

All your updates will be now available in newly created local update set. Now you can move your changes from Dev to Test or Prod using this update set.

View solution in original post

Chandu Telu · ‎11-01-2017

Hi Yusuf,

You export the data from one insatnce to another instance using import sets

you can tranfer the custoomization creation tables,fileds using update sets

Yusuf5 · ‎11-01-2017

Thanks Chandu,

I am aware of update sets, but I afraid I don't have an update sets.

Any other solution ?

Thanks

Yusuf

Chandu Telu · ‎11-01-2017

where do you create the table structure

there should be an update set it may be default update set you can transfer those update sets to another update set

or you can update the name and capture those values in another updaet set

Yusuf5 · ‎11-01-2017

I created the table in DEV environment and I didn't create an update set.

And I've gone through another update sets no clue, I think I have to go with the traditional way, just create.

Thanks

Regards

Yusuf