Note:
- This feature will be released soon.
Manage Prolaborate Database Migration
Prolaborate made it easier to manage data and execute actions like backup, restore and migrate with just a few steps by using Prolaborate Management application. This feature is available in the Prolaborate version 4.4.1
In this guide, we will look at the step-by-step process on how to backup and restore data.
Backup Database Currently in Use
To take a backup of the Prolaborate database, which is currently configured in Prolaborate App Server, follow the steps below,
- Run the Prolaborate Management.exe as administrator
- Click Data Migration Section and choose the Backup tab
- Select the backup file location using the ellipses button and save the file
- Choose the Database Connection type as Current
- Check the Use Encrypt Data box to store the backup data in an encrypted format (Optional)
- Click Backup button to initiate the backup process
A success message appears once the backup is complete.
Backup Other Database
To take a backup of a Prolaborate database, which is currently not connected/removed from configuration in Prolaborate App Server, follow the steps below,
- Run the Prolaborate Management.exe as administrator
- Click Data Migration Section and choose the Backup tab
- Select the backup file location using the ellipses button and save the file
- Choose the Database Connection type as Other and fill the required fields as described below
- Check the Use Encrypt Data box to store the backup data in an encrypted format (Optional)
- Click Test Connection to connect to the database.
- Once the connection is successful, click Backup button to initiate the backup process.
| Field | Description |
| Type | Choose the database server type – MySQL or MSSQL |
| Host Name | Enter database server name |
| Database Name | Enter name of the Prolaborate database |
| User Id | Enter login name which has been used in server login |
| Password | Enter password for the entered User Id |
A success message appears once the backup is complete.
Restore Data to Database Currently in Use
To restore data from a backfile to a Prolaborate database, which is currently configured in the Prolaborate App Server, follow the steps below,
Things to note before restoring:
- Prolaborate version of the current database should match the version in the selected restoration file.
- Run the Prolaborate Management.exe as administrator
- Click Data Migration tab and choose the Restore tab
- Select the required file to restore using the ellipses button
- Choose the Database Connection type as Current
- Click Restore button to initiate the restore process
A success message appears once the restore is complete.
Restore Data to Other Databases
To restore data from a backfile to a Prolaborate database, which is currently not connected/removed from configuration in Prolaborate App Server, follow the steps below,
Things to note before restoring:
- Prolaborate version of the current database should match the version in the selected restoration file.
- Run the Prolaborate Management.exe as administrator
- Click Data Migration tab and choose the Restore tab
- Select the required file to restore using the ellipses button
- Choose the Database Connection type as Other and fill the required fields as described below
- Click Test Connection to connect to the database.
- Once the connection is successful, click Restore button to initiate the restore process.
| Field | Description |
| Type | Choose the database server type – MySQL or MSSQL |
| Host Name | Enter database server name |
| Database Name | Enter name of the Prolaborate database |
| User Id | Enter login name which has been used in server login |
| Password | Enter password for the entered User Id |
A success message appears once the restore is complete.
Migrate Prolaborate Data
Prolaborate Management offers hassle-free migration functionality to transfer Prolaborate data from MSSQL database server to MySQL database server and vice versa.?
There are two different approaches in connecting database servers for migration process.
- Current database as a source and a different (other) database as a target
- Current database as a target and a different (other) database as a source
Migrate Data from Current Database to Other Database (Export)
To migrate data from Prolaborate database, which currently configured in Prolaborate App Server to a different database, follow the steps below,
Things to note before migration:
- Prolaborate version should be the same in both databases.
- Run the Prolaborate Management.exe as administrator
- Click Data Migration tab and choose the Migrate tab
- Select Current Connection as Source Configuration. Upon choosing, Other Connection is automatically selected as Target Configuration
- Choose the Database Connection type as Other and fill the required fields as described below
- Fill the required fields as described below
- Click Test Connection to connect to the database.
- Once the connection is successful, click Migrate button to initiate the migration process.
| Field | Description |
| Type | Choose the database server type – MySQL or MSSQL |
| Host Name | Enter database server name |
| Database Name | Enter name of the Prolaborate database |
| User Id | Enter login name which has been used in server login |
| Password | Enter password for the entered User Id |
A success message appears once the migration is complete.
Migrate Data to Current Database from Other Database (Import)
To migrate data to a Prolaborate database, which currently configured in Prolaborate App Server from a different database, follow the steps below,
Things to note before migration:
- Prolaborate version should be the same in both databases.
- Run the Prolaborate Management.exe as administrator
- Click Data Migration tab and choose the Migrate tab
- Select Current Connection as Target Configuration. Upon choosing, Other Connection is automatically selected as Source Configuration
- Fill the required fields as described below
- Click Test Connection to connect to the database.
- Once the connection is successful, click Migrate button to initiate the migration process.
| Field | Description |
| Type | Choose the database server type – MySQL or MSSQL |
| Host Name | Enter database server name |
| Database Name | Enter name of the Prolaborate database |
| User Id | Enter login name which has been used in server login |
| Password | Enter password for the entered User Id |
A success message appears once the migration is complete.