Comparison of an Access 2003 linked server

deaconbdeaconb Posts: 2
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

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.
Sign In or Register to comment.