export/import SQLServer db using SWPM

[andreas_herzog]

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

[Reagan]

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