Database scripts

If you choose to create a script, the Views database utility creates two script files. For Microsoft SQL Server, the scripts are named:

  • database name_View Initialize_SQLServer.sql
  • database name_ViewDefine_SQLServer.sql

For Oracle, the scripts are named:

  • database name_View Initialize_Oracle.sql
  • database name_ViewDefine_Oracle.sql

For example, if you specify CPMViews as the database name and Oracle as the database type. The file names would be:

  • CPMViews_ViewInitialize_Oracle.sql
  • CPMViews_ViewDefine_Oracle.sql.