Local database and Remote Database
Posted: Sun Jul 23, 2006 8:38 pm
Remote database is connected through odbc connection and the local database i am currently using is mysql.
For the time being all the data is stored in the remote database.
1) i would want to copy only data that is not found in local database from the remote database. Is there anyway i can do that ??
For example the remote database contain table A and the local database contain table A as well.
Currently both table contain 100 records.
If 3 new record is added to table A at the remote database, i would want this record to be updated in table A on the local database as well.
how can i make a query to compare table A in remote database with table A on the local database and copy those records that are not found in the local database ??
For the time being all the data is stored in the remote database.
1) i would want to copy only data that is not found in local database from the remote database. Is there anyway i can do that ??
For example the remote database contain table A and the local database contain table A as well.
Currently both table contain 100 records.
If 3 new record is added to table A at the remote database, i would want this record to be updated in table A on the local database as well.
how can i make a query to compare table A in remote database with table A on the local database and copy those records that are not found in the local database ??