SSIS is really another whole product but yes, the successor to DTS. You can enable legacy support for DTS and install your packages but not really do much with them.
And the command line tools changed. Not many people use them but if you do (and I do), the osql command line tool changed to sqlcmd and some of the options are a bit different. Biggest change/pain in the ass about the switchover from Enterprise Manager to the SQL Server Management Studio is that it becomes really quite difficult to intelligently edit data directly. Besides that its not too bad, just different. As for CF, I haven't had much of any problems. There were a couple of name space collisions, like we wrote our own custom tags in CF7 to be able to do things in CFScript like FileMove. Well, CF8 has a FileMove command so that conflicted with our custom tag library. Just had to disable those custom tags and things were peachy. Bigger issue is whether you are moving from same product level or not. If you are moving from MX 7 Enterprise to 8 Standard you might run into some issues with things being throttled that you aren't aware of. But if you are going standard to standard or enterprise to enterprise, it shouldn't be a big deal. Judah On Wed, Jan 21, 2009 at 7:40 AM, Jacob <[email protected]> wrote: > 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:285957 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
