Skip to content

Latest commit

 

History

History
75 lines (65 loc) · 2.85 KB

README.md

File metadata and controls

75 lines (65 loc) · 2.85 KB

Introduction

This tool loops on a set of configured database of a SQL Server instance, scripting the DDLs for each object (if selected in the configuration file) and returning the summaries at the end (if configured as well).

The configuration file

Here is an example of the configurations.json file:

{
    "databaseServer": "localhost",
    "outputFormatForDatabases": "JSON",
    "targetFolder": "C:\\temp",
    "databases": [
        {
            "name": "",
            "scriptTables": true,
            "scriptViews": true,
            "scriptStoredProcedures": true,
            "scriptFunctions": true,
            "scriptSchemas": true,
            "scriptTypes": true,
            "scriptSynonyms": true,
            "scriptRoles": true,
            "scriptSummary": true,
            "addIdentityToSummary": true,
            "addComputedColumnToSummary": true
        },
        {
            "name": "",
            "scriptTables": true,
            "scriptViews": true,
            "scriptStoredProcedures": true,
            "scriptFunctions": true,
            "scriptSchemas": true,
            "scriptTypes": true,
            "scriptSynonyms": true,
            "scriptRoles": true,
            "scriptSummary": true,
            "addIdentityToSummary": true,
            "addComputedColumnToSummary": true
        }
    ]
}

The Program

Based on the configuration file, the tool scans the onbject in each configured database. Here is the meaning of all the configurable items:

Global config

Key Type Description
databaseServer string Fully qualified name server and instance (if required) + port (if required)
outputFormatForDatabases enum JSON for in memory objects, FILES for .sql and .md files
targetFolder string Folder used when the outputFormatForDatabases is set to FILES
targetFolder array list of database objects

Database object

Key Type Description
name string Database name (where to scan objects)
scriptTables bool true for including Tables in the export
scriptViews bool true for including Views in the export
scriptStoredProcedures bool true for including Stored Procedures in the export
scriptFunctions bool true for including Functions in the export
scriptSchemas bool true for including Schemas in the export
scriptTypes bool true for including User Defined Table Types in the export
scriptSynonyms bool true for including Synonyms in the export
scriptRoles bool true for including Roles in the export
scriptSummary bool true for creating a summary file
addIdentityToSummary bool true for including the value to the summary
addComputedColumnToSummary bool true for including the value to the summary