Standard restore

AdapLink standard restore uses the Restore Engine to restore from data Standard backup file.

Steps to restore data from standard backup:

1. Install AdapLink Service in target system.

2. Install SmoothieMambo in target system or if it is already installed remove the existing Smoothie models by starting the Smoothie Mambo administrator and accessing File ‣ Model Manager.

3. Get the zipped backup file from where the data need to be restored and place it at AdapChain_Path\backup\ in target system, preferably C:\AdapChain\backup\.

4. Get the zip file AdapLink_Standard_Restore.zip and unzip it at AdapChain_Path\ in target system, preferably C:\AdapChain\.

5. Configure the batch file 01_restore.bat under the folder AdapChain_Path\AdapLink_Standard_Restore\1\ and replace all the occurrences of {AdapChain_Path} with its correct value in the file.

6. The configuration file 01_config.ini under the folder AdapChain_Path\AdapLink_Standard_Restore\1\ has multiple restore sections and options. Any optional section/option can be commented if not required. Following is a small description for each of these sections:

   • [BACKUP_SOURCE] This section is mandatory and gives the information about the source path. Following are the options under this section:

     • source_path The source folder where the al_backup.7z exists
     • temp_path The temporary path where the zipped backup will be unzipped for restoring. This folder will be cleared immediately after the restore process finishes.

   • [ZIP_VARIABLES] This section is mandatory and is used to define the path and other information for the 7zip executable. Following are the options under this section:

     • zip_path This option should point to the 7zip executable
     • zip_args Zip argument which is used to unzip the backup files

   • [RESTORE_MAPPING] Section is optional and all the backup source and target directory mappings are defined under it, the source is the directory/file name under the ${source_path}, without the 7z extension. For example:

     • al_backup/acconfig = C:/AdapChain/AdapLink X.Y.Z service/acconfig; This will restore the acconfig folder from backup to the target C:\AdapChain\AdapLink X.Y.Z service\acconfig\

   • [MSSQL_DB_BACKUP_PARAMETERS] The section is optional and gives the information about MS SQL server command execution, instance etc. Following are the options under this section:

     • mssql_cmd_path Path for the SQL Server command executable file
     • instance Instance of the SQl Server where the databases need to be restored
     • mssql_backup_dest The destination folder where all the databases will be restored
     • user SQL server user name
     • password SQL server password

   • [MSSQL_DB_FILE_MAPPING] This section is optional is used to configure the mappings of MS SQL database/backup file. For example:

     • adaplink = al_backup/mssql/adaplink.bak; This will restore the database adaplink from the backup file adaplink.bak

   • [PGSQL_DB_PARAMETERS] This section is optional and gives information about the Postgre database installation path, host, etc. Following are the options under this section:

     • pgsql_db_path Path for the psql.exe executable file
     • host The host name where the Postgre is installed
     • port The port number where the Postgre is running
     • user The user name
     • password The password

   • [PGSQL_DB_FILE_MAPPING] This section is optional and is used to configure the mappings of Postgre database/backup file. For example:

     • configuration = al_backup/pgsql/configuration.sql; This will restore the database configuration from the backup file configuration.sql

   • [EMAIL_CONFIG] This section is optional and can be used to configure the email server settings for sending the notification emails to the different users with an attachment of log file. Following are the options under this section:

     • server SMTP server address
     • user SMTP user
     • password SMTP user password
     • send_from The email ID from where the email will be sent
     • send_to Emails IDs to which the email will be delivered
     • subject Subject for the email

7. Create the Smoothie models by starting the Smoothie Mambo Administrator and accessing File ‣ Model Manager. Restore the models from the backup file AdapChain_Path\AdapLink_Standard_Restore\1\smoothie_backup\modelname-[TIMESTAMP].backup.

A sample configuration file can be downloaded from here.