NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
{{Under construction | This page is under construction}}
The IMSMA Staging Area Generator is a tool that allows to create a staging area from an IMSMA database. It is thus part of the {{IMSMANG}} tool set, but not directly integrated into the {{IMSMANG}} installation package. It thus needs to be installed separately. Please contact your country focal point in order to get the latest installation package.
{{Note | The Staging Area Generator can only be used with {{IMSMANG}} 6.0 and above}}
== Installing the IMSMA Staging Area Generator==__NOEDITSECTION__
<ol>
* '''Port:''' port of your target Postgres database server installation - the default is 5432 (which is also the port on which IMSMA is running on the source)
* '''Database:''' this is the name of the staging area database to be created. You can specify any name here, using '''lower-case alphanumeric characters and underscores'''. If a database with the provided name '''does not yet exist''', the SAG tool will create a database with that name on the target database server. If a database with the provided name '''already exists''', the content will be '''dropped''' and '''recreated''' by the SAG tool. If, for any reason, the database cannot be created, an error message will be displayed. Contact your country focal point if you are unsure how to solve that.
* '''User:''' this is the username of the database user that should be the '''owner''' of the staging area database. The default is imsma - however, this will only work if the staging area is created on the same database server on which IMSMA is running. On another, independent, database, there might not be any user named imsma. In that case, another, existing, user can be provided, or the database superuser named ''postgres'' can be used.* '''Password:'''password of the above user.* '''Postgres User:'''the above defined user that was specified as the owner of the staging area database might not have the permissions to actually ''create'' the new staging area database. Therefore, a user with enough permissions has to be provided here. The default is '''postgres''', which is the superuser having all necessary permissions.* '''Postgres Password:'''password of the above user - in case of doubt, leave the default (''password'').
|-
| align="left" | '''3 - Post Processing SQL Scripts'''
