SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 link server between sql 2005 to sql 2012
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

leeorp
Starting Member

Israel
4 Posts

Posted - 12/30/2013 :  03:37:58  Show Profile  Reply with Quote
Hi,

I will clarify my last question.

I have installed ne SQL 2012 server, and recovered old SQL 2005 database to him.

Untill i will drop the old SQL server 2005 server, i want to create link between the SQL server 2005 and the SQL server 2012.

When i am established the link, i have noticed that i cannot see theim, recoverd database i have deploy to the new SQL 2012.

I have tryed numerous of solutions, but still all the tables from the recoverd database on the new 2012 cannot be seen.

I created new database on the SQL 2012, and i can see the tables on him, but still the old recovered database is not returning me the tables.

Please advise

sincerely
Leeor Petrover

tkizer
Almighty SQL Goddess

USA
36611 Posts

Posted - 12/30/2013 :  13:25:13  Show Profile  Visit tkizer's Homepage  Reply with Quote
Are you able to run queries on those tables? I suspect that your issue is just with browsing those tables but that they are still accessible if you run a SELECT against them. This is likely a database driver issue.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

leeorp
Starting Member

Israel
4 Posts

Posted - 12/31/2013 :  02:27:43  Show Profile  Reply with Quote
Hi,

Just for the knowledge:

The answer is to install the Native Client of the SQL server 2005, on the SQL 2012 server.

Then there will be no problem to established the link between the SQL server 2005 and the SQL server 2012 - (referring to restore database with compatibility mode of SQL 2005 on SQL server 2012)

Leeor

quote:
Originally posted by tkizer

Are you able to run queries on those tables? I suspect that your issue is just with browsing those tables but that they are still accessible if you run a SELECT against them. This is likely a database driver issue.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/



sincerely
Leeor Petrover

Edited by - leeorp on 01/01/2014 10:21:32
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000