way kewl, yes, curious, what happens when changes are made? Does rails
generate alters?
DK
On 5/21/07, Steven Ross <[EMAIL PROTECTED]> wrote:
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
-------------------------------------------------------------
--
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it?
-------------------------------------------------------------
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
-------------------------------------------------------------
