Tell me about it. I would take that approach if it was an option. It has to be done through cf on a live production db before tomorrow morning.
On Thu, Nov 12, 2009 at 1:02 PM, Alan Rother <[email protected]> wrote: > > Well... There are a number of techniques for ensuring data integrity. > > In cases where I'm using CF to manage a bulk import (rather than the > database itself) I tend to use a staging database to import the data and > then I only transfer it to the production database IF the import passes > some > sort of checksum test. Then I manage the data transfer from the staging > database to the production database using a DTS package(MS SQL) rather than > using CF as database specific data migration tools tend to work far more > quickly and a far more reliable. > > =] > > -- > Alan Rother > Adobe Certified Advanced ColdFusion MX 7 Developer > Manager, Phoenix Cold Fusion User Group, AZCFUG.org > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328322 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
