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-archive.com/discussion%40acfug.org/ <http://www.mail-archive.com/discussion%40acfug.org/> : List hosted by FusionLink : ------------------------------------------------------------- : ------------------------------------------------------------- Annual Sponsor : FigLeaf Software - http://www.figleaf.com <http://www.figleaf.com> 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 : http://www.fusionlink.com <http://www.fusionlink.com> : ------------------------------------------------------------- : -- : 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 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 <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: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] <mailto:[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 <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 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 <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 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 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 -------------------------------------------------------------