Re: re[2]: [ACFUG Discuss] database code and source control
moving this part to community if anyone wants to talk non CF On 5/21/07, Steven Ross <[EMAIL PROTECTED]> wrote: 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 - Fig
Re: re[2]: [ACFUG Discuss] database code and source control
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 > >
Re: re[2]: [ACFUG Discuss] database code and source control
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 &
Re: re[2]: [ACFUG Discuss] database code and source control
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 > : - > :
RE: re[2]: [ACFUG Discuss] database code and source control
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]>
<mailto:[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 <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
<http://www.acfug.org?fa=login.edituserform>
: :
: : For more info, see http://www.acfug.org/mailinglists
<http://www.acfug.org/mailinglists>
: : Archive @
http://www.mail-archive.com/discussion%40acfug.org/
<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 <http://www.BankersX.com>
: Follow this link for Instant Web Chat:
: http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN
<http://www.bankersx.com/Contact/chat.cfm?Queue=MUPPELSCHOTEN>
:
: --- Original Message
---
:
: From: "Douglas Knudsen" <[EMAIL PROTECTED]>
<mailto:[EMAIL PROTECTED]>
: To: discussion@acfug.org <mailto: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 <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
<http://www.acfug.org?fa=login.edituserform>
: For more info, see http://www.acfug.org/mailinglists
<http://www.acfug.org/mailinglists>
: Archive @ http://www.mail-archiv
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]> <[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]><[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]><[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
re[2]: [ACFUG Discuss] database code and source control
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 UppelschotenThe Banker's Exchange, Inc.2020 Hills Avenue NWAtlanta, GA 30318Phone:(404) 605-0100 ext. 10Fax:(404) 355-7930Web:www.BankersX.comFollow 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
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]><[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 <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 FusionLink <http://www.fusionlink.com> - - 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 -
re: [ACFUG Discuss] database code and source control
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 UppelschotenThe Banker's Exchange, Inc.2020 Hills Avenue NWAtlanta, GA 30318Phone:(404) 605-0100 ext. 10Fax:(404) 355-7930Web:www.BankersX.comFollow 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 Knudsenhttp://www.cubicleman.comthis 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 -
[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 - 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 -
