About DBEdit

DBEdit is a Trapeze utility that manages databases used by Trapeze software.

DBEdit allows you to:

• Compare the Trapeze database with your database to ensure that they are structurally compatible.
• Edit the data structure.
• Import data.
• Create, edit, and execute data queries.

DBEdit supports importing and exporting data to/from Microsoft SQL, Microsoft Access, and Oracle. If your site does not have a database, you must create an empty database in either Oracle or Microsoft SQL. For more information, refer to the documentation for those applications.

Importing or exporting to or from a Microsoft Access database has the following limitations:

• While DBEdit supports Triggers, Views, and Stored Procedures, Microsoft Access does not support these procedures. If a table contains Triggers, the table will be created in Microsoft Access without them. This is useful when you only want to export the data to Microsoft Access.
• Some database tables may not be created because they contain column names that are reserved words in Microsoft Access.
• Permission granting will not be applied when connected to Access.