Gilson,
I just completed a conversion from NT/MSSQL to Linux/MySql. Couple of
things to note:
1. As Steve said, filenames are now case sensitive.
2. CustomTags are searched-for in the same manner as under Windows -- under
Linux, it MUST be in the CUSTOMTAGS directory.
3. The MySQL ODBC Driver (by Merant) that ships with CF does NOT SUPPORT
TRANSACTIONS. Therefore, using CFTRANSACTION will cause an exception.
4. In MySQL, table names are case sensitive, but everything else is not.
5. I used @@IDENTIY values in MSSQL, so had to convert those to AUTO
INCREMENT values in MySQL.
6. CFINSERT and CFUPDATE do not appear to work with MySQL.
I think those are about the biggest GOTCHAS I have found so far. Now, I'm
off to stress testing!
-Dustin
>
> Date: Fri, 29 Dec 2000 00:22:29 -0200
> From: Gilson Soares <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Re: Porting from Win2K to Linux
> Message-ID: <[EMAIL PROTECTED]>
>
> Thanks Steve.
> I will start the port next week. I will try to record all issues and tell
> you the results.
>
> Happy New Millenium.
>
> At 28/12/2000 11:47 -0500, you wrote:
> >Be careful of your case sensitivity with filenames dealing with
> >cfinclude/cfmodule, custom tags, Application.cfm and OnRequestEnd.cfm.
> >Also at the web server level with image case sensitivity. If you're
> >using Apache, you can try the mod_speling to solve the problem with the
> >images. The .cfm's you have to do check by hand.
> >
> >I'm not sure about the DB2 port, but I imagine that should move over
> >just fine.
> >
> >Steve Nelson
> >http://www.SecretAgents.com
> >Tools for Fusebox Developers
> >(804) 825-6093
> >
> >
> >Gilson Soares wrote:
> > >
> > > Hi everybody,
> > >
> > > I have a ColdFusion application (around 260 CFM in Fusebox)
> running ok with
> > > DB2 on win2k (I personally prefer Linux).
> > > It's time to deploy it. I just received a server box to try running it
> > > under Linux, ie CF-Linux and DB2-Linux.
> > >
> > > Has anyone made this migration before (even not using DB2) ?
> > > Has any cautions that I am be aware off?
> > >
> > > PS: All Custom Tags I use are strictly CFM. No objects, OCX, C++, etc.
> > >
> > > Thanks
> > > Gilson Soares
> > >
> > >
> >
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Structure your ColdFusion code with Fusebox. Get the official
> book at http://www.fusionauthority.com/bkinfo.cfm
>
> ------------------------------
>
> End of CF-Linux-List V1 #25
> ***************************
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_linux or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
. [EMAIL PROTECTED] with 'unsubscribe' in the body. .
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
