Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

2 Answers 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 http://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

share|improve this answer
1  
How do you "export the data to a SQL query"? –  Mr Bell Jul 24 '11 at 14:53
    
See my edits/links above :) - when using the Generate Scripts method, note that there is a "Script for Database Version", make sure to select SQL Server 2008 in that. –  Ashley Steel Jul 24 '11 at 22:35
    
How'd you go @Mr Bell? –  Ashley Steel Jul 26 '11 at 5:08

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

share|improve this answer
    
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 Steel Jul 26 '11 at 5:10

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.