re: [ACFUG Discuss] database code and source control

[Mischa Uppelschoten ext 10]

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