Cache Database Transfer
Transfer of the data triggered by a batch command
Transfer as background process
Transfer data from database to cache database and all Postgres databases
The server has to start the application with a Windows account with access to the database server and the databases with the following permissions/roles:
- DiversityCollection:
- Role CacheAdmin
- DiversityProjects:
- Role DiversityWorkbenchUser
- Additional sources, e.g. DiversityTaxonNames:
- In every database from which data should be transferred: Role DiversityWorkbenchUser or corresponding roles
To transfer the data as a background process use the following arguments:
- CacheTransfer
- Server of the SQL-server database
- Port of SQL-server
- Database with the source data
- Server for Postgres cache database
- Port for Postgres server
- Name of the Postgres cache database
- Name of Postgres user
- Password of Postgres user
For example:
C:\\DiversityWorkbench\\DiversityCollection\> DiversityCollection.exe
CacheTransfer snsb.diversityworkbench.de 5432 DiversityCollection
127.0.0.1 5555 DiversityCollectionCache postgres myPassword
The application will transfer the data according to the settings, generate a protocol as described above and quit automatically after the transfer of the data. For an introduction see a short tutorial . The user starting the process needs a Windows authentication with access to the SQL-Server database and proper rights to transfer the data. The sources and projects within DiversityCollection will be transferred according to the settings (inclusion, filter, days and time). The transfer will be documented in report files. Click on the button to access these files. For a simulation of this transfer click on the Transfer all data according to the settings button at the top of the form.