DISQUS

Community Page on DISQUS

what is this?

Jump to original thread »
Author

Database Schema Compare & Upgrade

Started by eibrahim · 3 months ago

I spent a few days playing with Ruby on Rails a while back.  During the learning experience, there was one particular feature that I really liked.  It was the database migration scripts that get automatically generated for you.  I always wished I had something like ... Continue reading »

1 comment

  • The Database comparison tools in DB Pro really aren't migrations. If you're looking for that, check out my post comparing some .NET Migrations here:
    .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.

Add New Comment

Returning? Login