Riyaz,
We are using SQL Compare from
www.red-gate.com. This tool will compare two databases and generate update scripts. They also have a tool that allows you to synch data. I highly recommend it.
Hope this helps.
Daniel
>hi
>what is the best way to update all the changes in the Sql Database of the client, already having data in it.
>By running the script all the data will be lost,so how to update the database with new tables and stored procedures and alteration in existing tables without running the script.
>
>please help me in this regard
>
>Riyaz Patanwala
>Dubai
>U.A.E.
Daniel