Running scripts from SQL Compare
- Create table objects first then create rest of database objects.
- Not NULL column definition – put in a default value.
- Object Reference error – Drop referenced object and then drop the object. Recreate object and then recreate the referenced object.
- Errors in general – comment out specific sections until run successfully, then come back to run specific sections one by one.