Comments
Sort by recent activity
My scripts folder is organized into Function, View, Table, etc. folders. We added an additional folder called "Migration Scripts" to store custom data migration scripts that pertain to a specific changeset. (The entire folder structure is version controlled)
It seems pretty obvious to me now, but storing these scripts in the same directory structure as our actual DDL files is a bad idea. SQL Compare examines the entire directory structure looking for script files defining objects to compare and apparently gets tripped up by the migration scripts.
The solution: either store migration scripts up one level in the tree, so the don't exist in SQL Compare's target directory, or just wrap the migration scripts in comment tags. / comments
My scripts folder is organized into Function, View, Table, etc. folders. We added an additional folder called "Migration Scripts" to store custom data migration scripts that pertain to a specific c...