Hi everyone,

We are just moving DBs of some Sage 300 customers to new database servers with SQL Server 2019 (Windows Server 2019). We are not going to upgrade Sage 300 or move applications to new server, just Databases. From SQL Server 2008  R2 to SQL Server 2019.

We only need to do :

- Create databases in new SQL Server.

- Change Database setup to point and login to that new SQL server instance.

- Change DSNs (ODBC) accordingly.

- And  DBDump data from old SQL and DBLoad data to new one right? 

One doubt : Dont remember exactly but Sage create a new ODBC when connecting first time, named it with server name I think so and if using that new driver you cant connect until change setup to trusted certificate.....cant I delete that one and stay with old one or I need to to use it for SQL Server 2019?

Any other step I'm missing or recommendation about it to take in account?

Thank you very much