SQL scripts for creating system tables
Use the scripts described in the following table to create Marketing Platform system tables manually, when your company policy does not allow you to use the installer to create them automatically.
The scripts are shown in the order in which you must run them.
Datasource Type | Script Names |
---|---|
IBM® DB2® |
|
Microsoft™ SQL Server |
|
Oracle |
|
If you plan to use the scheduler feature that enables you to configure a flowchart to run at predefined intervals, you must also create the tables that support this feature. To create the scheduler tables, run the appropriate script, as described in the following table.
Data Source Type | Script Name |
---|---|
IBM DB2 | quartz_db2.sql |
Microsoft SQL Server | quartz_sqlServer.sql |
Oracle | quartz_oracle.sql |
When to use the create system tables scripts
You must use these scripts when you install or upgrade Marketing Platform if you have not allowed the installer to create the system tables automatically, or if you have used ManagerSchema_DropAll.sql to delete all Marketing Platform system tables from your database.