Here is the situation:
I have two different and separate databases and need to refresh data from a table on the source database to the corresponding table on the destination “dest” database.
Facts:
1. The primary platform is MSSQL 7/2000 (butalso needs to work in Sybase Studio and Oracle). So hopefully some generic SQL will work.
2. Simply clearing the data on the dest and coping from the source is too slow and I cannot have the data cleared completely at any time on the dest.
3.I cannot develop synchronization code because I don’t have programmatic control over all of the places need to set a dirty flag, etc on the source data.
4. The dest data never changes or is deleted.
5. Development Language: VB 6
6. The tables and fields are named different in each database.
Are there any programming tips or fancy SQL statements that would make this happen fast?
