Migrating a Zerto Virtual Replication Database

1. From the Zerto installation folder, save the Zerto.Storage.ConversionTool.exe to the host running Zerto Virtual Manager, and whose database you want to migrate.
2. Stop the Zerto Virtual Manager service on the host to which you saved the Zerto.Storage.ConversionTool.exe file.
3. You must back up the storage_properties.xml file.
4. If you have SQL Server Compact edition, also backup the Zvm.sdf file. The default location is: C:\Program Files\Zerto\Zerto Virtual Replication
5. Rick click the file Zerto.Storage.ConversionTool.exe, and select Run as Administrator.

The Storage Conversion tool wizard opens.

6. In the Select Source Properties area:
a. Click the ... (More) button and navigate to the file, storage_properties.xml.

This file contains the properties of the Zerto Virtual Replication database.

For Example: C:\Program Files\Zerto\Zerto Virtual Replication\storage_properties.xml

b. Click Open to select the file.
7. In the Select Target Properties (SQL Server) area, click the ... (More) button.

The SQL Server Properties window opens, showing the default values for the Server and Database fields.

a. Define the following fields as required:
Server: The SQL server instance name.

This is the IP address or DNS of the SQL Server and SQL Server instance name in the form of: IP>\<InstanceName>

For Example: 123.123.123.123\MSSQLSERVER

Database: The name of the Zerto Virtual Manager database.
Authentication: Select the authentication method from the drop-down list, either: Windows Authentication or SQL Server Authentication.

If the migration is to an SQL Server and you are using Windows Authentication, the Zerto Virtual Manager Service must use a user that can be authenticated by the SQL Server.

Login: If you selected SQL Authentication method, this field is mandatory.

If you selected Windows Authentication, this field is disabled.

Password: if you selected SQL Authentication method, this field is mandatory.

If you selected Windows Authentication, this field is disabled.

b. Click OK.

Note: Note: If you selected SQL Authentication, the OK button is disabled until you enter the appropriate Login and Password credentials.

8. You are now ready to begin the database migration.
To estimate how long the migration process might take, look at the database file size:
If the embedded database file is less than 100 MB, the migration process should take around 2 minutes.
If this file is less than 1 GB, the migration process should take around 10 minutes.

These time estimates assume a good network connection between SQL Server and the Zerto Virtual Manager.

The database files are stored in either one of the following:
In the folder where Zerto is installed (.SDF file)

- or -

In <Zerto Installation Root Driver>:\programdata\zerto\data (.MDF file)

For Example: C:\programdata\zerto\data

9. In the Storage Conversion window, click CONVERT.

The database migration begins.

10. After the database migration ends, start the Zerto Virtual Manager service.

Note: To rollback the database after database migration, contact Zerto Support.