I have my local dev box running Sql Server 2008 R2. Sadly the hosting company I am using does not support R2 yet and I need to get my database converted to a regular 2008 database.
Should I be able to run both a 2008 r2 and a regular 2008 on the same server? I am hoping that if I can run both at the same time and then use Management studio's export wizard to move the data over to the new 2008 database.
Is it possible to use the export wizard with a sql server compact file? If I can do that then I could move the data to a compact db and take it over to another computer with 2008 installed and import the data out of it.