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]>
Date: Mon, 21 May 2007 12:37:37
-0400
Subject: Re: [ACFUG Discuss]
database code and source control
DK On 5/21/07,
Mischa Uppelschoten
ext 10 <
[EMAIL PROTECTED]>
wrote:
-- 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 ------------------------------------------------------------- |
- [ACFUG Discuss] database code and source contro... Douglas Knudsen
- re: [ACFUG Discuss] database code and sour... Mischa Uppelschoten ext 10
- Re: [ACFUG Discuss] database code and ... Douglas Knudsen
- re[2]: [ACFUG Discuss] database co... Mischa Uppelschoten ext 10
- Re: re[2]: [ACFUG Discuss] dat... Douglas Knudsen
- RE: re[2]: [ACFUG Discuss... Fennell, Mark P.
- Re: re[2]: [ACFUG Dis... Steven Ross
- Re: re[2]: [ACFUG... Douglas Knudsen
- Re: re[2]: [ACFUG... Steven Ross
- Re: re[2]: [ACFUG... Steven Ross