Site SQL Files Folder - SQL-FineBuild/Common GitHub Wiki
| Previous Large Scale Deployment Overview | Sample Role Files Next |
|---|
For Large Scale Deployment Using SQL FineBuild the SQL FineBuild scripts should be stored in a site SQL Files folder. The use of such a folder will allow you to upgrade to a new SQL Server version or new SQL FineBuild version without having to change your install files.
Site SQL Files Folder Planning
Depending on the number of servers to be built, it may help administration of the build process if more than one SQL Files folder is used. The following suggestions are made regarding the number of folders:
| Number of Servers | Folders | Notes |
|---|---|---|
| Less than 20 | 1 Folder | For a small number of servers, all SQL FineBuild parameter files can exist in the same folder |
| 20 to 100 | 1 per Environment | For this number of servers, use one folder for each of the Development, Test and Production Environments |
| Over 100 | 1 per Business Unit / Environment combination | A large organisation typically consists of multiple business units, so separate SQL FineBuild Files folders for each Business Unit are appropriate |
Site SQL Files Folder Setup
The process for creating a SQL FineBuild SQL Files Folder is:
-
Create a folder under the same network share used for the SQL FineBuild install media
Give it a suitable name for your organisation (eg \AcmeSQLFiles) as shown in SQL Media Folder Names
-
Restrict the folder security
TheSite SQL Files Folder will typically contain passwords for some accounts. Access to this folder should be restricted to members of the DB Team
-
Copy the file CmdHere.bat from one of the FineBuild folders into your Site SQL Files Folder
All the other files shown in this folder are described in Sample Role Files
Copyright FineBuild Team © 2014 - 2021. License and Acknowledgements
| Previous Large Scale Deployment Overview | Top | Sample Role Files Next |
|---|