Continuous Integration for Databases with Visual Studio

Adam Nachman

Rate me:

4.85/5 (14 votes)

23 Nov 2010Apache18 min read

63K

1.2K

Provides a framework for predictably compiling, extracting, and deploying a database project.

continuousintegrationvsdb_vs2008_src.zip
- Continuous Integration
  - bin
    - AdamNachman.Build.SqlExtract.dll
    - AdamNachman.Build.SqlExtract.pdb
    - Microsoft.SqlServer.BatchParser.dll
    - Microsoft.SqlServer.Replication.dll
    - SqlDeployment.Build.dll
    - SqlDeployment.Build.pdb
    - SqlDeployment.Interfaces.dll
    - SqlDeployment.Interfaces.pdb
    - SqlDeployment.ScriptExecutor.dll
    - SqlDeployment.ScriptExecutor.pdb
    - SqlDeployment.Utilities.dll
    - SqlDeployment.Utilities.pdb
  - Build
    - Abstract Classes
      - BaseBuildLog.cs
    - Build.csproj
    - Logging
    - Properties
      - AssemblyInfo.cs
    - SampleTargets
      - SampleDB.targets
    - Tasks
    - Utilities.cs
  - ContinuousIntegration.sln
  - DatabaseDeployment
  - Interfaces
    - ILogger.cs
    - Interfaces.csproj
    - Properties
      - AssemblyInfo.cs
  - ScriptExecutor
  - SqlExtract
    - Abstract Classes
    - Database Object Classes
    - Interfaces
      - IDBObject.cs
      - IExistenceChecker.cs
    - Logging
      - MSBuildLog.cs
      - TraceLog.cs
    - Processes
    - Properties
      - AssemblyInfo.cs
    - Resources
    - SQLExtract.cs
    - SQLExtract.csproj
    - SystemConstants.cs
    - Utility Classes
      - ExistenceCheckers
        
        ExistenceCheckerDefault.cs
        
        ManifestExistenceChecker.cs
        
        SchemaExistenceChecker.cs
      - PermissionMap.cs
      - PermissionPattern.cs
      - Utilities.cs
  - Utilities
    - Properties
      - AssemblyInfo.cs
    - SerializableDictionary.cs
    - Utilities.csproj
- Example VSDB Project
  - Build
  - Data Generation Plans
  - ExtractCommands.txt
  - Import Schema Logs
  - lib
    - AdamNachman.Build.SqlExtract.dll
    - Microsoft.SqlServer.BatchParser.dll
    - Microsoft.SqlServer.Replication.dll
    - SqlDeployment.Build.dll
    - SqlDeployment.Interfaces.dll
    - SqlDeployment.ScriptExecutor.dll
    - SqlDeployment.Utilities.dll
  - PermissionsTemplate.xml
  - Properties
    - Database.sqlcmdvars
    - Database.sqldeployment
    - Database.sqlpermissions
    - Database.sqlsettings
  - RestoreBuildScript
    - Restore.sql
    - RestoreConfiguration.xml
  - SampleDB.dbproj
  - SampleDB.targets
  - Schema Comparisons
  - Schema Objects
    - Database Level Objects
      - Assemblies
      - Database Triggers
      - Security
        
        Asymmetric Keys
        
        Certificates
        
        Master Keys
        
        Roles
        
        Application Roles
        
        Database Roles
        
        MyDatabaseRole.role.sql
        
        Schemas
        
        MySchema.schema.sql
        
        Signatures
        
        Symmetric Keys
        
        Users
      - Service Broker
        
        Contracts
        
        Event Notifications
        
        Message Types
        
        Queues
        
        Remote Service Binding
        
        Routes
        
        AutoCreatedLocal.route.sql
        
        Services
      - Storage
        
        Filegroups
        
        Files
        
        SampleDBSource.sqlfile.sql
        
        SampleDBSource_log.sqlfile.sql
        
        Full Text Catalogs
        
        Partition Functions
        
        Partition Schemes
    - Schemas
      - dbo
        
        Programmability
        
        Defaults
        
        Functions
        
        fncOne.function.sql
        
        fncTwo.function.sql
        
        Rules
        
        Stored Procedures
        
        sprOne.proc.sql
        
        sprTwo.proc.sql
        
        Types
        
        User Defined Data Types
        
        User Defined Types CLR
        
        XML Schema Collections
        
        Synonyms
        
        Tables
        
        Constraints
        
        DF_TableOne_Col2.defconst.sql
        
        DF_TableThree_Col2.defconst.sql
        
        Indexes
        
        IX_TableThree_Col3_Col4.index.sql
        
        Keys
        
        FK_TableTwo_TableOne.fkey.sql
        
        PK_TableOne.pkey.sql
        
        PK_TableThree.pkey.sql
        
        PK_TableTwo.pkey.sql
        
        Statistics
        
        TableOne.table.sql
        
        TableThree.table.sql
        
        TableTwo.table.sql
        
        Triggers
        
        Views
        
        Indexes
        
        Statistics
        
        Triggers
        
        ViewOne.view.sql
        
        ViewTwo.view.sql
      - MySchema
        
        Programmability
        
        Defaults
        
        Functions
        
        Rules
        
        Stored Procedures
        
        sprOne.proc.sql
        
        Types
        
        User Defined Data Types
        
        User Defined Types CLR
        
        XML Schema Collections
        
        Synonyms
        
        Tables
        
        Constraints
        
        Indexes
        
        Keys
        
        Statistics
        
        Triggers
        
        Views
        
        Indexes
        
        Statistics
        
        Triggers
  - Scripts
    - CustomDeployment
    - Post-Deployment
      - Script.PostDeployment.sql
    - Pre-Deployment
      - Script.PreDeployment.sql
