up vote 0 down vote favorite
share [g+] share [fb]

I created a database using a november CTP preview of MS SQL Server 2008R2. Is it possible to transfer this database to use with older version, SQL Server 2008?

link|improve this question
60% accept rate
Have you tried backing it up on the R2 SQL and restoring on the 2008? Should work. I know 2008 to 2005 doesn't so maybe this is the same. – Campo May 1 '10 at 22:13
No, restoring didn't work. server 2008 showed message that his version is older then the version of server created backup – flashnik May 2 '10 at 6:31
feedback

2 Answers

up vote 1 down vote accepted

No, you can never downgrade by backup/restore or detach/attach

Your best bet is to use the wizard or an SSIS package

From Paul Randall's myth series, item 24h

link|improve this answer
I managed to do it whrough import.export wizard and specifying instances using tcp:ip/instanceName syntax. – flashnik May 3 '10 at 7:46
feedback
up vote 0 down vote

If backup/restore doesn't work, here's a couple of other ideas:

  • BCP the data
  • use replication to copy the data to a 2008 instance
  • if the dataset isn't ridiculously large, write a script to do it
link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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