Execute Database Scripts
- Right-click on the newly created database and select the Query Tool option.Query Tool
- Maximize the pgAdmin4 window.
- Click the Folder icon on the tool bar.Folder
- Switch the Format field to “All Files” and go to the DataView install folder.Select File Format
- In the Select File dialog open thedbscriptsfolder in the<DataView_HOME>\FTADataView\dbscriptsdirectory.IMPORTANT:If the files are extracted to a different folder other than the folder shown below, the folder/path instructions may be different for the machine.Example:<DataView_HOME>\FTADataView\dbscripts\DB Script Folder
- Select theDataViewMainScript.sqlfile and click [Select].Database Script - DataViewMainScript
- The script is displayed under FTADataView database. Click the [
] icon to execute the DataViewMainScript.
Run the DataViewMainScript - Refresh the database. The new triggers and tables will be added to this database. Refer the following screenshot:New Triggers and Tables
Provide Feedback