Prerequisites For SQL Server Metadata

Before you begin the following prerequisites must be met:

  • Create Database and ODBC DSN:
    • Supported* version of SQL Server or Azure SQL
      • A database to house the RED Metadata Repository. Note: This needs to be an Empty Database with optional permissions SELECT, INSERT, UPDATE, EXECUTE
      • A database for the Range Table DB (Optional)
  • Software Installations
    • WhereScape RED version 9.0.1.1 or higher with valid license key entered and EULA accepted
    • WhereScape Enablement Pack for target database version 9.0.1.1 or higher
  • Windows Powershell (64-bit) version 4 or higher
    • To check the Windows Powershell Version:
      • Run the below command in Windows Powershell:
        Get-Host|Select-Object Version
      • Run the below command in Command Prompt
        powershell $psversiontable
  • RED supports the following versions for the metadata repository: MS SQL SERVER 2012 to 2019 and Azure SQL DB