Raoshan,
We're using Apex SQL Diff from
http://apexsql.com/sql_tools_diff.htm to syncronize databases on development and production servers. They have 14 days fully functional evaluation version.
There're other similar products on the market. See
http://red-gate.com/sql/summary.htm, for example.
>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.
>
--sb--