How can we help you today? How can we help you today?

Comparison of an Access 2003 linked server

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
deaconb
0

Comments

1 comment

Sort by
  • Brian Donahue
    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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.