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

[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