Database Setup

Use the Database Setup screen to:

  • Set up new system and company databases for use with Sage 300.
  • Configure the Sage 300 portal database, if you installed portal components when you installed the program.
  • View a list of existing Sage 300 databases.
  • Assign or clear company colors for all companies.
  • Edit, delete, or verify existing databases you have set up.
  • Set global security for your company.

You must create system, company, and portal databases using your database software before you can set them up for Sage 300.

Once you create system, company, and portal databases, you use Database Setup to register the databases for use by Sage 300 and create the database tables that Sage 300 requires.

You can also extract data from an existing database, load extracted data into a second database, and transfer data between two databases.