How to migrate database to a new SQL Server

  • Updated

How to migrate a database to a new SQL server.

  1. Backup the source database.
  2. Copy, then restore the source backup onto the destination SQL Server.
  3. Ensure the SQL account for the connection has the necessary role memberships (minimally: db_datareader, db_datawriter, db_ddladmin, and db_executor).
  4. Update the the web server's web.config connectionString so it points to the restored database. Update server information/SQL user as necessary.
  5. Restart the EktronWindowService so the necessary sync files are updated.