August 24, 2010 at 3:07 am
Dear Experts,
I need to migrate the database from
(Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Data Center Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) (Hypervisor) )
to
(Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) Jul 9 2008 14:17:44 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6001: Service Pack 1) )
If i backup and restore give the error as Compatability issues ,
How can i move the DAtabase from 2008 R2 to 2008
THanks in ADvance
August 24, 2010 at 3:14 am
The only way I know of performing a "downgrade" such as this is to script out your database and all objects in it, recreate it on the destination server, and copy all the data across. You may still run into problems if your database use features available in 2008 R2 but not in 2008.
John
August 24, 2010 at 3:42 am
Second to JOhn..
While scripting out make sure to change the script compatability to 2008..That will make ur job much easier
August 29, 2010 at 9:14 pm
You should be able to use the copy database wizard, but you can't backup/restore, or detach/copy/attach to an older version of SQL Server.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply