July 7, 2012 at 1:47 am
Hello Every Body,
I have a database which is Developed in SQL Server 2008 R2, but now I want to attache it in SQL Server 2008. Can any one help me how can I do so.
July 7, 2012 at 2:53 am
SQL Server 2008 R2 bumps the database version.
As a general rule: Always develop databases on the lowest version you support. And don't expect to be able to restore or re-attach a database to an eearlier edition of SQL Server.
There are several tools available which can transfer database content (both structures and data), but these are very slow compared to attach restore.
July 7, 2012 at 9:04 am
I think it is not possible, you can also have at the below link.
Regards
S.R.Kundur
July 8, 2012 at 4:48 am
Hi,
Restoring backup is only forward-compatible.
You may achieve your goal if you can upgrade your 2008 version to 2008r2
Regards
IgorMi
Igor Micev,My blog: www.igormicev.com
July 8, 2012 at 3:16 pm
Your best bet here would be to script out the database (schema and data, if you so choose) on your source 2008 R2 instance, and run the script against your 2008 instance. It goes without saying, but you'll have to make sure that nothing is leveraged that isn't available in the older version. Otherwise you'll have conflicts.
But scripting out, and running the script is the easiest way to go to an older version if the implemented database functionality allows.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply