MS SQL Express comes bundled with the Migrator Pro or DirSync Pro tools to allow rapid deployment of your migration project. It is an option that can be used when creating POC or lab environments. This option may also be selected if the Professional Services personnel deploying the tool determine that the overall size of the migration project can be supported by the SQL Express database.
MS SQL EXPRESS might continue to be used during the course of the migration project, but in some cases the project extends due to the broad size of the migration or new features are added that the DB will grow more than the limitations imposed by Microsoft on it product line up.
The main limitation of MS SQL Express is that the overall database size cannot exceed 10 GB. Once this limit is reached, the tool will no longer be able to add additional migrations or DirSync data, depending on the scenario.
SQL Express is a free license-based product from Microsoft to work with. But Microsoft imposes limitations to the products as follows:
Limitations : Microsoft SQL Server Express supports 1 physical processor, 1 GB memory, and 10 GB maximum relational database storage.
When the maximum value is reached, either in the DirSyncPro/DirSyncProLog DB's the tool will experience erratic Profile operation since it can't add more records to the migrated object or new functionalities to the MPAD product line up and will stop performing.
The best permanent solution will be to migrate the MPAD / DirSync Pro DB's to a MS SQL Standard or Enterprise Edition that is not limited to the restrictions of the SQL Express version.
As an alternative, the SQL Express version can be upgraded to Standard or Enterprise Edition. But that step requires buying out an SQL Standard Edition for the migration project.
