SQL Server 2008 R2 Express is installed on Machine A. I just installed SQL Server 2008 R2 Developer Edition on Machine B. I made a back up on Machine A. I copied the .bak file to Machine B. Using Management Studio I create an empty database on Machine B
with the same name as the Database I had backed up on Machine A. Still using Management Studion I tried to restore the Backup from Machine A to Machine B. I received the Following error:
The Database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running 10.00.1600...
First, I find this message confusing. I though the Developer edition was the equivilent of the Enterprise Edition. Going on the assumption (yeah, I know) it strikes me as odd that the Express Edition has a higher version number, 50, than the Developer Edition,
00. Am I reading that correctly?
The real question here is how do I move a database from the Express Machine to the Developer machine? Neither is a production database so there are no time constraints such as Customer ordering will be down while I do the copy.
Thanks in advance for your help.
View Complete Post