WinSPC has a built-in utility to migrate a WinSPC database from one database server to another.  The migration utility will copy the data to the new database, enter a notation into the old database indicating a migration has been done, and update the WinSPC.ini file in the remote directory so that each client station will know where the new database is at the next time the client is ran.

Keep in mind that the migration requires exclusive database access, so no users can be logged into WinSPC during the migration process. Also, the time involved for the migration can vary greatly, depending on factors such as the speed of the network, the size of the current WinSPC database, the capabilities and load on the servers, etc.

NOTE: It is not necessary to complete this procedure if you are simply upgrading from one version of database server software to a newer version of the same software without changing your database hardware (for example, if you are upgrading from Microsoft SQL Server 2000 to Microsoft SQL Server 2005).

1. Create a backup of the WinSPC database you want to migrate.
2. Using the "WinSPC Installation and Configuration Guide", configure an empty database for WinSPC on the new server, as instructed in the 'Phase 1' portion of the guide pertaining to your specific database platform.  The "Installation and Configuration Guide" can be found on your product CD or in the files you downloaded to install or upgrade WinSPC.  You can also download some of the recent installation guides here: http://knowledgebase.winspc.com/questions/98/.  You can also contact our Technical Support to get a copy of the guide for your specific WinSPC version.
3. From any WinSPC client station, launch WinSPC and log in as the 'Admin' user.
4. Since the migration process requires exclusive database access, force the logout of all stations currently connected to the WinSPC database. To do this:
   1. From WinSPC Administrator window, click "Tools" → "Force User Logout."
   2. In the "Force User Logout" dialog box that is displayed, multi-select all the stations listed.
   3. Click the "Logout" button.
   4. Allow 30 seconds or so for the logout to be forced.
   5. Close the "Force User Logout" dialog box by clicking the "Close" button.
5. Launch the Migration Wizard by clicking "Tools" → "Migrate" from WinSPC Administrator window.
6. Proceed through the Migration Wizard, keeping in mind that the wizard is prompting for information regarding the new database server, not the existing one.  By the time the wizard completes, it will have:
   • Changed the 'DBState' field of the old database to '3' (in the 'SYSTEMSETTINGS' or 'CONFIG' table), preventing future use of the old database.
   • Tested the connection to the new database.
   • Created the WinSPC tables and fields in the new database.
   • Copied all appropriate data from the current database to the new database.
   • Updated the WinSPC.ini file in the remote directory with the new database information.
7. Once the migration wizard completes, log into WinSPC from that same station to confirm the new database connection.
8. Go to another station and launch WinSPC. When WinSPC runs the first time after a migration, it will do the following automatically (and without any user interaction):
   • WinSPC will attempt to connect to the old database, but discovers that the database has been marked as having been migrated.
   • WinSPC will go out to the WinSPC remote directory and will retrieve the new database connection information from the 'WinSPC.ini' file in that directory
   • WinSPC will update its local 'WinSPC.ini' file (in the WinSPC application directory) with the new database information.
   • WinSPC will then connect to and use the new database

1. Have all WinSPC client stations connect to the new database at least once. If the remote directory is moved prior to a WinSPC station connecting to the new database, the station will have no way of detecting the information about the new database as explained in the step 8 above.
2. Locate the WinSPC remote directory.  If you do not know the current location of the remote directory:
   • On any computer with WinSPC installed, open the local 'WinSPC.ini' file (by default, this located in the "C:\Program Files\DQS\WinSPC\" directory).
   • Locate the line in the file that begins with "ImageDir=".  The path that follows this entry is the location of the remote directory.
3. Copy the contents of the remote directory to the desired location, ensuring that this new location is accessible by all WinSPC clients (this may involve setting the folder to be a 'shared' folder).
4. If the path to the WinSPC remote directory is a mapped drive, then you will need to go to each WinSPC client and change the path of the mapped drive through Windows.
5. If the path to the WinSPC remote directory is a UNC path, then you will need to do the following:
   
   • In the new remote directory, edit the 'WinSPC.ini' file and change the path on the line in the file that begins with "ImageDir=" to the path of the new WinSPC remote directory.  Save the changes to the file.
   • On each WinSPC client, edit the 'WinSPC.ini' file in the WinSPC application directory.  Change the path on the line in the file that begins with "ImageDir=" to the path of the new WinSPC remote directory.  Save the changes to the file.