Q7780110: Can I migrate the Statistical Database to MS SQL Server Express Edition? If so, how can it be done?

Yes, MS SQL Express Edition is supported.

Migration to MS SQL Server Express Edition can be done in the same way as migrating to MS SQL Server, with only one difference: you MUST specify the instance ID of the SQL Server Express Edition database in the 'Host' field.

For example, if the name of the database server is named 'DbServer01', and the instance id of the database is named 'SQLExpress', then specify 'DbServer01\SQLExpress'.

There's no performance difference between MS SQL Server and MS SQL Server Express. See also FAQ #7780120.

(viewed: 1171)