3.6 Exporting or Importing PlateSpin Migration Data

PlateSpin Migrate provides an Import/Export utility (ImportExportAll.bat) that you can use export information in the workload migration database and import it to the same or different Migrate server.

For an in-place upgrade of your Migrate server, you can export the data as a precautionary measure before the upgrade. For upgrade to a different platform, you can export the migration data from the old platform, then import the data to the new platform. Continue the imported migrations on the new platform.

NOTE:On import, PlateSpin Migrate automatically encrypts Credential passwords for storage in the PlateSpin Database by using that server’s encryption key. See Security of Credentials in the PlateSpin Migrate 2019.8 User Guide.

3.6.1 Exporting Workload Migration Data

You can export the workload migration data by using the Import/Export utility (ImportExportAll.bat). By default, the Import/Export utility exports data with unencrypted Credential passwords stored in base64 encoding.

NOTE:The Import/Export utility for PlateSpin Migrate provides the /pwd option to specify an encryption password to use for encrypting Credential passwords on export and decrypting them on import. If you specify the password for export, the password is required for import.

To export the workload migration data:

Prepare for exporting the database:
1. Use the Migrate Client and Migrate Web Interface to ensure that all replication schedules are paused and that no replications are running. Wait for any replications that are underway to complete, or abort the running operations.
2. Log out of Migrate Client and close the application.
3. Log out of Migrate Web Interface and close the browser.
Export the database:
1. Log in to the PlateSpin Server host as an administrative user.
  
  If the server is in a domain, you must log in as a domain user who is a member of the Domain Admin group and the local Admin group.
2. Open a Command Prompt.
  
  The process that runs the Import/Export utility (ImportExportAll.bat) must have elevated privileges. This is most easily accomplished by starting a command window using the Run as administrator context menu option.
3. Navigate to the directory that contains the Import/Export utility (ImportExportAll.bat):
  
  C:\Program Files\PlateSpin Migrate Server\PlateSpin Forge\bin\ImportExport
4. Export the data to specified directory, such as C:\temp. Enter
```
ImportExportAll.bat /export /dir "C:\temp" [/pwd "<encryption-password>"]
```
  When you export data from a Migrate server, you can specify the /pwd option to encrypt Credential passwords in the exported data. The password will be required for import.
  
  If the export fails due to running jobs, and there are no running jobs because you stopped jobs and paused schedules as required in Step 1.a, reissue the command using the /force switch to force the export. Enter
```
ImportExportAll.bat /export /dir "C:\temp" [/pwd "<encryption-password>"] /force
```
Copy the exported XML files to a location where they can be available for import after you have set up PlateSpin Server on a new platform.
Continue with either of the following paths to upgrade to a new replacement platform:
- Upgrading the Platform on Your Current PlateSpin Server Host
- Upgrading to a Replacement PlateSpin Server Host

3.6.2 Importing Workload Migration Data

You can import your previously exported workload migration data by using the Import/Export utility (ImportExportAll.bat). For example, after your upgraded PlateSpin Server host is ready, import the data to the new database instance that works with your upgraded PlateSpin Server.

NOTE:For data exported using the /pwd option in the Import/Export utility (ImportExportAll.bat) to encrypt Credential passwords in the exported data, you must provide the same encryption password to decrypt the Credential passwords on import.

To import the workload migration data:

Log in as an Administrator user to the PlateSpin Server host.

If the server is in a domain, you must log in as a domain user who is a member of the Domain Admin group and the local Admin group.
Copy the exported XML files to C:\temp on the PlateSpin Server host.
Open a Command Prompt.

The process that runs the Import/Export utility (ImportExportAll.bat) must have elevated privileges. This is most easily accomplished by starting a command window using the Run as administrator context menu option.
Navigate to the directory that contains the Import/Export utility (ImportExportAll.bat):

C:\Program Files\PlateSpin Migrate Server\PlateSpin Forge\bin\ImportExport
Import the data from the specified directory. Enter
```
ImportExportAll.bat /import /dir "C:\temp" [/pwd "<encryption-password>"]
```
If you encrypted the Credential passwords on export, you must specify the /pwd option with the same encryption password when you import the data.
After the import is complete, connect to the Migrate Web Interface and Migrate Client to confirm that the data is intact.
Resume the replications.