Dealing with Scripted SQL

Dealing with Scripted SQL

Insight is designed to work best with people who write their own SQL, rather than using tools, but sometimes you just want to use a designer to build your database, then export the script. Insight supports most of these scenarios.

However, sometimes Insight doesn't like the SQL that SQL Management Studio generated. Here are a few rules to help you clean it up for Insight:

• Each schema object (table, proc, index, type, etc.) should be separated by a GO keyword.
• Delete all of the setup code that SQL Studio generates like ANSI_PADDING and all of that. Set up your database to have appropriate defaults if you really need that.

If you still have problems using a script with Insight, open an issue and we can try to see if we can get your script supported.