1

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.

Mr Bell
  • 111
  • 2

2 Answers2

2

I would export the data to a SQL query from SQL Management Studio, import that into the hosting provider's 2008 instance, then export that new database (via backup) and import it into your local instance. When you do that, your local instance will run the database in 2008 compatibility mode.

This answer here should help you with dumping a database to .SQL https://stackoverflow.com/questions/20363/sql-server-2005-export-table-programatically-run-a-sql-file-to-rebuild-it/1135529#1135529

Either that or the tool referenced in this post: Dump Microsoft SQL Server database to an SQL script

Community
  • 1
Ashley
  • 650
  • 1
  • 6
  • 15
1

Just to add, yes, you can run different versions of SQL Server on the same machine, it only has to be different instances.

Nienor
  • 136
  • 2
  • I wouldn't recommend it though... SQL loves to eat RAM and disk IO (unless you limit its memory footprint in the configuration) and would make for a slow machine since you're using it for development – Ashley Jul 26 '11 at 05:10