RE: VSS in Sync with DB
- From: mark baekdal <markbaekdal@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 7 Sep 2005 13:41:04 -0700
Hi Joe,
check out this white paper on database change management -
http://www.innovartis.co.uk/pdf/Innovartis_An_Automated_Approach_To_Do_Change_Mgt.pdf
to summarize the process:
Developers make changes to the source code which is treated as the central
repository for all source code
The code is built at regular intervals - this is the heart beat of any
project as it can show everyone what is to be delivered, if the code actually
builds and can be deployed. If you don't have a heart beat, you're probably
dead!
DB Ghost does this which is why it is more than a comparison tool.
A common scenario that you touched on can be easily and quickly rectified.
Developers not checking in the changed and or new code to the source control.
With a regular build (interesting there's a plug in for CruiseControl.net and
NANT for DB Ghost) everyone has visibility over everyone elses code so the
common complaint that you hear from developers to testers is "but it works on
my machine" will disappear because DB Ghost allows the speedy release of
labeled source code to any environment - so the testers and developers can
have exactly the same source code. If it doesn't work on the test environment
then you have probably got a rogue developer - ask him if he checks in all
his procedural code for EXE's and DLL's as well.
What sits on a developers desktop is not as important as a central source
control that does what it says - gives you control. Developers soon learn as
no-one wants to be the one who broke the build. They can easily do the builds
on there own machines before check in. It really is a damn simple concept
that DB Ghost handles with ease.
Source control > Label > Build > Test deploy
Everyone knows that a build process is a good thing, databases really aren't
any different.
regards,
Mark Baekdal
MSN m_baekdal@xxxxxxxxxxx
+44 (0)141 416 1490
+44 (0)208 241 1762
http://www.dbghost.com
http://www.innovartis.co.uk
Build, Comparison and Synchronization from Source Control = Database change
management for SQL Server
"Joe" wrote:
> We use Red-Gate SQL Compare for keeping our DB in sync as we move up from
> dev to test to pre-prod and finally production.
>
> Now the developers aren't keeping VSS in Sync - is there an easy way to
> compare VSS with our Dev environment?
>
> As far as I can tell - Getting all the Objects from VSS and loading them
> into a temp DB ans using SQL Compare works well - but is time consuming.
>
> Any better ways or tool I can use to expedite checking on drop day that VSS
> is in Sync with our DB?
>
>
>
.
- References:
- VSS in Sync with DB
- From: Joe
- VSS in Sync with DB
- Prev by Date: Re: SQL profiler question
- Next by Date: ANN :: AGS SQL scribe Documentation Builder - New Pricing
- Previous by thread: VSS in Sync with DB
- Next by thread: Profiler showing no host data
- Index(es):
Relevant Pages
|
Loading
