Activity overview
Latest activity by sethpetryjohnson
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...
"Object reference not set to an instance of an object" error
When I compare a live database to a scripts folder I get an error at the end of the comparison. The error is "Object reference not set to an instance of an object" and it occurs during the "Registe...