SQL Install/Config Information

SQL Install/Config Information

SQL Server Minimum Version
RULESOFT Studio Requires SQL Server 2008 (2012 or newer recommended) due to data types not present in earlier versions. See the Sub Documents for step by s...
Sat, 16 May, 2020 at 3:13 PM
RuleSoft-SQL Merge Replication Instructions
RuleSoft-SQL Merge Replication Instructions Get 1 valid CPS setup created on the same company profile (from CPS) for EACH SERVER that will partake in the s...
Sat, 13 Jun, 2020 at 10:19 AM
(1.0) SQL Server Management Studio Install
SQL Server Management Studio is the Microsoft utility that allows modification of settings and objects in an SQL Server (usually used by administrators or d...
Thu, 25 Jun, 2020 at 9:09 AM
(2.0) SQL Server Express - Install
SQL Server 2012 (or 2008) is the Database Engine that is used as the main, typically shared, repository of information for CONTROL Pro Studio. A Free versi...
Thu, 25 Jun, 2020 at 9:10 AM
(2.5) SQL Server Express - Network Configuration
For SQL Express Only (Full SQL Server Installation does not require this step) After install of the program you must alter some properties to enable ... -...
Thu, 25 Jun, 2020 at 9:13 AM
(3.0) Create RuleSoft SQL User Account
Once an SQL Server Database Engine has been Installed and Configured as desired and a user account has been created CONTROLS Pro studio can perform the rema...
Thu, 25 Jun, 2020 at 9:19 AM
(4.0alt) Use Existing SQL Server / Custom
ONLY USE THIS STEP IF A SERVER WAS ALREADY IN PLACE AND IS TO BE REUSED OR FOR SOME OTHER CUSTOM SQL MODIFICATIONS !!! If an Existing SQL Server is in Plac...
Thu, 25 Jun, 2020 at 9:23 AM
RuleSoft SQL Server - Hardware Recommendations (2020)
Processor AMD EPYC 7281 16-Core Base Clock: 2.10 GHz Operating System Windows Server 2012 R2 Memory 64GB DDR4 2666MHz Storage Operating Syst...
Wed, 1 Jul, 2020 at 11:06 AM
Rulesoft SQL: TablesCreateScript.sql
/****** Object:  Table [dbo].[Core_Nodes]    Script Date: 2020-12-29 8:45:21 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [d...
Tue, 29 Dec, 2020 at 8:07 PM
Rulesoft SQL: ViewsCreateScript.sql
/****** Object:  View [dbo].[All_Nodes]    Script Date: 2020-12-29 8:47:08 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [db...
Tue, 29 Dec, 2020 at 8:09 PM