tags:

views:

81

answers:

1
Q: 

Syncing SQL server 2000 with 2005 -- will DTS still work?

Hi, we have a local staging server running sql server 2000 and a remote public version also running sql server 2000. The remote version will be upgraded to 2005 and I am wondering if the DTS packages we have in place will continue to function between the two machines?

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

We will not be upgrading the local server, and the upgrade of the remote one will be taking place very soon (not in our control).

Thank you!

A: 

If your DTS packages reside on the local server, there shouldn't be an issue (aside from obvious changes to SQL itself (I.E. the old-school joins not working anymore)), and in fact, I've even seen developers save DTS packages on SQL 2005 databases though I'm sure it's not a very good idea.

EDIT: It might also be worthwhile to check out this link for the tools to design/modify DTS packages with SQL Server Management Studio.

Scott Anderson  2009-05-18 23:11:05
An example of an old school join that wouldn't work? Thank you!
aaandre  2009-05-18 23:12:36
The old-style left join syntax was deprecated as of SQL 2005 unless you run your databases in SQL 2000 compatibility mode. Example:SELECT tableA.id, tableB.id FROM tableA, tableB WHERE tableA.id *= tableB.idIn this case, the non-ANSI-standard left outer join (*=) is deprecated. You can still perform joins in the WHERE clause, just not using that *= operator.
Scott Anderson  2009-05-18 23:21:55
Thank you! This is what I needed to know.
aaandre  2009-05-18 23:24:09
You might also check here for a more complete list: http://msdn.microsoft.com/en-us/library/ms144262(SQL.90).aspx
Scott Anderson  2009-05-18 23:24:33

related questions

SQL Server, convert a named instance to default instance?
Natural (human alpha-numeric) sort in Microsoft SQL 2005
In MS SQL Server 2005, is there a way to export, the complete maintenance plan of a database as a SQL Script?
Does ReadUncommitted imply NoLock
Query to list all tables that contain a specific column with SQL Server 2005.
Can I maintain state between calls to a SQL Server UDF?
What are the benefits of using partitions with the Enterprise edition of SQL 2005
Upgrading Sharepoint 3.0 to SQL 2005 Backend?
What's the simplest way to execute a query in Visual C++
Can you perform an AND search of keywords using FREETEXT() on SQL Server 2005?
Create a database from another database?
What's the fastest way to bulk insert a lot of data in SQL Server (C# client)
SQL 2005 Book For Optimization Techniques
How do I create a mapping table in SQL Server Management Studio?
Cannot Add a Sql Server Login
SQL Server 2005 - Export table programatically (run a .sql file to rebuild it)
Diagnosing Deadlocks in SQL Server 2005
SQL2005: Linking a table to multiple tables and retaining Ref Integrity?
How to create a new instance of Sql Server 2005
SQL Server 2008 vs 2005 Linq integration
How do you kill all current connections to a SQL Server 2005 database?
Conditional Visibility and Page Breaks with SQL Server 2005 Reporting Services
SQL Server 2005 and 2008 on same developer machine?
Paging SQL Server 2005 Results
SQL 2005 For XML Explicit - Need help formatting