CLI Sample Project - using AdventureWorks2012
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
souce_control/DB/AdventureWorks2012
Export.bat
Import.bat
README.md
opts.json

README.md

CLI Sample Project

gitSQL SQL Server Edition

Purpose

To demonstrate usage of CLI features on gitSQL.

See https://gitsql.net/documentation for more detailed usage instructions.

Usage Examples

  1. Import.bat Imports AdventureWorks2012 from source_control into the desired SQL Server Instance as specified in the batch file.

  2. Export.bat Exports AdventureWorks2012 into source_control from the desired SQL Server Instance as specified int he batch file. Options file usage included

  3. opts.json Contains sample options which can be used as part of an export. N.B. This options is required for an Import where more than one DB is detected in the source control path.

Options file

{
	"includeDrop": "false",
	"includeDependencies": "false",
	"includeIndexes" : "false",
	"includeConstraints": "false",
	"includeTriggers": "false",
	"replace":{
		"findMe": "SET QUOTED_IDENTIFIER ON",
		"replaceWith": ""
	},
	"db": "AdventureWorks2012"
}