StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POVisual Source Safe Automated Commit
text
Body
copied!<p>I am currently attempting to set up an automated add/checkout/checking script using MS Visual Source Safe via command line. Online documentation is... lacking... and I was hoping that someone else had tried doing something like this in the past. </p> <p>Before going any further, I am well aware that there are other, better alternatives to VSS, so please don't give "use SVN" as an answer.</p> <p>The files I've got are a scripted version of our database schema, and looks like this in the repo: </p> <p>$/project_name/DBScripts/servers/databases/object_types, where object_types are Tables, StoredProcedures, etc.</p> <p>I am attempting to do the following: </p> <p>1- Script all database object to files. This part is done and working correctly.<br> 2- Add all new files to repo.<br> 3- Commit all files that have changed. Make sure files do NOT remain checked out or read-only.</p> <p>EDIT 2:</p> <p>Removed old code again. Included current code below. Add works correctly, but the checkout command does NOT work on any files that were changed locally.</p> <p>In this context, if I were to modify stored proc A, script it to file, then try running the batch commands below, all procs BUT A will be checked out. </p> <p>I've included 2 examples of the checkout command. Neither is working...</p> <pre><code>set PATH=%path%;C:\Program Files\Microsoft Visual SourceSafe set SSDIR=repo_path cd DBScripts/server/database/StoredProcedures ss cp $/project/DBScripts/server/database/StoredProcedures for %%F in (*.*) do ss add %%~nF%%~xF -C- -I-N -K- -W for %%F in (*.*) do ss checkout $/project/DBScripts/server/database/StoredProcedures/%%~nF%%~xF -C- -G- -M- -L+ ss checkout $/project/DBScripts/server/database/StoredProcedures *.* -C- -G- -M- -L+ -Vltemp for %%F in (*.*) do ss checkin %%~nF%%~xF -C- -K- -P $/project/DBScripts/server/database/StoredProcedures -W cd ../../../.. </code></pre> <p>Note: SourceSafe's "-R" command is inconsistent. I'd rather loop through all subfolders manually and do "for %%F in (<em>.</em>)" commands.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload