Tips on how to move a MS SQL Foray ADAMS database from on 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>;