Upgrade External Tables to Microsoft Access

With SQL Compact reaching End of Life status, Microsoft Access is now used as the default provider to store Table Data as of the Meridian 2022 release. Since many of our customers use SQL Compact, we have provided a tool that can be used to convert your tables to Microsoft Access.

To learn more about how this change affects Meridian, see our KnowledgeBase article about this topic.

Note:

You must first install Microsoft SQL Server Compact Edition 4.0 before using the conversion tool. Edition 3.5 is still required for installation. Both may be installed simultaneously.

To convert a lookup tables database:

Stop the AutoManager EDM Server service.
Navigate to the C:\Meridian Extensions\<VaultName> folder.
Run the following command in a Windows command prompt:
```
"C:\Program Files\BC-Meridian\Program\BlueCieloECM.SdfToMdbConvertor.exe" <VaultName>$LL.sdf -TTAB
```
The Microsoft Access database file (.mdb) is generated.
Navigate to HKEY_LOCAL_MACHINE\Software\Cyco\AutoManager Meridian\CurrentVersion\Server.
Set the TablesDB registry setting to 0.

If you are upgrading Meridian from a previous version, this step is required.
Restart the AutoManager EDM Server service.

Your changes take effect.
Verify that the correct data is available in Meridian Enterprise and then remove the SQL Compact database files.

The existence of lookup list databases can cause errors if queries exist in the vault script.