I've done this on 5 projects, now. The three things that bit me repeatedly:
Boolean types in Access were not the same in mySQL. Went with int (1/0). Filenames are case sensative all of a sudden. We thought we had followed good naming conventions. We had, but not perfectly! Most significant were image files and rollovers. Moving the dbs was interesting, making sure the dbs were ported in the correct order. (constraints forced the proper sequence) But it really wasn't very difficult. Jerry Johnson >>> [EMAIL PROTECTED] 05/21/02 08:33AM >>> Hi fellows, i looking for some advice on migrating websites of one of my customers from windows to linux. The customers has it's own CF4.5Pro-Server and 'cause he switched his entire office to linux he's also chenging the webserver to linux with apache. The nice thing is, that is will purchase/update to CF5 or MX. Now my question is will the applications i wrote under Windows+Access run under Linux+MySQL without bigger problems??? i have a event-calendar-app which will probably make no trouble. but i have a little shopping-cart-like app with session-vars and a full-text-search with verity. So if anyone can share experience i would be really glad for any input! TIA -- Patric Stumpe mailto:[EMAIL PROTECTED] ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
