Skip to content

jimmywyatt/MSSQLTools

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

MSSQLTools

One of the most repetative tasks that i have to perform is to write Create, Update, Select and Delete stored procedures based on tables. To make this a bit eaiser I normally create a small tool that puts them together, I thought this might be useful for others as well.

This script format is based on the style guide published here Style Guide.

Creating your scripts

Download the sourcecode and run the project, it will ask you to choose a server, database and output folder into which the scripts will be placed.

Batch running scripts

Same as above, it will run any scripts in the sub directories specified and log the results.

Backup

Can be useful if you need to backup a data from the command line or thought the task scheduler.

Running

You can run the tool by calling MSSQLTools from the command prompt and following the prompts or passing --help and seeing the possible given parameters.

Licence

This project is licened under the MIT licence.

About

Tool for generating CRUD scripts from SQL tables

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages