Solved

comments in sql server stored procs using SVN

Posted on 2009-05-13
1
364 Views
Last Modified: 2013-11-25
Hi folks. I'm trying to move our team from VSS to SVN, so far so good, but a small issue came up. In our sql sprocs when we used VSS we added the following comments

-- =============================================
-- $Archive: <path>$
-- $Revision: <revision #> $
-- $Date: <date> $
-- $Author: <author> $
-- =============================================

where the items between angle brackets were populated by VSS and the script file would have the information after every check in. This helped us track sql sprocs when we went from dev to prod. Is there a way to do this in SVN? a hook of some sort or built in functionality that anyone knows of?  Any and all help is appreciated.

Thanks
Z
0
Comment
Question by:zaidmarji
1 Comment
 
LVL 25

Accepted Solution

by:
reb73 earned 250 total points
ID: 24377697
I think you have to enable keyword substitution on SVN..

See link below to see if it helps -

http://svnbook.red-bean.com/en/1.5/svn-book.html#svn.advanced.props.special.keywords
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question