Change or migrate SQL Server Database

Owned by Jean-Philippe Golay
Last updated: Feb 15, 2022
1 min read

In some cases you need to transfer WIP repository database to another server follow this procedure

  1. Stop all WIP Services

  2. Launch SQL Server Management Studio

  3. Select the database and open “properties / files”, note the location of the Database files

    1. mine are here C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA

  5. Close properties and press “Tasks / Take Offline” (check drop all active connection)

  6. Go to the file folder and copy the <database>.mdf and <database>_log.mdf

  7. Paste them in the file folder of the destination SQL Server

  8. Select the “Databases” node right click and select “Attach Databases”

Launch WIP Setup, change the database connection and restart all services

et voilà…