How to upgrade to SQL Server Compact Edition 4

Background

Meridian Enterprise versions prior to 2015 support Microsoft SQL Server Compact Edition 3.5 on the server for the external tables and user database and on the clients for local workspace. Meridian Enterprise 2015 and later support Microsoft SQL Server Compact Edition 3.5 and 4.0.

Description

Using SQL Server Compact Edition 4.0 with Meridian Enterprise requires some manual configuration and the server databases to be converted with a special tool. The databases can be converted without SQL Server Compact Edition 3.5 installed or with versions 3.5 and 4.0 installed side-by-side.

To upgrade to SQL Server Compact Edition 4.0:

1. Install SQL Server Compact Edition 4.0 on the server or client computer.

2. On the Meridian server, in the Windows registry, set the TablesDBSqlCeProvider value of the following key to Microsoft.SQLSERVER.CE.OLEDB.4.0

   HKEY_LOCAL_MACHINE\Software\Cyco\AutoManager Meridian\CurrentVersion\Server

3. Also in the Meridian server registry, set the UserDBSqlCeProvider value of the following key to Microsoft.SQLSERVER.CE.OLEDB.4.0

   HKEY_LOCAL_MACHINE\Software\Cyco\AutoManager Meridian\CurrentVersion\Server\UserDatabase

4. On the Meridian server, convert each external tables database <VaultName>$LL.sdf and the user database ICUserDB.sdf from 3.5 to 4.0 with the following tool:

   C:\Program Files\BC-Meridian\Tools\BlueCieloECM.SdfUpdate.exe <SourceFile> <DestinationFile> [-P<Password>].

5. On each Meridian client PC, delete the local workspace database located at:

   C:\BC-WorkSpace\<UserName>\<VaultContext>\__$$Environment\__$$Vault.sdf

   A new local workspace database in SQL Server Compact Edition 4.0 format will be created automatically when needed.

6. Also on each Meridian client PC, change the WorkSpaceDB value of the following keys to 4:

   HKEY_LOCAL_MACHINE\Software\Cyco\AutoManager Meridian\CurrentVersion\Client
   HKEY_LOCAL_MACHINE\Software\Wow6432Node\Cyco\AutoManager Meridian\CurrentVersion\Client