question

aRookieBIdev avatar image
aRookieBIdev 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
sql-server-2008-r2schemasystem-tablesschema-comparison
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered
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.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Other tools are available. See for more...
1 Like 1 ·
Pavel Pawlowski avatar image
Pavel Pawlowski answered
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
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks for the heads up ..
0 Likes 0 ·
supersonic avatar image
supersonic answered
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
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

endizhupani avatar image
endizhupani answered
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
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.