General Consultant Discussion

Does anyone have a method to move the entire FAS SQL database, companies, security and all? The only answer I have ever received from FAS support was use their backup and restore but re-setup all the security again - UGH.

Surely there must be a way to use an SQL backup and restore to get all the data including the security and then reconnect the app server to the new SQL location?

I have a huge job coming up where this will save many, many hours of time if it can be done.

------------------------------
Greg Stiles
S & W Microsystems
------------------------------

With the help of the client's SQL Admin we used the following process to move FAS to a new SQL server.

NOTE: The SQL procedures were performed by the End User's DB Admin, so I may not have the exact steps.

Steps Taken:

Copy company databases using SQL backup and restore
Copy system databases BESTSYS & Sage_FAS (same method as above)
Copy SQL users winfas, winfasguest & any SA equivalent user if not using built in SA account.
Run the following script on the new SQL server:
update [BESTSYS].[dbo].[ServiceInfo]
set [AttributeValue]='NEW_SERVER_NAME'
where [AttributeValue]='OLD_SERVER_NAME'
Use Regedit to change HKEY_LOCAL_MACHINE\Software\WOW6432node\Best Software\MBESTSYS\EngineName to new SQL servername\instance on both server and all clients.

Test access from FAS Database Utility and FAS Depreciation Client

------------------------------
Greg Stiles
S & W Microsystems
------------------------------