asked
DB Schema Comparison
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.
Now as SQL Server 2012 is out, also [SQL Server Data Tools][1] are out and are free and support schema compare including change script generation. [1]:
http://msdn.microsoft.com/en-us/data/gg427686
Hi, There is another comprehensive list of schema comparison tools that you can find in this page:
http://www.agile-code.com/blog/choose-your-sql-server-schema-comparison-tool
Hello, Another option you can try is [xSQL Schema Compare][1]. If you are looking to compare tables or view you can use the free Lite Edition. For comparison of other objects, there is also the full version which comes with a two week trial period. [1]:
http://www.xsql.com/products/sql_server_schema_compare/?utm_source=pragmatic&utm_medium=articles&utm_campaign=xsql
6 People are following this question.
