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