topic Re: Transporting table changes in Application Development and Automation Discussions

Transporting table changes

Former Member — Fri, 29 Oct 2010 02:05:32 GMT

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

Re: Transporting table changes

Former Member — Fri, 29 Oct 2010 04:25:03 GMT

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.

Re: Transporting table changes

nabheetscn — Fri, 29 Oct 2010 05:35:16 GMT

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

Nabheet

Re: Transporting table changes

Former Member — Fri, 29 Oct 2010 07:16:38 GMT

Thanks guys!