Sage 100

First Premium Upgrade (ever, so excuse the ignorance!) (from Standard 2013). We did a test upgrade, the Application server is Dev but will be converted to Production at live upgrade. The Dev Sql Server will not be converted, rather I'm being asked to install to a Production Instance on another Sql Svr. What are my steps to migrate data for Production and at what point will I be able to tell the Application programs there is a new Sql Server/Instance to install to. Hoping I don't need to blow away the Test Application Server programs. Thanks.

Here is a List of instructions https://support.na.sage.com/selfservice/viewContent.do?externalId=42996&sliceId=1

Actually @NancyHanson this is what you are looking for in combination above instructions.

After you move the databases, and run the utility to point Sage 100 to the new SQL Instance, you may get permission errors. If so, run these commands in SQL (for each of the MAS_ databases... including system): `use MAS_###; exec sp_changedbowner 'MAS_User'; exec sp_dropuser 'MAS_Reports'; exec sp_grantdbaccess 'MAS_Reports'; exec sp_addrolemember 'db_datareader', 'MAS_Reports';`