Hi , I have two productioon databases with similar schema hosted at
different locations.

DB1 is the main business system
DB2 is a cut down version for processing sales on the WWW

The main difference is that customers and products in DB1 have extra
columns used by the business, whereas in DB2 it stores just enough
columns needed to take orders.

I want to periodically update DB2 with information from DB1, for
example if a customer name or product description changes or record
aded, it is marked as updated on DB1 and this change needs to be
replicated on DB2.

Records can be matched on the primary key as DB2 started out as an
exact copy of DB1

Is there any tools that can achieve this ? That will handle Updates &
Inserts.

At the moment we are exporting data from DB1 into CSV, then using a web
application to import it. It loops over the csv calling an update or
insert srtored procedure. It seems a high maintenance solution and is
not automated at all.

Can anyone suggest a better approach that requires less manual tasks
but not SQL replication - due to firewall / vpn / connectivity etc its
not possible to replicate.

Thanks.

Ever growing transaction log, using simple recovery?
Help with efficiently storing a variety nested queries
BEGIN WHILE EOF
EncryptByCert problem
The pains of XML programming