Re: Last Date Stored Proc Updated???
- From: "Malcolm" <malcolm.leach@xxxxxxxxxxxxxxxx>
- Date: 7 Jul 2005 02:45:57 -0700
Guys, there really is a great way of working with your SQL code in just
the same way as you do for your application code and it's called DB
Ghost (www.dbghost.com). It's the ONLY SQL Server tool on the market
that can build a brand new database from a set of object creation
scripts taking care of all dependencies. This database is then used by
D Ghost to compare and upgrade any target database.
The upshot of our approach is that you have ALL database objects as
'create' scripts under source control and just modify those. You work
in a familiar manner and the source control system becomes your friend
rather than a necessary evil. Most other approaches to having SQL in
source control involve having to do two things for each update:
1. Update the create script.
2. Write an ALTER script.
DB Ghost does away with the second of these not just for stored
procedures but for EVERY database object.
Honestly, you may think this approach cannot work but it does and our
customers use phrases like 'religious experience' when they talk about
it. You just have to take the time to 'get' it...
.
- Follow-Ups:
- Re: Last Date Stored Proc Updated???
- From: pb648174
- Re: Last Date Stored Proc Updated???
- References:
- Last Date Stored Proc Updated???
- From: John
- Re: Last Date Stored Proc Updated???
- From: vjdileo
- Re: Last Date Stored Proc Updated???
- From: Erland Sommarskog
- Last Date Stored Proc Updated???
- Prev by Date: Re: ##temp table already exists problem
- Next by Date: Re: Reading data from Navision to SQL Server: Date issues
- Previous by thread: Re: Last Date Stored Proc Updated???
- Next by thread: Re: Last Date Stored Proc Updated???
- Index(es):
Relevant Pages
|
