Corey,

Another tool to look at for source control is Perforce
(www.perforce.com). This tracks code changes and could indirectly
track changes to db schema.

S. Davey (5/30)

MI DIT\Agency Services
7:30 A.M. - 4:00 P.M. ET
517.335.4237 (M- F CCC )


>>> "Dylan Finney "
<mssqldba-ezmlmshield-x41362856.[Email address protected] 05/30/07
1:37 PM >>>
Does anyone know if Visual Studio Team Edition does this? VSS
integration (that I've seen) has been sorely lacking on the database
end. Project control is fantastic though!

-----Original Message-----
From: Carolyn Jewel
[mailto:mssqldba-ezmlmshield-x71828539.[Email address protected]
Sent: Wednesday, May 30, 2007 11:34 AM
To: LazyDBA Discussion
Subject: RE: Source Control that can Compare and Deploy

My previous employer kind of sort of used a CA product, I forget what
it
was called. It would do all those things including automating the
deployment, but it was horrible, awful completely nightmarish. A
company
with a few million to put behind a proper deployment and some really
smart analysts might end up with something worth having. Our company
had
neither. I get hives just thinking about it.

Carolyn J


-----Original Message-----
From: Gilson Corey
[mailto:mssqldba-ezmlmshield-x9953112.[Email address protected]
Sent: Wednesday, May 30, 2007 10:26 AM
To: LazyDBA Discussion
Subject: RE: Source Control that can Compare and Deploy

No responses... I take it everyone is about as nonplussed about their
source control as we are! Ha-ha.

-----Original Message-----
From: Gilson Corey
[mailto:mssqldba-ezmlmshield-x57435100.[Email address protected]
Sent: Wednesday, May 30, 2007 8:57 AM
To: LazyDBA Discussion
Subject: Source Control that can Compare and Deploy

Does anyone have a source management system that can do these two
things?

1. Compare DDL in a database with the source repository.
2. Deploy a proc, function or view to a database from the
source tool.

We're going to buy a new code management system (and maybe an extra
tool
to interact with the database) for all of our DB and application code.


Alternatively,
Is anyone out there really happy with their source code management
solution? Why?


--Corey


CONFIDENTIAL AND PROPRIETARY
The contents of this communication are confidential and proprietary to
ShopLocal, LLC and may not be reproduced, published or disclosed to
others without express authorization of ShopLocal, LLC

Copyright (c) 2007 ShopLocal, LLC May not be used, copied or
distributed
without permission. All Rights Reserved.




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post
a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com

To unsubscribe: http://www.lazydba.com/unsubscribe.html



CONFIDENTIAL AND PROPRIETARY
The contents of this communication are confidential and proprietary to
ShopLocal, LLC and may not be reproduced, published or disclosed to
others without express authorization of ShopLocal, LLC

Copyright (c) 2007 ShopLocal, LLC May not be used, copied or
distributed
without permission. All Rights Reserved.




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post
a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com

To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post
a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com

To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



MS Sql Server LazyDBA home page