continuousintegrationvsdb_src.zip
- ContinuousIntegrationVSDB_SRC
  - Continuous Integration
    - bin
    - Build
      - Abstract Classes
        
        BaseBuildLog.cs
      - Build.csproj
      - Logging
        
        BaseLog.cs
        
        BuildLog.cs
        
        MSBuildLog.cs
        
        TraceLog.cs
      - Properties
        
        AssemblyInfo.cs
      - SampleTargets
        
        SampleDB.targets
      - Tasks
        
        DeployDatabase.cs
        
        SqlExtract.cs
        
        SqlScriptExecutor.cs
      - Utilities.cs
    - ContinuousIntegration.sln
    - DatabaseDeployment
    - Interfaces
      - ILogger.cs
      - Interfaces.csproj
      - Properties
        
        AssemblyInfo.cs
    - libs
      - nunit
        
        nunit.framework.dll
        
        nunit.framework.xml
        
        nunit.mocks.dll
        
        pnunit.framework.dll
    - ScriptExecutor
    - SqlExtract
      - Abstract Classes
        
        BaseBuildLog.cs
        
        BaseConstraint.cs
        
        BaseDBObject.cs
        
        BaseTable.cs
        
        GenericProcessDatabase.cs
        
        ProcessDatabase.cs
      - Database Object Classes
        
        BrokerQueue.cs
        
        CheckConstraint.cs
        
        CLRAssembly.cs
        
        ClusteredConstraint.cs
        
        Contract.cs
        
        DatabaseSchema.cs
        
        DefaultConstraint.cs
        
        Filegroup.cs
        
        ForeignKey.cs
        
        FullTextCatalog.cs
        
        FullTextIndex.cs
        
        Function.cs
        
        Index.cs
        
        Message.cs
        
        PartitionFunction.cs
        
        PartitionScheme.cs
        
        PrimaryKey.cs
        
        Role.cs
        
        Route.cs
        
        Service.cs
        
        StoredProcedure.cs
        
        Table.cs
        
        Trigger.cs
        
        UniqueConstraint.cs
        
        View.cs
      - Enums
        
        SqlFileTypes.cs
      - Interfaces
        
        IDBObject.cs
        
        IExistenceChecker.cs
      - Logging
        
        MSBuildLog.cs
        
        TraceLog.cs
      - Parsers
        
        Matcher.cs
        
        ScriptMatcher.cs
      - Processes
        
        ProcessCircular.cs
        
        ProcessClrAssemblies.cs
        
        ProcessClusteredConstraints.cs
        
        ProcessConstraints.cs
        
        ProcessContracts.cs
        
        ProcessFilegroups.cs
        
        ProcessFullTextCatalogs.cs
        
        ProcessFullTextIndexes.cs
        
        ProcessFunctions.cs
        
        ProcessMessages.cs
        
        ProcessPartitionFunctions.cs
        
        ProcessPartitionScheme.cs
        
        ProcessProcedures.cs
        
        ProcessQueues.cs
        
        ProcessRoles.cs
        
        ProcessRoutes.cs
        
        ProcessSchema.cs
        
        ProcessServices.cs
        
        ProcessTables.cs
        
        ProcessTriggers.cs
        
        ProcessViews.cs
      - Properties
        
        AssemblyInfo.cs
      - Resources
        
        CleanupMergeProc.sql
        
        CleanupPermissionsProc.sql
        
        CreateMergeProc.sql
        
        CreatePermissionsProc.sql
      - SQLExtract.cs
      - SQLExtract.csproj
      - SystemConstants.cs
      - Utility Classes
        
        AssembliesToExtract.cs
        
        AssemblyToExtract.cs
        
        ExistenceCheckers
        
        ExistenceCheckerDefault.cs
        
        ManifestExistenceChecker.cs
        
        SchemaExistenceChecker.cs
        
        ParseResult.cs
        
        PermissionMap.cs
        
        PermissionPattern.cs
        
        Utilities.cs
    - UnitTests
    - Utilities
      - Properties
        
        AssemblyInfo.cs
      - SerializableDictionary.cs
      - Utilities.csproj
  - Example VSDB Project
    - Build
      - SampleDB.sql
    - Data Generation Plans
    - ExtractAssemblies.xml
    - ExtractCommands.txt
    - lib
      - AdamNachman.Build.SqlExtract.dll
      - AdamNachman.Build.SqlExtract.pdb
      - SqlDeployment.Build.dll
      - SqlDeployment.Build.pdb
      - SqlDeployment.Interfaces.dll
      - SqlDeployment.Interfaces.pdb
      - SqlDeployment.ScriptExecutor.dll
      - SqlDeployment.ScriptExecutor.pdb
      - SqlDeployment.Utilities.dll
      - SqlDeployment.Utilities.pdb
    - PermissionsTemplate.xml
    - Properties
      - Database.sqlcmdvars
      - Database.sqldeployment
      - Database.sqlpermissions
      - Database.sqlsettings
    - RestoreBuildScript
      - Restore.sql
      - RestoreConfiguration.xml
    - SampleDB.dbproj
    - SampleDB.sln
    - SampleDB.targets
    - Schema Comparisons
    - Schema Objects
      - Database Level Objects
        
        Assemblies
        
        AdamNachman.SqlClr.assembly.sql
        
        Database Triggers
        
        Security
        
        Asymmetric Keys
        
        Certificates
        
        Master Keys
        
        Roles
        
        Application Roles
        
        Database Roles
        
        MyDatabaseRole.role.sql
        
        MyOtherDatabaseRole.role.sql
        
        Schemas
        
        MySchema.schema.sql
        
        Signatures
        
        Symmetric Keys
        
        Users
        
        Service Broker
        
        Contracts
        
        Contract1.contract.sql
        
        Event Notifications
        
        Message Types
        
        MessageType1.messagetype.sql
        
        MessageType2..messagetype.sql
        
        Queues
        
        Queue1.queue.sql
        
        Remote Service Binding
        
        Routes
        
        AutoCreatedLocal.route.sql
        
        Services
        
        Service1.service.sql
        
        Storage
        
        Filegroups
        
        MyFilegroup.filegroup.sql
        
        Files
        
        SampleDBSource.sqlfile.sql
        
        SampleDBSource_log.sqlfile.sql
        
        Full Text Catalogs
        
        FullTextCatalogOne.fulltext.sql
        
        Partition Functions
        
        MyPartitionFunction.partitionfunction.sql
        
        Partition Schemes
        
        MyPartitionScheme.partitionscheme.sql
      - Schemas
        
        dbo
        
        Programmability
        
        Defaults
        
        Functions
        
        fncOne.function.sql
        
        fncTwo.function.sql
        
        GetIds.function.sql
        
        Rules
        
        Stored Procedures
        
        sprOne.proc.sql
        
        sprThree.proc.sql
        
        sprTwo.proc.sql
        
        Types
        
        User Defined Data Types
        
        User Defined Types CLR
        
        XML Schema Collections
        
        Synonyms
        
        Tables
        
        Constraints
        
        DF_TableOne_Col2.defconst.sql
        
        DF_TableThree_Col2.defconst.sql
        
        Indexes
        
        IX_TableThree_Col3_Col4_a.index.sql
        
        IX_TableThree_Col3_Col4_b.index.sql
        
        Keys
        
        FK_TableTwo_TableOne.fkey.sql
        
        PK_TableOne.pkey.sql
        
        PK_TableThree.pkey.sql
        
        PK_TableTwo.pkey.sql
        
        Statistics
        
        TableOne.table.sql
        
        TableThree.table.sql
        
        TableTwo.table.sql
        
        Triggers
        
        Views
        
        Indexes
        
        Statistics
        
        Triggers
        
        ViewOne.view.sql
        
        ViewTwo.view.sql
        
        MySchema
        
        Programmability
        
        Defaults
        
        Functions
        
        fncThree.function.sql
        
        Rules
        
        Stored Procedures
        
        sprOne.proc.sql
        
        Types
        
        User Defined Data Types
        
        User Defined Types CLR
        
        XML Schema Collections
        
        Synonyms
        
        Tables
        
        Constraints
        
        DF_TableSix_Col2.defconst.sql
        
        UQ_TableFour_a.ukey.sql
        
        Indexes
        
        FullTextIndexOne.fulltextindex.sql
        
        IX_TableFour_Col2_a.index.sql
        
        IX_TableFour_Col2_b.index.sql
        
        IX_TableFour_Col2_c.index.sql
        
        MyIndexName.index.sql
        
        Keys
        
        PK_TableFive.pkey.sql
        
        PK_TableFour.pkey.sql
        
        PK_TableSix.pkey.sql
        
        Statistics
        
        TableFive.table.sql
        
        TableFour.table.sql
        
        TableSix.table.sql
        
        Triggers
        
        SomeTableOrView.TriggerStandard.trigger.sql
        
        TriggerTable.table.sql
        
        Views
        
        Indexes
        
        Statistics
        
        Triggers
    - Scripts
      - CustomDeployment
        
        AlterTables.sql
        
        DropConstraints.sql
        
        DropRedundantObjects.sql
        
        LoadReferenceData.sql
        
        ManipulateDataPostApply.sql
        
        RolePermissions.sql
        
        ScriptExecutorConfiguration.xml
    - SqClr
      - bin
        
        Release
        
        AdamNachman.SqClr.dll
      - GetIds.cs
      - Properties
        
        AssemblyInfo.cs
      - SqlClr.csproj
