Solved

comments in sql server stored procs using SVN

Posted on 2009-05-13
1
363 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard 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.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now