Can I connect SQL Server 2000 with SQL Server 2005 instances?

Is it possible to set up linked server connections from SQL Server 2005 instances to SQL Server 2000 instances?

    Requires Free Membership to View

Yes, it is. You can set up a linked server from SQL Server 2005 to any valid ODBC data source, including SQL Server 2000 or even competitors' databases such as Oracle or DB2. This can be a great way to copy data between databases as you upgrade.

This was first published in December 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.