April 7, 2006 at 2:06 am
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 Jungerius
April 7, 2006 at 8:58 am
Jan,
There is no easy way to do this. Something needs to connect to both servers and compare the data. You could send your master db to the customers and run the comparison at each site using scripts or purchasing a tool.
RDP is a "view" tool. A way to view the remote server. There is no way to have SQL Server read and change data through RDP.
April 11, 2006 at 1:17 am
Steve,
That is indeed a solution. Problem with this solution (copy the master db to customer) is that we need to install the db compare/synchronize tool at the customer. This is hard to maintain and what about licences...
It would be esier to make a data model snapshot at the customer, copy this to our server, compare and make a synchronization script, copy script to client, execute script...
As you see not a very nice solution if you have a lot customers and a few updates a year...
Jan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply