Database Scripts

With the MYOB Acumatica Customization Platform, you can use custom SQL scripts for the following changes to the database in the scope of a customization project:

  • The creation of custom tables
  • The creation of views, indexes, and other database objects
  • The insertion of data into tables
  • The increasing of the size of a text column of a table

See Changes in the Database Schema for details.

You use the Database Scripts (AU209000) page of the Customization Project Editor to manage Sql and Table items in the customization project.

Note:
An Sql item contains a custom database table definition or a custom SQL script that has to be executed while the customization project is published. A Table item contains a description of the custom columns added to a table for bound custom fields created in the appropriate data access class.

The Database Scripts page displays the list of the custom SQL scripts and customized tables that have been added to the customization project.

When you create a custom table in the database, we recommend that you add the table schema to the customization project, as described in To Add a Custom Table to a Project. To create other database objects or insert data into the tables, you have to compose the corresponding SQL script and add the script to the customization project, as described in To Add a Custom SQL Script to a Project.

On the Database Scripts page, you can perform various operations, as described in the following topics: