Hi All, I wan't to compare two SQL Server databases. I.e., I wan't to check both databases structure and add if necessary.
Ways to compare and find differences for SQL Server tables and data. In SQL Server 2008. Compare Data Types Between Two Tables. Compare unlimited databases. SQL Server Comparison - Data Tools; SQL Server Comparison - Object Tools; Next Steps. Next time you need to compare your database objects don't waste your time doing it manually. Purchase one of these products or download the free version and give it a try. Most if not all of these vendors offer free trial versions. I'm a fan of SQL DBDiff, which is an open source tool you can use to compare tables, views, functions, users, etc. Of two instances of SQL Server databases and generate a change script between the source and destination databases.
In my project I am using SQL Express database and now we update some fields in the database. So, if we wan't to update the new versions for those customers who are using old database we need to update the database also. 
It is not recommanded that to manually add the fields in the database and is time taking too. So, I wan't to compare two databases(old and new) and update the fields in the old database.
Sql Server Compare Two Databases For Differences
Any confusion in my question plz let me know so that I can be more clear. Thanks for any reply, Narayana Ayyagari.
Hi, thanks for u r reply. Actually my project is windows based so, I cannot allow the customers to connect to the remote database. And this what I wan't to do is for my self not to give to customers. B'coz, when I am updating my customer database I wan't to use this tool to update to new database rather than manually add all the fields and procedures. I wan't to develop such tool which just compares all the tables and if any changes in the new database it will update the old database to the new. Thank you, Narayana Ayyagari. Let me guess, You have a windows base client application which use SQL express database as a relational database to store user data.(Why not use remote/center database?