Versions Compared

Key

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

...

  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

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

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

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

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

...

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

et voilà…