MSSQL Linux installation and upgrade

Prerequisites 

• Install a Delphix Engine of a version compatible with connector version of choice. Refer to the support matrix for more details. 

• Install MSSQL binaries on staging, and target servers 

Downloading the Connector 

The Connector is provided as a zip file in the Delphix download site. Follow below steps to download connector: 

1. In the web browser, go to the Delphix download site. 

2. Login to the download site using email and password credentials. Customer support credentials. 

3. Go to: Delphix Product Releases -> Continuous Data Connectors -> MSSQL -> Linux -> v<version_number> -> sc_mssqlinux_<version_number>.json and download the connector (json file).  

Installing the connector 

1. Login to the Delphix Management application. 

2. Click Manage > Plugins.
   

3. To upload a plugin, click the icon.
   

4. This step displays the Upload or Upgrade a Plugin dialog. Upload the <file_name>.json. For example, sc_MSSQLLinux_<version>.json.
   

5. For more information, refer to the Continuous Data Engine connector management section.
   
   

Upgrading the connector

The procedure to upload a higher version connector is the same as installing a new MSSQL DATABASE Connector. Kindly refer to the section “Upload connector to the Continuous Data”. 

Instructions to upgrade a connector 

1. Upload the higher version connector. Refer “Upload/Install connector to the Continuous Data” section above.  

2. Refresh all (corresponding) environments. 

3. Ensure connector discovery is completed successfully. 

4. Take a new snapshot of the dSource and VDB. 

Upgrading MSSQL Version on source/staging/target host 

Dsource upgrade tends to help with dsource in-place upgrade to a higher but compatible version after upgrading your source database. 

 Prerequisites

• Take a full backup of source with the new version (after it gets upgraded). 

• Run the in-place upgrade procedure of mssql binaries on staging server. 

Upgrade Dsource steps (follow the steps in order) 

1. Refresh the staging environment after the MSSQL in-place gets upgraded. 
   

2. The new version will show up with a new repository after the refresh operation. 
   

3. Disable the dsource to be upgraded. 
   

4. Change repository reference in dsource (sourceconfig) using delphix engine CLI. To do so run below command as per the below image.
   

5. Navigate back to the Delphix engine UI and set the upgrade flag in dsource configuration. 
   

6. Enable the dsource to be upgraded.
   
   

7. Perform a snapshot using Resynchronize dsource option

   
   

8. Unset upgrade flag after the upgrade.