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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-01 : 08:53:31
|
| Steve writes "I have a database in SQL Server 6.5 which I transferred to a different server that has SQL Server 2000. With data changes made to the DB on SQL Server 2000, I'd like to bring the data back onto the server with SQL Server 6.5. What, in your opinion would be the easiest way to do that?Would it be easier to upgrade the SQL Server 6.5 to SQL Server 2000 or is there a way to import the data from 2000 to 6.5?Thank you." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-01 : 09:24:08
|
| You should be able to create a DTS package (on SQL 2000) and transfer the data into the 6.5 server. I've done this with 7.0 and 6.5 a number of times with no problems.I would recommend that you upgrade the 6.5 machine to 2000 as soon as you can, since there are so many differences between the two, you'll probably go mad keeping them straight. |
 |
|
|
|
|
|
SQL Server 2000 back into SQL Server 6.5 transfer