Migrate SQL 2008 R2 Database to SQL Express
Posted on 2013-02-05
We are currently using SQL 2008 R2 in our VMware environment instead of SQL express. We were looking at migrating our existing database from a seperate SQL 2008 Virtual machine to an instance of SQL Express on an our Vsphere Server as our environment is fairly small. What would be the best way to migrate our database from SQL 2008 R2 to SQL Express?
We already attempted to install SQL Management Studio but receive a "Missing Instance ID" error and the searches preformed on migrating SQL databases are all referencing migrating from SQL Express to SQL Standard instead of the other way around.