howto compare and sychronize dbs located at customers...

Hi,

We develop software with a sql server 2000 db as a datasource.

The applications are installed at customers network. So we can not

create an ODBC connection to it. We can login using rdp for most customers..
.

We have (locally) a master db with the latest changes made to the model.



Question is how can compare and synchronize the local master db with de

dbs located at the cusomers.



I am aware of some beutiful tools but you must connect to both dbs.

That is not possible in our case. We als want to install as less as possible
at the customers server...



Any ideas???

Cheers Jan

That depends on the overhead you want to produce over the wire. The
best thing would be then to ship or send the to be compared database to
the customer (or vice vera), then attach it to a SQL Server and compare
it with the mentioned tools, like those from redgate. Another thing,
but not that trustworthy would be to create a lowweight comparable
snapshot of the database (like making binary checksums for every row in
a table).

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---