Link to home
Start Free TrialLog in
Avatar of arvapal
arvapal

asked on

How to maintain version history in the same file in team foundation server 2008

Hi Experts,

How to maintain version history in the same file in tfs 2008?

Our requirement is to maintain version history / updated date information inside the checkin files (database .sql files) This will help us to track the post deployment issues with respect to database.

This is something similar to Keyword expansion feature in Visual Source Safe. I have seen some articles in google which says, keyword explansion support has been removed in TFS 2008.

Without this feature, i am facing lot of problems in my current project.

But is there any workaround to achieve this?

i have so many hopes in experts exchange EXPERTS

Any kind of hlep is highly appreciable.
Avatar of dportas
dportas

Perhaps it's possible using a little PowerShell magic. Some examples that may help:
http://blogs.msdn.com/jmanning/archive/2006/09/28/776141.aspx
Avatar of arvapal

ASKER

Hi,

I have gone through that link, but not exactly the same.

Below is my exact requirement.

I have the database scipts at production, Staging and Testing environment.

Currently, i don't have any version control for the db scripts. Due to that problem, for any issues with respect to the database scripts, i am unable to track the version of that script which  is running at Production or Staging server.

To address that problem, i have to maintain the version history on the top of the script file itself.

So any additional information would be greatly appreciated.
ASKER CERTIFIED SOLUTION
Avatar of Bob Learned
Bob Learned
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This question has been answered.  TheLearnedOne provided proof that the feature has been removed in TFS 2008 and I provided a workaround.  There's also other suggestions for workarounds listed in TheLearnedOne's link.  While the workarounds are not simple and I did not provide sample code, I think it deserves a C or B - the question was answered.