app and db versioning

[Chris]

I work in VS 2008 connected to TFS 2008.
Source code is a compact framework 3.5 project containing compact sql server
database (.sdf file).
I would like to provide versioning of the app and its .sdf file. Any ideas
how to do that?
I was thinking about:
- creating a table in cocket database (.sf file) that will contain version
number
- adding a version number to my app source code
- it would work this way: when the app is starting, it is checking its
version with version stored in db

The problem is how to update the version of the db and app at the same
time. the best way is to do it automatically.

I was thinking about creating add-in to VS 2008 that will update version
number of the app and the version stored in the db, when the db file is being
checked in to TFS.

Is it possible?
creating an add-in to VS 2008 that would

 

[Pavel Minaev]

I work in VS 2008 connected to TFS 2008.
Source code is a compact framework 3.5 project containing compact sql server
database (.sdf file).
I would like to provide versioning of the app and its .sdf file. Any ideas
how to do that?
I was thinking about:
- creating a table in cocket database (.sf file) that will contain version
number
- adding a version number to my app source code
- it would work this way: when the app is starting, it is checking its
version with version stored in db

The problem is how to update the version of the db and app at  the same
time. the best way is to do it automatically.

I was thinking about creating add-in to VS 2008 that will update version
number of the app and the version stored in the db, when the db file is being
checked in to TFS.

Is it possible?

It is possible, though I think that you'd probably prefer it to be a
TFS add-in rather than a VS add-in (what if someone checks in using
"tf" from command line? or simply doesn't have an add-in installed)?
Look here on how to register for TFS notifications:

http://msdn.microsoft.com/en-us/library/bb130154.aspx

And here's how a check-in event XML packet looks like:

http://tranxcoder.wordpress.com/2008/06/16/generating-custom-tfs-check-in-e-mails-part-35/