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 Empty Database with optional permissions SELECT,INSERT,UPDATE,EXECUTE
      • A database for the Range Table DB (Optional)
  • Software Installations
    • WhereScape RED version 8.6.6.1 or higher with valid license key entered and EULA accepted
    • WhereScape Enablement Pack for target database version 8.6.6.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
  • No labels