Need a custom Windows service that synchronizes data between 2 MS SQL dbs

We need a custom Windows service that will synchronize data between 2 MS SQL databases that are hosted in 2 physically different data centers. pseudo code: for each table in list { INSERT if row doesn't exist in target DB UPDATE if row exists in target DB } * I should be able to specify 2 sql connection strings (1 source, 1 target) * I should be able to specify the time interval for synchronization (e.g. last 5 min, 10 min, 15 min, 30 min, 1 hour) * The service should automatically run based on the chosen time interval * I should be able to specify a list of tables to be synchronized (from source to target DB) * For each table that needs to be synchronized I should be able to specify the primary key columns (consider composite keys) and the name of the mod datetime column that will be used to determine which rows need to be synchronized (e.g. all rows modified within the last x min ==> which I will have specified and saved in settings). If not specified then every row needs to be synchronized. In other words, all rows will be removed from target DB and repopulated with rows from source DB in that case. * I do not want to have to list all columns. The service should dynamically read the table definitions and execute the appropriate INSERT/UPDATE statements dynamically. We don't hard-DELETE any records. You don't need to worry about the target DB and the source DB schemas getting out of synch either. We'll take care of that manually. In other words, whenever we modify any DB object in the source DB, we'll make the same change in the target DB also. We just need data synchronized. Don't worry about any other DB objects. If for some reason if the two DBs get out of synch and the service fails because of that, we'll troubleshoot and fix it ourselves. * Our DB isn't very relational and there's little referential integrity enforced because it was designed and implemented over 10 years ago and many DB objects have changed over time. So don't worry about RI either. As long as the service processes the tables in the order we specified, it should be pretty straightforward to synchronize data. Again, if any issue arises because of some RI constraints, we'll troubleshoot and fix it from our side. * Perfectly fine with saving settings in some type of config file (human redable is OK, encryption not necessary) * Data integrity IS VERY IMPORTANT * We use MS SQL Server 2008 only (no plans to upgrade or change our RDBMS any time soon) * If there's **any** exception we want to be notified via email w/ full exception stack messages Before you suggest that we use MS SQL built-in replications or even SymmetricDS, we've considered and even tried some of those tools already. For us, we decided we need a small Windows service to do this job. We need this in a week. ***The solution must be compatible with Visual Studio 2010!! Payment will be released immediately once the service successfully synchronizes our DB once.