Versions Compared

Version Old Version 3 New Version 4
Changes made by

Daniel (Deactivated)

Anurag Sarkar

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Guidelines

  1. After Upgrade is done before starting the server and all connections to database should be terminated
  2. In Cluster environment all other nodes should be down

Upgrader from command

 

MySQL Upgrader command for windows

<upgrader file name> -VzMySQLPath='C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe' -VzMySQLCnfFilePath='C:\Program Files\MySQL\MySQL Server 5.6\my-default.ini'

MySQL upgrader command for Linux

<upgrader file name> -VzMySQLPath='/usr/bin/mysql' -VzMySQLCnfFilePath='/etc/mysql/my.cnf'

Embedded Upgrader command

<upgrader file name> -VzMySQLPath='C:\Program Files\Zephyr\mysql\bin\mysql.exe' -VzMySQLCnfFilePath='C:\Program Files\Zephyr\mysql\my.ini'

For MSSQL Upgrader

For windows double click & For linux sh <upgrader file name>.sh (No need to pass any arguments like MySQL)

For Oracle Upgrader

For windows double click & For linux sh <upgrader file name>.sh (No need to pass any arguments like MySQL)

...


4.7/4.8.1.2 to 5.0(MSSQL)  direct upgrade is not possible.Since we don't have upgrader for that.
Following steps to be followed for MSSQL DB Migration.

Scenario 1: From 4.7 (MySQL) to 5.1 SQL Server

...