>From CF7 to CF8... no issues. >From SQL 2000 to SQL 2005... the only issue I had was with some database/tables not properly indexed. Queries ran great under SQL 2000, but those same queries lagged under SQL 2005. This issue was a column here and there not indexed.
Overall, very painless. -----Original Message----- From: Michael Grant [mailto:[email protected]] Sent: Wednesday, January 21, 2009 6:31 AM To: cf-community Subject: MX7/SQL2K migration to CF8/SQL2K5 :: advice please I have a really extensive app (a flight management system) that I built on MX7 with SQL2K. I'd like to migrate it over to CF8 and SQL2K5. I'd like your advice, experiences, musings etc. I've done some googling, but since I figure this is the most knowledgeable place around I'd like to start here with some practical advice from people I respect. 1. Is there anything off hand you can think of that CF8 doesn't support the same? XML Webservices, CFDocument to create PDF's, CFC's, et all. 2. Same question for migrating from 2K to 2K5. My db (< 1gb) has some sprocs, some views, some additional indexes. Any advice, insights, warnings, heads ups, etc etc would be very appreciated. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:285934 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
