It was a table actually missing an index. Yes... SQL 2005 has SQL Server Management Studio.. similar to Enterprise Manager.
Oh.. SQL 2005 does not use DTS... it uses SSIS. There is a way you can migrate DTS packages to Integrated Services. I did not personally do it. Our DB guy did. -----Original Message----- From: Michael Grant [mailto:[email protected]] Sent: Wednesday, January 21, 2009 7:34 AM To: cf-community Subject: RE: MX7/SQL2K migration to CF8/SQL2K5 :: advice please > This issue was a column here and there not indexed. Jacob, did you just recreate the indexes? Another question. I use Enterprise Manager for 2K. Does SQL2K5 Express have the same type of gui? > > 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:285937 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
