September 16, 2013 at 4:30 am
Hi All,
I have "Quiz database" in sql server 2012, Now i want copy same database in another 2008 server(SQL server 2008)
I used copy database option but while execution it is throwing error.
Note: I have not implemented any 2012 features in "QUIZ" database. earlier it take backup from 2008 and restored in 2012 server. Now it is not working back-word restoration.
Is there any third-party tool to do this operation.
Regards,
RR
September 16, 2013 at 5:15 am
Even if you have a 2012 database in 2008 compatability mode, it's still a 2012 database internally, and therefore incompatible with 2008. Possibly the most straightforward way would be to use SSIS to do the transfer
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
September 16, 2013 at 5:52 am
andrew gothard (9/16/2013)
Even if you have a 2012 database in 2008 compatability mode, it's still a 2012 database internally, and therefore incompatible with 2008. Possibly the most straightforward way would be to use SSIS to do the transfer
I used "Transfor Dtabase Task" transformation in SSIS, it is also not working , it is showing source and destination comparability level issue .
September 16, 2013 at 5:55 am
Rather than Copying the Database Copy from SQL 2012 to SQL 2008, please try import/ export utility & transfer the Tables Views & Functions....
You can also use Generate Scripts & move Store Procedure ...
************************************
Every Dog has a Tail !!!!! :-D
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply