Comparison of an Access 2003 linked server

deaconbdeaconb Posts: 2
edited July 21, 2009 11:56AM in SQL Data Compare Previous Versions
Is it possible to perform a data comparison of a linked server? I have an Access 2003 database that I would desperately like to compare to its SQL server replacement, but after trying several different Database syntaxes I can't seem to connect to my linked server via SQL Data Compare.

Is comparison of a linked server even possible?

TIA

Rick
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Rick,

    I'm afraid the answer at this time is no. SQL Data Compare only works with native SQL Server drivers, and therefore can't do distributed queries through linked servers, not even if the linked server points at another SQL Server.

    If we could put ODBC support in, this could work, but that would most likely get done way, way down the road.
    · Share on Twitter
Sign In or Register to comment.