Cloud Zerto

Migrating the ZVM 6.5 Database to Microsoft SQL Server

Zerto Virtual Replication uses an SQL Server to manage data for scalable business continuity software solutions. Zerto supports two usages of the SQL Server; either an embedded SQL Server, which is provided free of charge with the Zerto Virtual Replication product or, an external SQL Server which is deployed and managed by the customer.

Migrating a Zerto Virtual Replication Database

To migrate the database:

1. From myZerto > Support & Downloads > Software Downloads > Tools tab, select and download the zip file for Zerto Virtual Manager Database Migration Tool according to your current Zerto Virtual Manager version. The Zerto.Storage.ConversionTool.zip file is downloaded.

2. Save the Zerto.Storage.ConversionTool.zip file to the host running Zerto Virtual Manager, and to whose database you want to migrate.

3. Extract the Zerto.Storage.ConversionTool.zip files to a folder.

4.Stop the Zerto Virtual Manager service on the host to which you saved the Zerto.Storage.ConversionTool.zip file.

5. You must backup the storage_properties.xml file.

6. If you have SQL Server Compact edition, also backup the Zvm.sdf file. The default location is: C:\Program Files\Zerto\Zerto Virtual Replication

7. Rick click the file Zerto.Storage.Conversion.exe, and select Run as Administrator.3Migrating a Zerto Virtual Replication DatabaseMigrating the Zerto Virtual Replication Database to Microsoft SQL Server – Version 6.5. The Storage Conversion tool wizard opens.

8. 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.xmlb) Click Open to select the file.

9. 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.4Migrating a Zerto Virtual Replication DatabaseMigrating the Zerto Virtual Replication Database to Microsoft SQL Server – Version 6.5

■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: If you selected SQL Authentication, the OK button is disabled until you enter the appropriate Login and Password credentials.

10. You are now ready to begin the database migration.

11. In the Storage Conversion window, click CONVERT.The database migration begins.

SQL logs shows how the migration is progressing:

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

Additional Resources: Zerto Documentation