Return
-
Title
Content Matrix version 9.4 uses SQL for the jobs by default, there is no possibility to use local job.list file anymore? -
Description
Content Matrix version 9.4 uses SQL for the jobs by default, there is no possibility to use local job.list file anymore? -
Cause
This is because SQL CE is no longer supported by Microsoft.
-
Resolution
NOTE: The use of SQL CE in a production environment is discouraged because of the following limitations:
- It uses a single .lst file that is less robust and reliable and may be corrupted after the database reaches 4 GB.
- Data compression is not supported.
- Support for large objects is limited.
- Microsoft support for SQL CE has ended.
If you still want to use SQL CE, SQL Server Compact 4.0 must already be installed on your machine. You can download it from Microsoft, install it, then restart the Console.
NOTE: If you have upgraded from version 9.3 or earlier and are using SQL CE (.lst) files but SQL Server Compact is not installed, a pop-up will display. You will be given the option of either installing SQL Server Compact 4.0 or selecting a different Job database.
More information regarding Metalogix Content Matrix version 9.4 build here.