Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

foraydbadmin Account


Code Block
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>;