SQL Compare Scripts Execution

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.