NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
== Overview ==__NOEDITSECTION__
There are several options for sharing the staging area:
Each option is detailed step-by-step.
== Sharing via backup and restore ==__NOEDITSECTION__
=== Backup of the staging area ===__NOEDITSECTION__
The first step of option 1 is to create a backup of the staging area database. This is different from taking a backup of IMSMA, because the staging area is not part of the IMSMA application, but a stand-alone PostgreSQL database. A backup can be created using any tool that can connect to the PostgreSQL database (e.g. Navicat). The guide below details the steps using pgAdmin3, a tool that comes for free with every PostgreSQL installation, thus also with an IMSMA installation.
{{Note|On a computer with IMSMA V6 installed, the executable for starting pgAdmin3 is C:\IMSMAng\pgsql\bin\pgAdmin3.exe}}
In order to create a backup of the staging area database, these steps are required:
# In pgAdmin3, connect to the PostgreSQL server hosting the staging area -- typically, this server will be localhost, and the port is 5432.
# Open the staging area database by clicking on it
# Right-click on the database (e.g. staging) and choose '''Backup...'''
# In the backup window, choose a destination folder and a filename, and the other options as shown in the screenshot below.
# Click on '''Backup''' and wait for the backup to finish. Depending on the size of the database, this can take some time. When finished, click '''Done'''.
# In the chosen destination folder, there is now a file with the chosen name and the extension .backup (e.g. staging_area_backup.backup).
# This file can now be sent to whoever should receive it.
=== Restore of the staging area ===__NOEDITSECTION__
== Hosting the staging area on a server ==__NOEDITSECTION__
== Hosting IMSMA on a server and allow remote staging area generators to connect==__NOEDITSECTION__
{{NavBox Business Intelligence}}
[[Category:VIE]]
