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.

use ForayAdams; alter user foraydbadmin with login = foraydbadmin; Here is the script without the database and users plugged in: use <existing_database>; alter user <existing_database_user> with login = <newly_created_login>;

 

© 2023 Foray, LLC - All Rights Reserved