cancel
Showing results for 
Search instead for 
Did you mean: 

DB migration: SQL Server to MAX DB

arsnlgunnr
Participant
0 Kudos

Hi guys,

I am looking into migrating from SQL Server to MAXDB.  Only migrating the DB, OS staying the same.  Looking for some insight/tips from admins that have done this before.  Any guides or notes that helped? 

Thanks in advance!

Accepted Solutions (1)

Accepted Solutions (1)

arsnlgunnr
Participant
0 Kudos

Thank you all for the responses.  Is this task considered an OS/DB migration or a standard system copy? 

I have done many homogeneous system copies and am familiar with the tools to use.

Reagan
Advisor
Advisor
0 Kudos

If there is a change in OS or DB or both then it is considered as a migration (also know as Heterogeneous system copy)

Regards

RB

arsnlgunnr
Participant
0 Kudos

Thanks Reagan, I figured so.

Reagan
Advisor
Advisor
0 Kudos

You basically take the export of the sources system using sapinst/swpm and import or create the target system by importing this dump.

The dump will be in database independent format.

You may read this SAP note.

82478  - SAP system OS/DB migration

Regards

RB

Reagan
Advisor
Advisor
arsnlgunnr
Participant
0 Kudos

fantastic, that's exactly what i needed to know.  do yo have to be certified to do the migration?  we only run DEV and Demo SAP instances...

Thanks!

ashish_vikas
Active Contributor
0 Kudos

yes, as per SAP, OS/DB migration should be performed by OS/DB Certified consultant even though its a Dev system.

best regards

ashish

Reagan
Advisor
Advisor
0 Kudos

Technically speaking one can do it if he or she has the expertise but according to SAP here is what they say:

To execute an OS/DB migration, the following are required:

    1. A technical consultant, specially certified for OS/DB migrations, executes the migration locally, irrespective of whether you are migrating a development system, a test system or a productive system. This ensures that the required "know-how" is available to deal with the complexity of the situation.

    2. You use the migration check for the operating system or the database to migrate production systems.

SAP can provide hotline support for the migration only if both of these prerequisites are met, you use a copying technique that is supported by SAP, and you use the correct migration tools. In general, the tools that are provided in the installation kit up to Basis Release 4.6D are not released for an operating system or database migration (at least not for data export). As of Basis release 6.x, the installation kits contain all of the required tools.

If the prerequisites are not met, we must inform you that SAP cannot provide any SAP Support Line support for your migration. All support during the migration, when solving inconsistencies and performance problems, and if data loss occurs, can be provided by SAP only as a consulting service that is subject to charge.

Regards

RB

Answers (3)

Answers (3)

Reagan
Advisor
Advisor
0 Kudos

Hello

Check this link to find out more information about the migration

https://websmp208.sap-ag.de/osdbmigration

Pick up the guide from here :

http://service.sap.com/guidefinder

Begards

RB

ashish_vikas
Active Contributor
0 Kudos

What is your product and version ?

you should start with System Copy guides which are available on marketplace.

best regards

ashish

arsnlgunnr
Participant
0 Kudos

SQLServer 2008R2 to MAXDB 7.9

Former Member
0 Kudos

Hello Jayson,

Use below link choose NW version OS and DB from task list choose system copy to find guides.

https://websmp230.sap-ag.de/sap(bD1wbCZjPTAwMQ==)/bc/bsp/spn/guidefinder/main.htm?smpsrv=

BR,

K.