after system copy we have old schema in sql 2005

[Former Member]

Hi,

we have done the system copy using backup/restore method. After restore we could see the database owner (schema) [prd and SAPPRDDB] in the Target QAS system.

what is the procedure to change the schema from PRD to QAS and SAPPRDDB to SAPQASDB in target system.

Thanks & Regards,

Kasi

[Former Member]

we just ran the sapinst tool to over come this issue.

Regards,

Kasi

[Former Member]

Hi Kashi,

You can use the STM tool provided by SAP for schema conversion after DB copy. The tool is available on Service marketplace. It will automatically do all the required post-processing for MSSQL DB after a DB restore such that you can proceed with the SAP related post-steps.

However, there are additional steps involved if you have both ABAP+JAVA stack. For JAVA stack you need to first export the JAVA schema using SAPInst and then reimport after the DB restore.

Hope this helps.

Regards,

Deoraj Alok.

[nikhil_bose]

Hey kasi,

The production database must be copied using SQL detach method. And following the notes mentioned below, SID could be changed.

SNOTE: 193816

SNOTE: 151603

Good Luck,

Nikhil Bose

[JPReyes]

The only way to do a clean change of schema is doing a homogeneous system copy.

All the info is on the guide.

Regards

Juan