Mark / bookmard records in sql 2000 tables
I want syncronize the tables records from multiple database
i have one database in shop no 1 east and second database in shop no 2 west
in the main office i want syncronize some records from tables from the other database into the main office database
how can mark the reocords in the shop no 1 ,2 tables, records which I already have in my main office database so that i can directly read new reocords and get into the table and i can save my time
Re: Mark / bookmard records in sql 2000 tables
Can't you add a boolean value to mark a record if it has been copied or not?
Re: Mark / bookmard records in sql 2000 tables
yes i cant do that, but I am thinking something like bookmark i think access db has bookmark like that i want to do
Re: Mark / bookmard records in sql 2000 tables
You are not using Access. So don't think that way. You should be thinking of Replication