12/31/2022 0 Comments Red gate sql toolbelt version history![]() The tool is based upon a Red Gate SQL Source Control installation. $xmlConfigurationsFilePath, which is the configuration file for the linked databases, called LinkedDatabases.xml $hooksPath, which is the working folder/git hooks configuration file for WorkingFolder.xml and Git.xml $SqlToolbeltLicenseSerialNumber, which is the license number (you can leave it empty if you'll use the executable from your licensed installation of the comparison tools) $SQLDataComparePath, which is the path of the SQL Data Compare installation (or the dependency folder if you distribute only the dlls and executables), please read here $SQLComparePath, which is the path of the SQL Compare installation (or the dependency folder if you distribute only the dlls and executables), please read here $socPath, which is the installation path of the SoC (Red Gate Source Control), typically %LOCALAPPDATA%\Red Gate\SQL Source Control \" This is hard coded, but you can change it (please contribute) reading, for example, from a json array or an API. $databases, which is the array of the databases you'd like to link to the Source Control. ![]() $DBCreationScript, which is the script for creating the database, related to the previous variable You need to create a scope for each database you want to link $DBScope, which is the name of the database without the branch suffix (mandatory when you have server branches on TFS/VSTS or SVN). $databasesPath, which is the mdf/ndf/ldf path for the database (in development lines we don't care about using different paths) ![]() $ProductName, which is the name of your Product, that is the name of your database folder into the workspace (we use Product.DatabaseScope, for example DamnTools.TodoExplorerDB) $executeStepByStep, which is the flag for executing step by step the script, in order to check the status of the script. In order to choose the folder to start from, please read my blog post here. Global settings and paramsīelow the functions definition area, into the GLOBAL SETTINGS section, you will find a set of hard coded and customizable variables. If you design to use this tool avoiding getting the latest versions of data and structures (you will need a DLM Automation license, as described here for SQL Compare, and here for SQL Data Compare). If you don't have any of the comparison tool, you can execute this script distributing the executable files into a dependency folder. Setup Red Gate SQL Data Compare (optional) In order to execute the script, you need to: Warning: this tool works only for working folder and git setup. You can change the settings as you wish, as it's described in the Global Settings and Param section. Additionally, it gets the latest changes of the database strucutres as well as the static data. It lets you to choose what are the databases involved and it links also the static data and the filters configuration of your SQL Source Control. It does everything the right click_and_link to source control does unde the hood when you manually link a database to the Source Control via SQL Server Management studio. This tool is based on PowerShell scripts which link automatically your databases to Red Gate SQL Source Control. ![]() Red Gate SQL Source Control (4 or later) working folder/git automated link Description Sql Source Control Auto Link (Working folder and git)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |