The datatypes coverted fine for the most part. I remember tweaking some numeric datatypes. My stored procedures worked correctly. I obviosuly miss DTS in my database manager, but I will have to learn SSIS here soon to make migrating databases easier.
The configuration is a bit more involved when setting up the datasource for 2005 vs 2000. I have worked in between 2005 and 2000 without much of an issue. I have both on my laptop and they work fine next to one another as well. Teddy On 10/13/06, Kevin Roche <[EMAIL PROTECTED]> wrote: > > Teddy, > > Have you noticed any particular issues with moving from SQL2000 to > SQL2005? > > Kevin > > -----Original Message----- > From: Teddy Payne [mailto:[EMAIL PROTECTED] > Sent: 13 October 2006 14:00 > To: CF-Talk > Subject: Re: CF5, Win2003 and SQL2005 > > > Kevin, > I suspect most of the issues that will occur will be the differences in > the > databases. > > Teddy > > On 10/13/06, Kevin Roche <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > One of my customers wante to move an old web site written using CF5 and > > SQL2000 running on Win 2000 to a new server running SQL 2005 and Win > 2003. > > What problems are likely if any? > > > > Kevin Roche > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256662 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4