PRO: Precedence Rules #

All features described in this page are part of the Professional Edition.

While in beta, you can enable the Professional Edition by creating an empty key.xt file next to the sqldsc.exe file.

The PRO edition will become a paid version. Until then, PRO features expire 90 days after the build date. Please see https://www.scalesql.com for updated builds or run sqldsc update.

Precedence Rules #

Adding domains and roles makes the precedence more complex.

Each of these files can define the same configuration. For example, to configure node2 in this example, the following files would be used. Each lower file overrides the values in the higher file.

1. defaults.hcl
2. roles\prod.hcl
3. roles\data-center-2.hcl
4. roles\ag-one.hcl
5. nodes\node2.hcl

The full rules are

1. Global Defaults: defaults.hcl
2. Domain Defaults: DOMAIN.defaults.hcl
3. Roles - The role files in the roles directory in the order specified
4. Per Computer Defaults (in order):
   • nodes\computer.hcl
   • nodes\computer__instance.hcl (note the double underscores)
   • nodes\DOMAIN\computer.hcl
   • nodes\DOMAIN\computer__instance.hcl

And remember that the LAST file procesed overrides the previous files.