Monday, March 26, 2012

Moving a database from 2005 Express to Enterprise

If I detach a database from an instance of SQL Server 2005 Express and attach it to an instance of SQL Server 2005 Enterprise, will the database be essentially identical to one initially created under 2005 Enterprise, or will some Express edition limitation follow the database from the original instance to the new one?

Thanks,
Peter Nyberg

The on-disk structures will be identical, so you should have no problems. Only thing to keep in mind would be the possible features available in enterprise not available for use in express (for example, if you make use of indexed views, enterprise's optimizer will automatically consider them whereas express's won't)...but, given that you're moving from express, you are probably not making use of things like that anyhow.

HTH

No comments:

Post a Comment