I am writing a small functionality into Navision which will transfer data from 1 db to another db using ado
user will be able to configure himself, which tables and filters etc. like sales order for this department should be copied into another db.
it will generate sql script and execute.
It works fine but....getting some issues like
if in table 'Payment Terms' I got 5 records and other db has 3 then it should transfer only 2 records.
this should also work on SO, PO etc. which has different primary keys
I don't want to loop through records and update 1 by 1
Also timestamp is causing problem so I have to add fields names in sql script
Any suggestion please