My use case here is mainly for stored procedures (I'd like to track and migrate them via SchemaUpdate). The 'dialect-scope' thing makes it a very attractive way to do that, since stored procs are so vendor specific.
So, I'd either always run the drop and then create for database objects or potentially add a 'check' or 'validate' script to a database-object that would be used by SchemaUpdate (and SchemaValidate) to determine if the object is already there.
Although, I may be missing something entirely. Is there another way to track stored procedures?
|