actually you just generate another migration...
so you could alter_table instead of create_table or whatever. Every
time you create a migration it gets a number ie: 001_inital_create.rb
002_alter_blah.rb
and so on.
so then you can do: rake db:migrate VERSION=0 (drops all tables) or
specify a target... or no target and it migrates to your latest
migration script.
On 5/21/07, Douglas Knudsen <[EMAIL PROTECTED]> wrote:
> 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
>
> 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
