Hi , I have a situation where there is a change in the db schema. My initial database is DB1 and now there is a new version available DB2. What i am intending to do is to put a script together which will compare the to datamarts and find the new db objects and also show the changes in the existing db objects like data type changes in fields or new fields added or fields removed. First of all I would like to know if this is possible? If any of you had done this using a tool or a query kindly let me know . If you have a solution pls to do share with me . Thanks in advance , Kannan
There are lots of tools available for this kind of comparison - Red Gate SQL Compare - Atlantis Interactive Schema Inspector - Idera SQL comparison toolset - Schema Comparison in Visual Studio Team Edition for Database Professionals Some are free, some have trial versions and some are fully paid - I'll leave it to you to pick what is best for your scenario.