Transporting table changes

[Former Member]

Hi folks,

I've made changes to a custom table in SE11(including keys and add new fields). Question is, if these changes are being transported to QA system, will the current table in QA system will be overwritten? how about the current content of table? will it be overwritten as well? do we need to adjust the table again in QA?

Thanks,

Tremonti

[Former Member]

Hello Karchy,

You will not loose the data in your QA table once you move the Table changes. The conversion will be managed through a temporary table at the back end. You can expect a few dumps in your QA system while the transport is being imported, if there are programs accessing this table during that time. Basically the DB system will use one of ALTER TABLE or table conversion methodology to adjust your table (as you have data in it). Only if the table is empty, its dropped and re-created (fastest method).

Once the transport is imported, its better to confirm the status of the table in SE14. If required "Activate and Adjust" the table and look out for issues in the logs.

When you move this table to the productive environment, do so in a quite time (when the system is least active).

Regards,

Jinesh.

[nabheetscn]

it will not effect anything just make sure you have adjusted your table using se14.

Nabheet

[Former Member]

Thanks guys!