...
- Maintenance > Dataset Maintenance
- Press the Export button. Only the current dataset can be exported. The Export button is available only if the current dataset is MSSQL.
- Select the tables to export
- Choose to clear any columns upon export (such as Social Security Number). The syntax is Table:Column. Separate each table/:column combination by commas. (i.e. N01_NAM_ADR_INF:N01_PHN_NUM_S,N01_NAM_ADR_INF:N01_SSN_FED_ID_S)
- Press Save to save this configuration as the default export setup for this dataset
- Press Export to export the selected tables
- The export process puts several files in the dataset folder
- BulkIOService.Export.zip - the dataset data
- BulkIOService.Schema.zip - the database schema
- BulkIOService.Export.Version.txt - the AGRIS version that is exported
- The export process is complete. Copy the dataset folder to the intended destination (archive, send to Cultura, move to another db server, etc)
- The entire dataset folder is needed after export. There is non-database information in the dataset folder (package initialization files, CFT setup, spooled reports and forms, and more)
...