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
-------------------------------------------------------------
