on 05-17-2014 7:50 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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,
Hope this helps
Regards,
Deepak Kori
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.