SAP backup restore from MS SQL Server 2012 to MS SQL Server 2019

[avijish]

Hello Experts,

We have SAP ERP 6 EHP7 on MS SQL Server 2012 R2 and wish to migrate to MS SQL Server 2019, is this backup restore from MS SQL Server 2012 R2 to MS SQL Server 2019 supported and compatible, please share your experiences and SAP documentation which supports this path.

Thanks

Vijish

[hrollizo]

Hi Vijish,

Yes it is. You can do a system copy using export/import or backup/restore.

Don´t forget MS SQL Server licence and update ODBC drivers too:

• SAPNote xxxxxxx - SAP Installation Media and SQL4SAP for SQL Server
• 2139358 - Effect of changes in licensing terms of SQL Server
• 2751450 - SAP Systems on Windows Server 2019
• 2656107 - Support for Microsoft ODBC Drivers for SQL Server in SAP NetWeaver

Best regards

[riccardo_cola · Accepted solution]

Dear Vijish,

Yes, it is possible and supported to restore a Microsoft SQL Server 2012 backup in Microsoft SQL Server 2019.

However, since you run the Microsoft SQL Server database with an SAP ERP / SAP NetWeaver system what you call migration at SAP is named "SAP NetWeaver Homogeneous System Copy", the system copy process requires the usage of SAP tool SWPM.
I recommend you carefully read the SAP System Copy guide and the Microsoft SQL Server guides below for more information:

-- "System Copy guide":
https://support.sap.com/en/tools/software-logistics-tools.html -->
--> System Provisioning Scenarios
--> Copy a System using Software Provisioning Manager (System Copy guide)
System Copy Option of Software Provisioning Manager 1.0 SP 34

-- "Upgrade to and Installation of SQL Server 2019 in an SAP Environment" guide:

https://help.sap.com/doc/96768ee77e334613a3cca0ee07e710cb/SQL2019/en-US/loiobca90f57c35c027ee1000000...

Regards,
Riccardo

[former_member723767]

Hi Jaime,

Backup-restore from SQL-2012 to SQL-2019 works and are supported.

Questions to you :

We have to migrate our SAP IDM 8.0, running on AS-JAVA 7.53, Windows-2012, SQL-Server-2012

to SAP IDM 8.0, running on AS-JAVA 7.53, Windows-2019, SQL-Server-2019.

Our approach is :

1. Install new VM with windows-2019, SQL-Server-2019, to host DB.

2. Backup of IDM_DB (from source windows-2012, SQL-2012), restore to target windows-2019, SQL-2019.

3. Backup of JAVA_DB (from source windows-2012, SQL-2012), restore to target windows-2019, SQL-2019.

Then, to reconnect our current AS_JAVA (windows-2012) to the new DB-server (windows-2019, SQL-Server-2019),

I have noticed the following steps :

1. Modify entries and settings in configtool

2. Modify JDBC drivers

3. Modify SQLshack ...

Do you have a list of actions to complete to re-connect an existing AS-JAVA (Windows-2012) to a new DB-Server-2019 ?

Thanks

PC

[jaime_rodriguez_jr]

Dear Vijish,

In general the answer is yes I've perforformed this procedure with smooth results.

Homogeneus Copy from Windows 2008 R2 on MSSQL 11 to Windows 2019 on MSSQL 15 with several methods

exp/imp, detach/atach and backup/restore begin the last one the faster since the compression of the .bak file makes it smaller and the transfer to the target host is faster than the others methods.

My recommendation is that you follow carefully the SWPM guides according to your environment.

https://support.sap.com/en/tools/software-logistics-tools.html

Regards

Jaime Rodriguez Jr.