Monday, March 12, 2012

Move SQL 2000 Data To SQL 7

We have a problem with our SQL 2000 server which we know is a product bug.
Is there anyway of importing, Copying the sql 2000 table back down to SQL 7 until the issue is resolved,
many thanksMy first suggestion would be the DTS Wizard (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_tools_wiz_9e5g.asp). You can use a Linked Server (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_4uuq.asp), but it is a lot more work than a simple DTS package that does the same job in most cases.

-PatP

No comments:

Post a Comment