202129 Nov

How To Move Sage 100 Premium ( SQL ) To A New SQL Server


There may be a time when you need to move your Sage 100 database from one SQL server to another without also moving the server that the core Sage 100 is installed to. Sage has documented the steps in their knowledgebase. Follow this link to the Sage knowledge base for the details on how to move your Sage 100 SQL server database from one SQL server to another SQL server while keeping Sage 100 Premium installed to the same underlying server. The migration from Standard or Advanced is well documented. The primary benefits of using a SQL database with Sage 100 are (a) security over data tables ( which are all protected by SQL security ) and (b) significantly faster external reporting ( your standard Sage 100 reports on the menus will typically be about the same speed but anything attached directly to the SQL database will report much quicker).

Source: S-consult