-
Website
http://www.emadibrahim.com -
Original page
http://www.emadibrahim.com/2008/07/10/database-schema-compare-upgrade/ -
Subscribe
All Comments -
Community
-
Top Commenters
-
danatkinson
1 comment · 1 points
-
Korayem
3 comments · 1 points
-
dukon21
1 comment · 1 points
-
Mladen Mihajlovic
1 comment · 1 points
-
Chad Myers
3 comments · 1 points
-
-
Popular Threads
.NET Database Migration Tool Roundup
The Schema Comparison tool cannot help you when you are deploying a volatile change, such as adding a new NOT NULL column to a table that has existing data. You have to customize the script. It doesn't handle refactorings where you change the datatype of a column. Again you have to futz with the script.
Migrations capture the evolution of the database and applies these changes safely and in order.
Also I'd like to plug RedGate's SQL Compare, which is far better than DB Pro's Schema Comparison. It does cost money, but then again so does DB Pro.