System copy - Schema Conversion

[Former Member]

Hi,

I'm planning to do a system copy to build a preprd with PRD databse using a backup/restore method..

PRD (ESP)- WIN 2008 SP2 (not R2) + MSS - 2005 + SAP ECC 6.0 SR3 NUC SPS14+ Kernel - 281

PREPRD (ESX)- WIN 2008 SP2 (not R2) +  MSS - 2005 + SAP ECC 6.0 SR3 NUC SPS14+Kernel - 301 (KERNEL DVD)

Approach - System Copy + Database Dependent + Backup/Restore (with a FULL backup from PRD)

Media - SAP NETWEAVER SR3  SAPINST + KERNEL DVD (Patch  - 301) using NUC option

how to do the schema conversion from ESP to ESX ??

do i need to run any sql scripts??....If so plz let me know the steps.

Regards,

Dinakar

[former_member189546 · Accepted solution]

Hello,

Please use script in note

1294762   SCHEMA4SAP.VBS

regards,

John Feely

[Former Member · Accepted solution]

Hi John,

My dba used MOVE SQL script provided by SCHEMA4SAP.vbs to move all objs from ESP to ESX.

It worked like a charm.

Thanks for your inputs.

[Former Member]

I had the same problem and it got resolved with the steps mentioned by Premsukh

[Former Member]

Hi,

You can use STM tool provided by SAP to perform schema conversion. This procedure do not need any SQL scripts. Please refer note 683447 for more information.

Regards,

Pradeep

[premsukh_bishnoi]

Hi,

You can also use a Detach and attach straitegy for doing system  system in fast way.

For this you need to stop your PRD system for  doing copy of  data file and log file.

R/3 System Copy – MSSQL Server

Important: This
method can be followed only for already installed systems (or) for system
refresh.

Source System:

2. Stop
        R/3         
4. Open
        the SQL Server Management Studio
6. Please
        note down the properties of your current DB
8. Take
        the DB offline
10. Detach
         the DB
12. Copy
         the Data (MDF,NDF) files  & Log
         (LDF) files to the Target system.
14. Target System:
16. Part 1: Activity to
    be done with the old DB:
17. 2. Stop
            R/3
    4. Open
            the SQL Server Management Studio
    6. Please
            note down the properties of your current DB
    8. Take
            the DB offline
    10. Detach
             the DB
    14. Part 2:
    15. 2. Rename
                source <SID> with target <SID> in the Data (MDF,NDF)
                files  & Log (LDF) files as
                follows:
        4. <SID>DATA1.mdf
        6. <SID>DATA1.ndf
        8. <SID>LOG1.ldf
        9. 3. Attach
                   to DB to SQL server in the target system using SQL Server Management
                   Studio

Then please run STM tool as above said note.

Regards, Premsukh