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