Tablediff with linked server

• amigoface

  SSC Eights!

  Points: 991

  More actions

  January 26, 2015 at 8:25 pm

  #294266

  Hi,

  i have created a linked server that point to a firebird database,

  everything is fine , i can query the database with something like

  Select * from MYLINKEDSERVER...MYTABLE

  now , can i use tablediff utility with this linked server .

  if yes can you please give me an example .

  i would say also that performance is not very important to me.

  this would be used at the end of the day to make some sort of replication by generating a sql script with datadiff, and run it on a local sql server database and a web based SQL database

  the replication is not an option since i am using a shared web hosting and replication is disabled on it .

  thanks and good day

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  January 27, 2015 at 6:40 am

  #1773368

  I don't think it can be done.

  -- Gianluca Sartori

• amigoface

  SSC Eights!

  Points: 991

  More actions

  January 27, 2015 at 7:11 pm

  #1773545

  yep .

  finally i have created a third sql server database , imported data into from the linked firebird database,

  than run tablediff with the two SqlServer dbs .

  and it seems to work for now 🙂

  i have to do some tests ...