DS-Client Database Migration (from MSDE to SQL Server 2005/2008 Express)
Creation Date: November 28, 2007
Revision Date: May 10, 2010
Product: DS‑Client (Windows)
Introduction
The following options are available if you want to migrate a DS-Client database from MSDE to SQL Server 2005/2008 Express. MSDE is no longer supported as a database instance for DS-Client installations. If you have an older version of DS-Client running with MSDE, you must migrate the database before you can upgrade the DS-Client.
NOTE: SQL Server 2005/2008 Express has a 4GB database limit.
Option 1 - Migrate by importing DB files to a new Instance
1. Run a Daily Admin. This will back up the DS-Client databases to the DS-System.
2. Stop DS-Client Service.
3. Back up (dump) all three DS-Client databases (dsclient, dsdelta and dslanfiles). You can also use the dump files created by the Daily Admin in step 1 (if the DS-Client is configured to store them in the DS-Client Buffer).
4. Install a SQL Server 2005/2008 Express instance (free download of the latest Service Pack).
5. Obtain Microsoft SQL 2005/2008 Management Studio Express (download from http://www.microsoft.com).
6. Using the Studio Express tools, restore all three DS-Client databases (from the dump files in step 3) to the new SQL Server 2005/2008 Express instance.
7. Reconfigure the Registry Keys on the DS-Client computer, to use the new SQL 2005/2008 Express instance (where you have restored the DS-Client databases).
a) In the Registry
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\DS-Client:
Provide the path for the database:
Parameters\Database=\\MACHINE_NAME\INSTANCE_NAME\dsclient
NOTE: To view the instance names that are running, type ‘osql –L ‘ from the Command Prompt. This will list all the running database instances.
b) Change the Dependency for DS-Client service by modifying the value DependOnService from “MSSQL$MSDE_INSTANCE” to “MSSQL$SQLEXPRESS”.
8. Start DS-Client Service.
9. Run Daily Admin to test the connection with the DS-System. Verify there are no errors in the Activity Log.
Option 2 - Migrate by upgrading the DB Instance
1. Run a Daily Admin. This will back up the DS-Client databases to the DS-System.
2. Stop DS-Client Service.
3. Install SQL Server 2005/2008 Express (free download of the latest Service Pack).
Running the SQL Server 2005/2008 Express installation over the MSDE instance is NOT sufficient to perform a successful upgrade.
• Follow the instructions for installation using the skuupgrade parameter, which you can find at:
https://msdn2.microsoft.com/en-us/library/ms144259.aspx#skuupgrade
4. After a successful upgrade, start the SQL Server 2005/2008 Express instance.
5. Start the DS-Client service.
6. Run Daily Admin to test the connection with the DS-System. Verify there are no errors in the Activity Log.