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)
- Supported* version of SQL Server or Azure SQL
- 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 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