/
MS SQL Migration Tips

MS SQL Migration Tips

Tips on how to move a MS SQL Foray ADAMS database from one server to another.

foraydbadmin Account

Perform a full backup database on the origin SQL server and restore to destination SQL server.

On destination SQL server create logon user matching the origin database user with current password.

Run below SQL script.