Have Geek Brain

Synchronizing SQL Server 2000 with 2005 - Will DTS Work?

we have a local staging server running SQL Server 2000 as well as a remote open source version also running on sql 2000 server. The remote version will be updated to 2005 and I'm wondering if the DTS packages we have will continue to function between the two cars?

If not, what would be the easiest and most efficient way to sync between the two?

We will not update the local server and the remote will be updated very soon (not at our disposal).

Thanks!

0


a source to share


1 answer


If your DTS packages are on a local server, there should be no problem (other than obvious changes to SQL itself (IE, old school doesn't work anymore)), and in fact I've even seen developers save DTS packages on SQL 2005 bases, although I'm pretty sure that's not a good idea.



EDIT: It might also be worth checking this link for tools to develop / modify DTS packages using SQL Server Management Studio.

0


a source






More articles:


All Articles