I am looking for a design pattern / architectural recommendation for my problem:
I need to sync two databases (Master/Detail, just one way). The master db I will connect using ODBC and I will have full control over the detail db, which will be running on SQL2005 and on .NET 3.5 (Upgrades planned but no schedule yet.).
I don't need real time syncronization, 1 sync every two hours would be sufficient.
Any hints/suggestions are much appreciated!
View Complete Post