De:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Jeremy Thake
Enviado el: Monday, September 18,
2006 8:05 PM
Para: [email protected]
Asunto: Re: [OzTFS] Database
Integration in Builds
I've done a few projects
now with Continuous Integration including rebuilding the database from scripts
each time.
It is really great in a big team where you do this because it enforces that
people always put their changes in the stored procudure scripts, table creation
scripts, data generation scripts etc. rather than making changes directly to
their own developer instance of the database and then wondering why no one else
can get an environment up and running.
It also means that it is really easy to get someone up and running in a
development environment because you just run the scripts locally. We all know
how much of a pain it is hunting things down to build a project don't we!
I use CruiseControl.Net at the moment with NANT calling the MS SQL command
line. What way were you looking to execute the scripts in TFS? We found the
tricky thing was firing the scripts in the correct order due to dependencies on
other stored procedures etc. and obviously running TABLE creates before VIEWS
etc.
Be great to see what others do,
Jeremy Thake
On 9/19/06, Mitch
Denny <[EMAIL PROTECTED]
> wrote:
Hi Christian,
Cool. I like the idea of having a suite
of ordered tests which build up the database incrementally, including adding
schema, sample data, schema, sample data. So each unit test would represent a
new version of the database.
Hi Mitch
We have just started this project. The idea is create builds where code and
database are created from source control and the database is deployed as part
of the out put.
We want to be able to create releases
where the database schema and code are a part of the release and enable us to
always get a working copy of the database. We have used Speed SQL pro for
database source control, but are looking at the TFS Team Database edition as
replacement.
While we are waiting to see what TFS
Database can do for us :), we are creating a custom build task, which collects
SQL statement form Source control and creates the database.
Hi Christian,
I'm interested to hear your experiences around integrating database
operations into your build. I kind of like the idea of the build
bringing everything it needs with it and only giving it things like a
connection string to get started. Whereby it builds the database up from
scratch.
-----Original Message-----
From: [EMAIL PROTECTED]
[
mailto:[EMAIL PROTECTED]] On Behalf Of
Christian Gram
Sent: Monday, 18 September 2006 9:39 PM
To: [email protected]
Subject: RE: [OzTFS] Introductions
Name: Christian Gram
Location: Copenhagen, Denmark.
Employer: SoftwarePeople
TFS experience (pick some): Installation, maintenance, proxy server,
Extending, Process templates, Builds, Project server integration
Current projects: Database integration in builds
Favorite TFS tools (with links):
-----Original Message-----
From: [EMAIL PROTECTED]
[
mailto:[EMAIL PROTECTED]] On Behalf Of
Grant Holliday
Sent: Monday, 18 September 2006 5:44 PM
To: [email protected]
Subject: [OzTFS] Introductions
Hi again,
What I thought would be a good way to kick of the list is to start
with a round of introductions. So if you just want to reply to the
list with a bit about yourself, that would be great!
(I'll even give you a template to start with, just copy and paste)
------
Name:
Location:
Blog:
Employer:
TFS experience (pick some): Installation, Process Guidance, Extending
TFS, Team Build, Building Teams, Reporting, Anything else..
Current projects:
Current goals:
Favorite TFS tools (with links):
------
Name: Grant Holliday
Location: Canberra, Australia
Blog: http://www.holliday.com.au/
Employer: Readify (www.readify.net)
TFS experience:
* Installation
* Extending TFS
* Migrating from SourceSafe
* TFS MSSCCI Provider
* Reporting
Current projects:
I'm currently working for a large australian government department and
migrating their 3Gb SourceSafe database into TFS. They are still on
1.1, so I've been using the MSSCCI Provider in anger and I've been
building a web-wrapper around the TFS API to facility user permissions
for the 300+ developers they have.
Current goals:
* I'd like to learn more about reporting using the TFS cube
* I'm looking to become MCT certified so that I can deliver some TFS
training
* And of course, building a community :)
Favorite TFS tools:
* The new TFS power tools are my favourite. tfpt.exe history
/followbranches is neat
http://blogs.msdn.com/bharry/archive/2006/09/07/744993.aspx
* I have found the TFS Sidekicks from Attrice is handy for
viewing/deleting workspaces in a large developer environment.
http://www.attrice.info/cm/tfs/
* and of course, my own little tools (TFS Bug Snapper,
TfsDownloadFile, TfsGroupMemberImport, TfsListProjectAreas) - all of
which are invaluable while migrating this mammoth VSS database.
http://www.projectdistributor.net/Groups/Group.aspx?groupId=80
So that's me, how about you?
Grant
OzTFS.com - to unsubscribe from this list, send a message back to the
list with 'unsubscribe' as the subject.
Powered by mailenable.com -
List managed by www.readify.net
OzTFS.com - to unsubscribe from this list, send a message back to the
list with 'unsubscribe' as the subject.
Powered by mailenable.com -
List managed by www.readify.net
OzTFS.com - to unsubscribe from this list, send a message back to the
list with 'unsubscribe' as the subject.
Powered by mailenable.com -
List managed by www.readify.net
OzTFS.com - to unsubscribe from this list, send a message back to the list with
'unsubscribe' as the subject.
Powered by mailenable.com -
List managed by www.readify.net
OzTFS.com
- to unsubscribe from this list, send a message back to the list with
'unsubscribe' as the subject.
Powered by mailenable.com -
List managed by www.readify.net
OzTFS.com - to unsubscribe from this list, send a
message back to the list with 'unsubscribe' as the subject.
Powered by mailenable.com
- List managed by www.readify.net
OzTFS.com - to unsubscribe from this list, send a message back to the list with
'unsubscribe' as the subject.
Powered by mailenable.com - List managed by www.readify.net
OzTFS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject.
Powered by mailenable.com - List managed by www.readify.net
|
