# Saturday, February 02, 2008
« RhinoMocks DoNotExpect.Call() Added | Main | Initial Commit - SQL Migration Tool »
SQL Migration Tool Requirements

What would the minimum set of features be to create a SQL Schema Migration tool?

Add FK Contraints
Remove FK Contraints

Add Non-Clustered Indexes
Remove Non-Clustered Indexes

Add Tables
Remove Tables

Add Columns
Remove Columns

Add Sprocs
Remove Sprocs
Alter Sprocs

Add Views
Remove Views
Alter Views

LHS is a dependency of the RHS

Add dependency order (removal dependency order is the opposite):
Tables -> Columns -> FKs -> Views -> Sprocs

Are there other common scenarios I'm not think about?  Like changing the nullability of a column or adding/removing a default?

SQL Server
Saturday, February 02, 2008 11:03:23 PM (GMT Standard Time, UTC+00:00)  #    Disclaimer  |  Comments [0]  |  Related posts:
XML Data Migrations for SQL Server
Validating SQL Scripts on Checkin
Initial Commit - SQL Migration Tool
Join SQL Server Table to FTP Directory
SMO ScriptDrops = true Bug
Force DB Drop
 Tracked by:
"Initial Commit - SQL Migration Tool" (Sneal's Blog) [Trackback]
Comments are closed.