On 7/17/07, Kris Jones <[EMAIL PROTECTED]> wrote: > Thanks so much Barney. We had written a tool to do cross-site updates > for SQL integration, but it hasn't been proven-out yet, so it'll be > good to see how your tool handles this issue. Will download and read > included docs now! > > Tom & John, we do use virtual dirs in IIS for handling different > clients in dev (across the same code-base). Where we have been coming > up short, I think, is that we don't have as many dev DBs as configs > that we need to run. It sounds like if we were doing that, the config > issue would be a non-issue (the config is spec'd per client). Then we > wouldn't be turning x-option on/off on any specific client. > > Tom: (never saw your post, but saw the reference in John's post. There > may have more you said that I missed) > > As for running local DBs, not sure that is an option as our DB is > large. That would mean regular downloads/restores on every dev > station? This does beg the question of how we'll manage keeping our > dev data in tune. It's time consuming with 1 or 2 DBs, but start > talking 9 or 10, we're looking at a lot of time.
There's two pieces, right -- schema, and data. Developers need the schema and "enough" data, whatever that means.I find the redgate software tools are pretty spectacular as an aside for both moving/syncing schema and data. > > I'd be interested in any good Ant references anyone can throw my way as well. Pragmatic Project Automation with Ant is a good lite start. You can also take a look at the DBUnit task for Ant which will help you reset your database(s)... :) > > Thanks much, > Kris > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283927 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
