February 6, 2013 at 8:47 am
Hello,
I wonder if i can migrate an SQL server 2012 database to SQL server 2008. I tried using sql server publishing wizard but its compatible with 2005 only, cant even connect to SQL server 11.0.2100. I tried backing up the whole database with BACKUP DATABASE statement then tried to open it with sql server 2008 ofcourse it did not work. Then I created the database schema in sql server 2008 but i cannot get the data into it.
Is there any way to get the whole database ?
Thank you.
February 6, 2013 at 8:49 am
Use the import export data wizard to import the data.
February 6, 2013 at 9:03 am
Just be sure you're using no data types in the newer server that can't exist in the older (or other code constructs). You should be able to export the scripts to build the database and then run those scripts on the older version (assuming step 1).
If you get really stuck, you might take a look at Red Gate SQL Compare & SQL Data Compare. They can do that for you.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 6, 2013 at 9:09 am
I've tried it too. it creates an error : "the attempt to add a row to the data flow task buffer failed with the error code 0xC0047020" follows the SSIS Error Code and so on...
i guess its memory problem, is it?
February 6, 2013 at 9:41 am
Grant Fritchey (2/6/2013)
Just be sure you're using no data types in the newer server that can't exist in the older (or other code constructs). You should be able to export the scripts to build the database and then run those scripts on the older version (assuming step 1).If you get really stuck, you might take a look at Red Gate SQL Compare & SQL Data Compare. They can do that for you.
Thank you.
There is no any newer data type in the newer server however just to be sure now im trying Red Gate.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply