Versions Compared

Key

  • 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
languagesql
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>;

...