database_project_for_ci.zip
- __TemplateIcon.ico
- Database Project for CI.dbproj
- Database Project for CI.targets
- ExtractCommands.txt
- MyTemplate.vstemplate
- Output
  - Database Project for CI.sql
- PermissionsTemplate.xml
- Properties
  - Database.sqlcmdvars
  - Database.sqldeployment
  - Database.sqlpermissions
  - Database.sqlsettings
- RestoreBuildScript
  - Restore.sql
  - RestoreConfiguration.xml
- Schema Objects
  - Database Level Objects
    - Security
      - Roles
        
        Database Roles
        
        db_executor.role.sql
    - Service Broker
      - Routes
        
        AutoCreatedLocal.route.sql
    - Storage
      - Filegroups
        
        Database Project for CI_Data.filegroup.sql
        
        Database Project for CI_Index.filegroup.sql
  - Schemas
    - dbo
      - Programmability
        
        Functions
- Scripts
  - CustomDeployment

CREATE ASSEMBLY [AdamNachman.SqClr]
    FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C0103001519824C0000000000000000E00002210B0108000012000000060000000000006E310000002000000040000000004000002000000002000004000000000000000400000000000000008000000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000183100005300000000400000B803000000000000000000000000000000000000006000000C000000A83000001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E7465787400000074110000002000000012000000020000000000000000000000000000200000602E72737263000000B8030000004000000004000000140000000000000000000000000000400000402E72656C6F6300000C00000000600000000200000018000000000000000000000000000040000042000000000000000000000000000000005031000000000000480000000200050010230000980D00000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000133002005600000001000011281A00000A6F1B00000A027B03000004330F027B020000041FFEFE0116FE012B01170C082D0B02167D02000004020A2B0716730B0000060A06027B050000047D0400000406027B070000047D06000004060B2B00072A0000133001000B000000020000110228040000060A2B00062A001B3003004101000003000011027B020000040B0745030000000700000009000000020000002B0738DF0000002B05380B01000002157D0200000400027C04000004FE16030000016F1C00000A6F1D00000A281E00000A2D21027B060000046F1F00000A2D14027B060000046F2000000A176AFE0416FE012B01160C082D060038BA00000002027C04000004282100000A027B060000046F2200000A6F2300000A7D080000040002177D0200000402027B080000047D0C00000402167D0D0000042B6002027B0C000004027B0D0000049A7D0B00000400027B0B000004027C09000004282400000A16FE010C082D250002027B090000048C1F0000017D0100000402187D02000004170ADE3F02177D02000004000002027B0D00000417587D0D000004027B0D000004027B0C0000048E69FE040C082D8C02280C0000060000160ADE0802280900000600DC00062A000000411C0000040000000000000036010000360100000800000000000000133001000B00000004000011027B010000040A2B00062A1A732500000A7A0000133002002700000005000011027B020000040A061759450200000004000000020000002B042B042B022B0702280C000006002A00133001000B00000004000011027B010000040A2B00062A7A02282600000A02037D0200000402281A00000A6F1B00000A7D030000042A2202157D020000042A00133002001C000000060000111FFE730B0000060A06027D0500000406037D07000004060B2B00072A4E000302A51F000001282700000A81050000012A1E02282600000A2A42534A4201000100000000000C00000076322E302E35303732370000000005006C00000090040000237E0000FC040000A406000023537472696E677300000000A00B00000800000023555300A80B0000100000002347554944000000B80B0000E001000023426C6F6200000000000000020000015717A20B0902000000FA2533001600000100000021000000030000000D0000000C0000000500000005000000280000001600000006000000010000000200000002000000070000000200000001000000020000000100000000000A0001000000000006004D0046000600670054000A0094007F000A009E007F000A00AE007F000A00E600CB0006002401050106004301310106005A0131010600770131010600960131010600AF0131010600C80131010600E30131010600FE01310106001702050106002B02310106004402460006006D025A024F00810200000600B00290020600D00290020A000003CB0006003D03220306004B0322030600590354000600650346000600B9055A020600E205D10506001806460006005806460006006706460006008906900200000000010000000000010001000100100020002A0005000100010003011000150300000500010004000100F903CF000100A204DB000100AD04DB000600C600DE000600ED04DE000600F800E2000600F704E20006000205E60006000F05DB0006001805DB0006002405EA0006003E05E60006004905DB00CC22000000009600A7000A000100F422000000009600B700130003000823000000008618C0001B000500502000000000E1017103B5000500B42000000000E101C303C6000500CC2000000000E101F003CB000500382200000000E1090604D20005004F2200000000E10154041B000500582200000000E1017F041B0005008C2200000000E109C204D2000500A322000000008618C00055000500C22200000000810030051B00060000000100C60000000200F80000000100FE0002000200020100000100A204030006000300090003000A000300690003006D003100C0001B003900C0001B004100C00045004900C00045005100C00045005900C00045006100C00045006900C00045007100C00045007900C00045008100C0004A008900C00045009100C0004A009900C0004F00A900C0005500B100C0001B00B900C0001B000C00B503BD001100B503C600D100F003CB0014004804D600D10079041B00D9009A041B00D1004804D200E100C0001B00E900E905F600E900FB05FB0009000F060F01F1001F060F01F1002406130121003206CB0021003D061801190048060F01210048061C01F10052062101F9005E0628010101C0001B000900C0001B0029007D0644010901C0001B0020008B005A0024000B001F002E001B004A012E002B0061012E008300C0012E00430084012E007300AE012E00230061012E00330067012E003B0079012E007B00B7012E004B0061012E005B0061012E006B00A80144000B00320063004301F1008000CB00F100A000CB00F100E000CB00F1000001CB00F1004001CB00F1006001CB00F100FF000A012F01350139013D010300010000005405ED0000009205ED0002000700030002000A00050003000800250003000A00270003000C00290003000E002B00030010002D00030012002F00030014003100A900AF0004800000010005003B0F9A54000000000000EE02000002000000000000000000000001003D00000000000200000000000000000000000100730000000000030002000000003C4D6F64756C653E004164616D4E6163686D616E2E5371436C722E646C6C0053656C656374696F6E004164616D4E6163686D616E2E53716C436C72006D73636F726C69620053797374656D004F626A6563740053797374656D2E436F6C6C656374696F6E730049456E756D657261626C650053797374656D2E446174610053797374656D2E446174612E53716C54797065730053716C537472696E670053716C4368617273004765744964730053716C496E7433320046696C6C526F7773002E63746F72006C697374004D6963726F736F66742E53716C5365727665722E5365727665720053716C46616365744174747269627574650064656C696D006F626A0049640053797374656D2E52756E74696D652E496E7465726F705365727669636573004F75744174747269627574650053797374656D2E5265666C656374696F6E00417373656D626C795469746C6541747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C7475726541747472696275746500436F6D56697369626C6541747472696275746500417373656D626C7956657273696F6E41747472696275746500434C53436F6D706C69616E744174747269627574650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C697479417474726962757465004164616D4E6163686D616E2E5371436C720053716C46756E6374696F6E417474726962757465003C4765744964733E645F5F300053797374656D2E436F6C6C656374696F6E732E47656E657269630049456E756D657261626C6560310049456E756D657261746F7260310049456E756D657261746F720049446973706F7361626C650053797374656D2E436F6C6C656374696F6E732E47656E657269632E49456E756D657261626C653C53797374656D2E4F626A6563743E2E476574456E756D657261746F7200476574456E756D657261746F720053797374656D2E436F6C6C656374696F6E732E49456E756D657261626C652E476574456E756D657261746F72004D6F76654E657874003C3E325F5F63757272656E740053797374656D2E436F6C6C656374696F6E732E47656E657269632E49456E756D657261746F723C53797374656D2E4F626A6563743E2E6765745F43757272656E74006765745F43757272656E740053797374656D2E436F6C6C656374696F6E732E49456E756D657261746F722E52657365740052657365740053797374656D2E49446973706F7361626C652E446973706F736500446973706F7365003C3E315F5F7374617465003C3E6C5F5F696E697469616C54687265616449640053797374656D2E436F6C6C656374696F6E732E49456E756D657261746F722E6765745F43757272656E74003C3E335F5F6C697374003C3E335F5F64656C696D003C76616C7565733E355F5F31003C69643E355F5F32003C636F756E743E355F5F33003C76616C75653E355F5F34003C3E6D5F5F46696E616C6C7935003C3E375F5F7772617036003C3E375F5F77726170370053797374656D2E436F6C6C656374696F6E732E47656E657269632E49456E756D657261746F723C53797374656D2E4F626A6563743E2E43757272656E740053797374656D2E436F6C6C656374696F6E732E49456E756D657261746F722E43757272656E7400446562756767657248696464656E4174747269627574650053797374656D2E546872656164696E6700546872656164006765745F43757272656E74546872656164006765745F4D616E61676564546872656164496400546F537472696E6700537472696E67005472696D0049734E756C6C4F72456D707479006765745F49734E756C6C006765745F4C656E677468006765745F56616C75650053706C697400496E743332005472795061727365004E6F74537570706F72746564457863657074696F6E006F705F496D706C6963697400436F6D70696C657247656E6572617465644174747269627574650000032000000000004193BC7C159163479F4DDF22B28568560008B77A5C561934E0890800021209110D1211070002011C1011150320000112010001005408074D617853697A65FFFFFFFF12010001005408074D617853697A6501000000042001010E042001010205200101115104200101084E0100030054020F497344657465726D696E697374696301540E1146696C6C526F774D6574686F644E616D650846696C6C526F7773540E0F5461626C65446566696E6974696F6E07496420696E742005151261011C05151265011C072000151265011C08200015126501130004200012690320000202061C0320001C04200013000206080306110D0306121103061D0E02060E0328001C04010000000400001275032000080A0703120C151265011C0204070112690320000E040001020E0320000A0420001D030620011D0E1D03060002020E10080507030208020307011C03070108060702120C1209050001111508160100114164616D4E6163686D616E2E5371436C7200000501000000001101000C4164616D204E6163686D616E00000A0100055371436C7200002301001E436F7079726967687420C2A9204164616D204E6163686D616E203230313000000501000100000801000701000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F77730100000000001519824C000000000200000052000000C4300000C412000052534453771D13ADC453934B8965726A0124952D08000000433A5C53616E64626F785C63695C7472756E6B5C5371436C725C6F626A5C44656275675C4164616D4E6163686D616E2E5371436C722E7064620000004031000000000000000000005E3100000020000000000000000000000000000000000000000000005031000000000000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF25002040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001001000000018000080000000000000000000000000000001000100000030000080000000000000000000000000000001000000000048000000584000005C03000000000000000000005C0334000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100050001009A543B0F050001009A543B0F3F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B004BC020000010053007400720069006E006700460069006C00650049006E0066006F0000009802000001003000300030003000300034006200300000003C000D00010043006F006D00700061006E0079004E0061006D006500000000004100640061006D0020004E006100630068006D0061006E00000000004C0012000100460069006C0065004400650073006300720069007000740069006F006E00000000004100640061006D004E006100630068006D0061006E002E005300710043006C007200000040000F000100460069006C006500560065007200730069006F006E000000000031002E0035002E0033003800390039002E0032003100360035003800000000004C001600010049006E007400650072006E0061006C004E0061006D00650000004100640061006D004E006100630068006D0061006E002E005300710043006C0072002E0064006C006C00000060001E0001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A90020004100640061006D0020004E006100630068006D0061006E002000320030003100300000005400160001004F0072006900670069006E0061006C00460069006C0065006E0061006D00650000004100640061006D004E006100630068006D0061006E002E005300710043006C0072002E0064006C006C0000002C0006000100500072006F0064007500630074004E0061006D006500000000005300710043006C007200000044000F000100500072006F006400750063007400560065007200730069006F006E00000031002E0035002E0033003800390039002E00320031003600350038000000000048000F00010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0035002E0033003800390039002E00320031003600350038000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003000000C000000703100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
    WITH PERMISSION_SET = SAFE;

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Apache License, Version 2.0

Written By

Adam Nachman

Chief Technology Officer

Australia

Emigrated to Sydney, Australia in 2013 from Cape Town, South Africa, and have been writing commercial software since 1997.

Expertise includes MS SQL Server (7 till latest), C#, VB6, VB.NET, VBScript, JavaScript, ASP, HTML, WPF Angular, Windows Installer and InstallShield (multiple versions) and a partridge in a pear tree. MSBuild, CruiseControl.NET, TFS, Jenkins, TeamCity, ant and nant are all necessary sidelines. Have tinkered with Java and C++

Experienced with Enterprise level application design and deployment, as well as sizing and scaling high volume OLTP database designs up to tens of thousands of transactions per second and diagnosing application and database performance bottlenecks.

Continuous Integration for Databases with Visual Studio

License

Comments and Discussions