Schema Groups

Schema Groups

You can use Schema Groups to install multiple schemas into the same database.

Sometimes you have more than one program or component that needs to install SQL into a database. You may also want to manage their schemas separately (perhaps on a separate release cycle).

For example, you have two components in your application. A user membership library and your application code. They both have their own SQL schema.

You could concatenate the schemas and install them:

InsightInstaller -s proddb -db mydatabase user.sql app.sql

In this case the SQL is installed together. That means Insight will track all of the schema objects as one unit and always has to be modified together.

By putting them in separate schema groups, you can install the schemas on their own.

InsightInstaller -s proddb -db mydatabase -g user user.sql
InsightInstaller -s proddb -db mydatabase -g app app.sql

Specifying a schema group just lets you install and upgrade these separately. Insight is smart enough to manage any dependencies between the two. For example, if app.sql has a FK constraint back to user.sql, Insight will properly manage the constraint if you modify either side of the constraint.