As most people here I have a load of scripts. There is no real organisation in these scripts, because they are collected from projects, from the internet, own developments, examples from others etc.
Does anybody here use a database to keep the scripts and snippets off scripts in?
I asume a lot of people must be doing this, but searching on 'SCRIPT DATABASE SQLSERVER' does
not give the required results. (Suggestions for better searches are wellcome).
Scripts is in the broadest sense of the wordt.
Scripts with examples of SQL - constructions, String functions, functions.
Scripts where the table name has to be substituted in.
In my view the scrips would have a group (or scope) and a name.
Offcourse the database would be searchable.
Scripts should parts which can be replaced.
Export to file (off all scripts), import from file (from all script).
Searching on scripts, showing of scripts execution of scripts (With some substitutions ?).
At the moment I keep mij scripts in files, but is a database a better place to keep al my scripts ?
How?, Where?, What? Suggestions?, Internet links for databases which contain scripts?
Offcourse I have my own idea's, but I suspect this has been done before, so I'll can use an existing one or learn from that. Thanks.
Thanks for your time and attention,