602SQL Documentation Index  

Application (SCHEMA) Export and Distribution

Completed database application is distributed like follows: it is exported at authorīs computer into files and a user imports it to his/her database.

If it is necessary to restrict user access to internal application layers, the application is exported as a locked application.

Export of application as a whole, i.e. transfer of all components of an open application from the 602SQL Control Panel environment to disk is executed by means of Application Export action and of the popup menu for given application. A dialog box opens that offers various export alternatives.

If you want to export only some application components, you must - prior to export - mark the objects that should not be exported. As far as the tables are concerned, you can mark the tables one by one where data should not be exported. If data from tables are also exported, their export is done in the internal 602SQL format.

After selection of the export alternative, you must specify the path and name for the definition file of the exported application (so-called APL file). The application components are exported to the same directory, where the application definition file is created (APL file). Each component will be in a separate file. File names are created as object names (without diacritical marks, to make possible transfer also to other OS) and a defined prefix. If within the same directory a file with identical name already exists, the name of the next file will include a number starting from zero up. File date corresponds to the date of the last object modification. Coding of files containing object definitions is UTF-8.

The description of application export (and of the following import), as far as the permissions to the standard roles are concerned, is found at page Roles and Permissions within the Application.

Export of object definitions is very quick; export of data from large tables can take some time. Object definitions are exported in editable text file format, exported data file is in binary format and it is impossible to edit it.

List of topics: