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)
- Supported* version of SQL Server or Azure SQL
- 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 Windows Powershell:
- To check the Windows Powershell Version:
- Run the below command in Command Prompt
powershell $psversiontable
- Run the below command in Command Prompt
- RED supports the following versions for the metadata repository: MS SQL SERVER 2012 to 2019 and Azure SQL DB