Contact Info

Crumbtrail

ActiveXperts.com » Support » Network Monitor » KB Article

 

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: 1185)