General information
Forum:
Microsoft SQL Server
Title:
How to compare two approx similar databases
Hi All,
I've developed an VFP 7.0 application with the SQL Server 2000 Database, and deployed the same to so many clients.
Now I've done so many structure changes at my side in the sample data for the application. It is a very big problem how to update the client's data with the latest structure changes, either I've to go to each client, find out the mismatch and update the client's data..... so combersome.
Is there any automated way to do the same. Is there any method to compare two databases to produre a SQL script with the changes, so that I've to only RUN that script... ?
Or is there any other possible way to do this... ?
I'm stuck in the middle... pl help me out.
Thanks
Raoshan
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only