How to move Sage 300 SQL Data from SQL 2008R2 to SQL 2017

Question

I have a client that is installing a new server and upgrading from SQL 2008R2 to SQL 2017. Is there a way to move the SQL databases without using a dump and load? Also, we are running CRM, so we also need to move that database.

IDLSystems · Answer

If you do not knowhow to use SQL, then I can not really teach you on the forum: (You need to find somebody in the client IT department who knows SQL, or in your own company). 
 1) the new SQL does not like to do a restore unless you have done a backup first - I found this out the hard way after spending a long time trying to restore. 
 2) there is a boxes that needs to be ticked to change the names over 
 3) you can also change the names in the section where it has the file & log 
 4) the database name is the S300 name that you allocate in the S300 database maintenance screen - that must be the same.

Sage 300

How to move Sage 300 SQL Data from SQL 2008R2 to SQL 2017

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING