cancel
Showing results for 
Search instead for 
Did you mean: 

export/import SQLServer db using SWPM

andreas_herzog
Active Contributor
0 Kudos

Hi to all you pros out there....

I was wondering if it is possible to export data from a SQLServer 2005 SP2 and import this data into SQLServer 2008/R2 or 2012 using standard ex/import tools from SAP like SWPM (eg. R3load etc.).

I know that for Oracle and DB2 it is possible to transfer data this way; for example exporting Oracle 10.2 and importing the same dump into 11.2...

THX in advance!

GreetZ, AH

Accepted Solutions (1)

Accepted Solutions (1)

Sriram2009
Active Contributor
0 Kudos

Hi AH

I was wondering if it is possible to export data from a SQLServer 2005 SP2 and import this data into SQLServer 2008/R2 or 2012 using standard ex/import tools from SAP like SWPM (eg. R3load etc.).

1.  Yes you can use the SAP Standard method (Export / Import).

2. Since your are using the MS SQL DB you can perform the database backup on MS Sql 2005 SP2  and restore the same DB on MS Sql  server 2008 R2 or 2012. after restored you can perform the system copy.

Regards

Sriram

andreas_herzog
Active Contributor
0 Kudos

thx for the answer...but:

- my only option will be export/import using R3load

- just to be clear: export sqlserver 2005 sp2 und using this dump to import in sqlserver 2008/2012 ist possible?

GreetZ, AH

Sriram2009
Active Contributor
0 Kudos

Hi


- my only option will be export/import using R3load

- just to be clear: export sqlserver 2005 sp2 und using this dump to import in sqlserver 2008/2012 ist possible?

              Yes, You can use do the export of exiting MS SQl 2005 DB & import same to target system of Ms Sql DB either 2008 R2 or 2012.

Kindly refer the System copy guide

https://websmp106.sap-ag.de/~sapidb/011000358700000877172012E

http://scn.sap.com/docs/DOC-34592

BR

SS

former_member188883
Active Contributor
0 Kudos

Hi Andreas,

- just to be clear: export sqlserver 2005 sp2 und using this dump to import in sqlserver 2008/2012 ist possible?

Please check in PAM whether your OS, DB and SAP applications are supported on the target environment,

www.service.sap.com/PAM

Hope this helps

Regards,

Deepak Kori

andreas_herzog
Active Contributor
0 Kudos

thx for all, the answers....the techniques to do a system copy are clear - i've done that before ...

i wasn't sure about using the dump while skipping SQLserver versions - that's all!!

GreetZ, AH

Answers (1)

Answers (1)

Reagan
Advisor
Advisor
0 Kudos

If you are using SWPM/sapinst for the export and import then R3load will be used. The exported content will be in DB independent format. You basically export the source system and create the target system with the export dump. With this approach you avoid the database upgrade task if the source system was on a lower release and the target will be on higher release.

I believe for MSSQL 2008 there is a requirement to have a specific BASIS patch level for the SAP systems. (Not quite sure)

Check these SAP notes.

1076022 - Release planning for Microsoft SQL Server 2008 (R2)

1152240 - Setting Up Microsoft SQL Server 2008 (R2)

Regards

RB