patternsqlMinor
Linked Server to SQL Server 2000 server from SQL Server 2012
Viewed 0 times
20002012sqlserverfromlinked
Problem
I have a new SQL Server 2012 instance, and am migrating a database from SQL Server 2000. Some of the stored procedures in the DB I am moving reference another database back on that 2000 server. What is the best way to handle this?
Would a linked server help? I am having trouble creating a link for testing. Some people recommend using ODBC, others seem to use the SQL Server 10 client driver (SQLNCLI10). Using the SQL Server 10 client driver seems better to me, are there issues installing it on a SQL Server 2012 instance?
Would a linked server help? I am having trouble creating a link for testing. Some people recommend using ODBC, others seem to use the SQL Server 10 client driver (SQLNCLI10). Using the SQL Server 10 client driver seems better to me, are there issues installing it on a SQL Server 2012 instance?
Solution
Be careful when using SQLNCLI10 as described in connect item
A workaround can be found here
You have to first test the application that is using such SP's from 2012 to 2000. It also depends on where both server's are located and how much data you are pulling out using Linked Servers.
Is there a reason that the other referenced databases cannot be moved to 2012 ?
A workaround can be found here
You have to first test the application that is using such SP's from 2012 to 2000. It also depends on where both server's are located and how much data you are pulling out using Linked Servers.
Is there a reason that the other referenced databases cannot be moved to 2012 ?
Context
StackExchange Database Administrators Q#39572, answer score: 5
Revisions (0)
No revisions yet.