Database migration (move databases to new server)

The following MassTrack databases needs to be migrated if you are moving to a new server:

• sdb_Shipdb (and optionally the sdb_Demo if it exists)
• SWLogin
• All database starting with SWxx_  (where xx is any number from 01 to 99)
• SWSystem

To migrate, follow these steps:

1. Install SQL Server on the new server machine
2. Migrate the databases listed above by either;
   1. (Preferred) Create a backup of the databases on the old server, restore them on the new server.

– or -

2. Set the databases “offline” (or “detach”) on the old  server, copy the files to the new server and “attach” them on the new SQL Server
2. Make sure the permissions settings for the MassTrack users are set on the new SQL Server, same as on the old server (check file access permissions after transfer)
3. On the client machine, the first time the client logs on to the new server, select or type in the new server name in the “SQL Server” box in the MassTrack login screen.