SQL Script

If you are not using the MSDE database included with the EFT Server installer, refer to Using a SQL Database as the Auditing Database for information about using SQL as the database. Administrators that prefer using command-line tools can use oSQL to create the auditing database and tables.

Refer to the procedure in Alternative Method for Creating EFT Database Tables on SQL for the procedure for creating EFT Server database tables on SQL.

For PCI DS HSS tables, refer to PCI DSS HS in the Auditing Database.

For AS2 tables, refer to AS2 SQL Script.

The SQL script is installed in the Server directory, Reports subfolder (e.g., C:\Program Files\GlobalSCAPE\EFT\Reports\ARM_DBScript_1_1.sql).

Refer to ARM Schema for a list of tables.