This is why i like rails so much (not knocking coldfusion, just
thought I'd share a bit). One thing I don't like about ant is that it
is just executing sql scripts. You don't actually write code to create
your tables.
one command: rake db:migrate
creates the tables, no sql scripts, xml or any of that jazz.
migration code:
class CreateSimpleforms < ActiveRecord::Migration
def self.up
create_table :shirt_sizes do |t|
t.column :first_name, :string
t.column :last_name, :string
t.column :shirt_size, :string
t.column :created_at, :datetime
t.column :updated_at, :datetime
end
end
def self.down
drop_table :shirt_sizes
end
end
On 5/21/07, Fennell, Mark P. <[EMAIL PROTECTED]> wrote:
I don't know if MS SQL has the option or not, but in some RDMBS you can
audit the DDL so that everytime a table or view or index is created,
altered, or deleted the system writes/appends the actions to a log file.
Then you can just run the log file against another db to "replay" the
actions. This would be handy from scratch, but if you already have the
system in place, there might be a bit a work to collect the ddl on existing
objects. Just a thought.
mf
________________________________
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Douglas Knudsen
Sent: Monday, May 21, 2007 1:02 PM
To: discussion@acfug.org
Subject: Re: re[2]: [ACFUG Discuss] database code and source control
ah, too manual for me for long term, we got over 30 apps. I'm looking at
using ANT, has a SQL task for this. Just wondering if anyone has played
with this approach before.
DK
On 5/21/07, Mischa Uppelschoten ext 10
<[EMAIL PROTECTED]> wrote:
>
>
> To be honest, I just load them in Query Analyzer and run them, but you
could also run them in a script (VB, batch) using the OSQL utility.
>
> : yes. How do you plan to execute these scripts?
>
> : DK
>
>
> : On 5/21/07, Mischa Uppelschoten ext 10 <
[EMAIL PROTECTED]>
> : wrote:
> :
> : Im moving to having all my MS SQL objects scripted and stored as a file
and
> : only make changes to my db through that script. Is that what you mean?
> : Mischa.
> :
> : : We are about to embark on constructing a staging database here to sit
> : between
> : : our dev and prod ones. I have all our app code in CVS and move it
between
> : : dev, staging, and prod servers. What do folks do with SQL code?
Sure, can
> : : store it with the app codein CVS or whatever SCM tool, but how to
execute
> : it?
> : : Looks like I can use ANT, but what are others doing with respect to
this?
>
> : : --
> : : Douglas Knudsen
> : : http://www.cubicleman.com
> : : this is my signature, like it?
> : :
-------------------------------------------------------------
> : : Annual Sponsor - Figleaf Software
> : :
> : : To unsubscribe from this list, manage your profile @
> : : http://www.acfug.org?fa=login.edituserform
> : :
> : : For more info, see http://www.acfug.org/mailinglists
> : : Archive @
http://www.mail-archive.com/discussion%40acfug.org/
> : : List hosted by FusionLink
> : :
-------------------------------------------------------------
>
>
>
>
> : Mischa Uppelschoten
> : The Bankers Exchange, Inc.
>
> : 2020 Hills Avenue NW
> : Atlanta, GA 30318
>
> : Phone: (404) 605-0100 ext. 10
> : Fax: (404) 355-7930
> : Web: www.BankersX.com
> : Follow this link for Instant Web Chat:
> :
http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN
> :
> : ----------------------- Original Message -----------------------
> :
> : From: "Douglas Knudsen" <[EMAIL PROTECTED]>
> : To: discussion@acfug.org
> : Date: Mon, 21 May 2007 12:03:39 -0400
> : Subject: [ACFUG Discuss] database code and source control
> :
> : We are about to embark on constructing a staging database here to sit
between
> : our dev and prod ones. I have all our app code in CVS and move it
between
> : dev, staging, and prod servers. What do folks do with SQL code? Sure,
can
> : store it with the app code in CVS or whatever SCM tool, but how to
execute
> : it? Looks like I can use ANT, but what are others doing with respect
to
> : this?
>
> : --
> : Douglas Knudsen
> : http://www.cubicleman.com
> : this is my signature, like it?
> :
-------------------------------------------------------------
> : Annual Sponsor - Figleaf Software
>
> : To unsubscribe from this list, manage your profile @
> : http://www.acfug.org?fa=login.edituserform
>
> : For more info, see http://www.acfug.org/mailinglists
> : Archive @
http://www.mail-archive.com/discussion%40acfug.org/
> : List hosted by FusionLink
> :
-------------------------------------------------------------
> :
-------------------------------------------------------------
Annual Sponsor
> : FigLeaf Software - http://www.figleaf.com To unsubscribe from this
list,
> : manage your profile @
http://www.acfug.org?fa=login.edituserform For more
> : info, see http://www.acfug.org/mailinglists Archive @
> : http://www.mail-archive.com/discussion%40acfug.org/
List hosted by
> : http://www.fusionlink.com
> :
-------------------------------------------------------------
>
>
> : --
> : Douglas Knudsen
> : http://www.cubicleman.com
> : this is my signature, like it?
> :
-------------------------------------------------------------
> : Annual Sponsor - Figleaf Software
> :
> : To unsubscribe from this list, manage your profile @
> : http://www.acfug.org?fa=login.edituserform
> :
> : For more info, see http://www.acfug.org/mailinglists
> : Archive @
http://www.mail-archive.com/discussion%40acfug.org/
> : List hosted by FusionLink
> :
-------------------------------------------------------------
>
>
>
>
>
> Mischa Uppelschoten
> The Banker's Exchange, Inc.
> 2020 Hills Avenue NW
> Atlanta, GA 30318
>
> Phone: (404) 605-0100 ext. 10
> Fax: (404) 355-7930
> Web: www.BankersX.com
> Follow this link for Instant Web Chat:
>
http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN
>
>
> ----------------------- Original Message -----------------------
>
> From: "Douglas Knudsen" <[EMAIL PROTECTED]>
> To: discussion@acfug.org
> Date: Mon, 21 May 2007 12:37:37 -0400
> Subject: Re: [ACFUG Discuss] database code and source control
>
> yes. How do you plan to execute these scripts?
>
> DK
>
>
> On 5/21/07, Mischa Uppelschoten ext 10 <
[EMAIL PROTECTED]> wrote:
> >
> >
> > I'm moving to having all my MS SQL objects scripted and stored as a file
and only make changes to my db through that script. Is that what you mean?
> > Mischa.
> >
> > : We are about to embark on constructing a staging database here to sit
between
> > : our dev and prod ones. I have all our app code in CVS and move it
between
> > : dev, staging, and prod servers. What do folks do with SQL code?
Sure, can
> > : store it with the app codein CVS or whatever SCM tool, but how to
execute it?
> > : Looks like I can use ANT, but what are others doing with respect to
this?
> >
> > : --
> > : Douglas Knudsen
> > : http://www.cubicleman.com
> > : this is my signature, like it?
> > :
-------------------------------------------------------------
> > : Annual Sponsor - Figleaf Software
> > :
> > : To unsubscribe from this list, manage your profile @
> > : http://www.acfug.org?fa=login.edituserform
> > :
> > : For more info, see http://www.acfug.org/mailinglists
> > : Archive @
http://www.mail-archive.com/discussion%40acfug.org/
> > : List hosted by FusionLink
> > :
-------------------------------------------------------------
> >
> >
> >
> >
> > Mischa Uppelschoten
> > The Banker's Exchange, Inc.
> > 2020 Hills Avenue NW
> > Atlanta, GA 30318
> >
> > Phone: (404) 605-0100 ext. 10
> > Fax: (404) 355-7930
> > Web: www.BankersX.com
> > Follow this link for Instant Web Chat:
> >
http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN
> >
> > ----------------------- Original Message -----------------------
> >
> > From: "Douglas Knudsen" <[EMAIL PROTECTED]>
> > To: discussion@acfug.org
> > Date: Mon, 21 May 2007 12:03:39 -0400
> > Subject: [ACFUG Discuss] database code and source control
> >
> > We are about to embark on constructing a staging database here to sit
between our dev and prod ones. I have all our app code in CVS and move it
between dev, staging, and prod servers. What do folks do with SQL code?
Sure, can store it with the app code in CVS or whatever SCM tool, but how to
execute it? Looks like I can use ANT, but what are others doing with
respect to this?
> >
> > --
> > Douglas Knudsen
> > http://www.cubicleman.com
> > this is my signature, like it?
> >
-------------------------------------------------------------
> > Annual Sponsor - Figleaf Software
> >
> > To unsubscribe from this list, manage your profile @
> > http://www.acfug.org?fa=login.edituserform
> >
> > For more info, see http://www.acfug.org/mailinglists
> > Archive @
http://www.mail-archive.com/discussion%40acfug.org/
> > List hosted by FusionLink
> >
-------------------------------------------------------------
-------------------------------------------------------------
Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from
this list, manage your profile @
http://www.acfug.org?fa=login.edituserform For more info,
see http://www.acfug.org/mailinglists Archive @
http://www.mail-archive.com/discussion%40acfug.org/ List
hosted by http://www.fusionlink.com
-------------------------------------------------------------
>
>
>
> --
> Douglas Knudsen
> http://www.cubicleman.com
> this is my signature, like it?
>
-------------------------------------------------------------
> Annual Sponsor - Figleaf Software
>
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @
http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by FusionLink
>
-------------------------------------------------------------
>
-------------------------------------------------------------
Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from
this list, manage your profile @
http://www.acfug.org?fa=login.edituserform For more info,
see http://www.acfug.org/mailinglists Archive @
http://www.mail-archive.com/discussion%40acfug.org/ List
hosted by http://www.fusionlink.com
-------------------------------------------------------------
--
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it?
-------------------------------------------------------------
Annual Sponsor - Figleaf Software
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @
http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-------------------------------------------------------------
-------------------------------------------------------------
Annual Sponsor - Figleaf Software
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @
http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-------------------------------------------------------------
--
Steven Ross
web application & interface developer
http://www.zerium.com
[mobile] 404-488-4364
[fax] 267-482-4364
-------------------------------------------------------------
Annual Sponsor FigLeaf Software - http://www.figleaf.com
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
