Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2011-01-19 : 07:26:55
|
| I need to move a sql2008 database back to 2005 in the most efficient way how can I do this? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-01-19 : 08:20:07
|
There is no easy way to do that.You have to script and do the export/import and so on...
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2011-01-19 : 08:39:31
|
| export &import through dts? is that the best way? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2011-01-19 : 09:31:09
|
| problem is i'm going back to 2005I moved the database on sunday to 2008 i want to move it back -- is there anyway to just move the new records or I should truncate each table and move? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-01-19 : 09:34:47
|
If it is possible to filter the new records then maybe you can insert them into the 2005 db using a linked server.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-01-19 : 20:54:47
|
| As others have already posted, the only way is to export and import.I am wondering what issues you have run into that require you to move back to 2005?Jeff |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2011-01-20 : 02:26:29
|
| I ended up using a redgate program to move the changed datathe problem is that i'm using this from a office that doesn't have a good adsl connection so the database must sit logally. Ideally I would like to synchronize from the 2005 to the 2008 but I had issues doing that. |
|
|
|
|
|
|
help need to move sql 2008 database back to 2005