Coming in a couple of months late here, but I've just been through a move from Windows/Adobe CF/MS SQL Server to Linux/Railo/MySQL and found a couple of things not previously mentioned.
Windows -> Linux: already covered above, but I'll just add that anything that turns into a file name (like CFC paths) is also included in the case-sensitivity issue. One issue that hit me was case inconsistency in strings stored in the database that were later used to build path names. AdobeCF -> Railo: Even aside from the unsupported tags, syntax compatibility although very good is not 100%. See e.g. http://lagod.id.au/blog/?p=378. A lot of this will come down to coding style - your code might be completely fine. The big thing for me though is the way Apache and Tomcat work together. ACF goes to some lengths to disappear the Tomcat layer and make the whole thing look like a web server that miraculously knows what to do with cfm files. Railo is much more of a classic Tomcat app, in that it is definitely sitting behind the web server with its own separate configuration. I can go into more detail about the consequences of that if you like, but if you take the path of least resistance (use mod_cfml and make the Apache document root the same as the Tomcat context root) then at the very least you end up with a dirty big WEB-INF folder in your document root. MSSQL -> MySQL: CRUD queries will almost certainly be fine. Heavy-weight slicing and dicing queries probably won't. There are lots of differences in DDL (I have a very home-brewed set of regexes that did the trick for me - happy to share). Stored procedures will need to be completely rewritten. Many functions are different, but most have direct equivalents. One gotcha is that when MySQL is running on Linux, database object names (e.g. table names) are case sensitive. That sounds like a lot, but it is perfectly feasible to have one codebase that will deploy and run happily in both environments (that might not be a requirement for you, but it does illustrate that the differences are not major). My total changeover time was about six weeks, but I was completely reworking my build and provisioning procedures at the same time. Feel free to ping me on or off list if you want any more detail on any of this. Jaime On Sat, Mar 29, 2014 at 1:31 PM, Mike K <afpwebwo...@gmail.com> wrote: > > Thank you everybody, I'm glad I asked. I have changed my plan now. > Cameron and others made a good point. I was trying to do too many > thing at once. My plan now is to get a new hosting environment as > similar as possible to my current one, so its gives me the most chance that > I'll be able to just copy everything over and most of it will work as is. > Then work from there on the transition to Linux or the cloud and Railo in > two more steps. > > Thanks to a suggestion from another member of this list off-list I'm not > going with the cloud just yet, I'll go with a VPS at Viviotech and work > from there. So far every question I've asked they have said "yes we can > do that all you do is .... " > > Once again this group helps me out. In this case, I can see if I had gone > with my original plan, it MIGHT have worked out ok, but with my luck the > odds were that it would give me a lot of grief before it was all said and > done. Thank you all > > I'll let you know how it all turns out. > > > Cheers > Mike Kear > > > > On Sat, Mar 29, 2014 at 2:12 AM, Money Pit <websitema...@gmail.com> wrote: > > > > > Having been there/done that myself, I would follow Cameron's described > > route. You don't want to be debugging so many different issues at once > on > > an OS you aren't intimately familiar with (and maybe not familiar at > all). > > You mentioned you are on Win2003. Have you by chance missed out on > running > > CF on a 64-bit Win OS? That was like manna from heaven when I first > > switched. > > > > Consider a Windows VPS from Viviotech. They can license you a copy of CF > > Enterprise *very* inexpensively. They are surprisingly robust for the > > prices charged, they are CF-literate and an excellent firm on general > > principles. From there consider leasing another Windows VPS and put > Railo > > on it (Viviotech will do this for you for a small setup fee or for free > > IIRC). Then tinker away, migrate a low-profile site over when you're > ready > > etc. This is what I did with my personal sites. You could take it a > step > > further and after mastering Railo, retire the Windows/Railo VPS, fire up > > one with linux and start over again on the tinkering so you limit your > > issues to that part of the change. > > > > If you need more horsepower and have the budget for a CF license, look at > > the blade servers at Cybercon; check out their hardware configs. I don't > > see how you can beat those prices. My servers there have been absolutely > > reliable. > > > > -- > > --m@Robertson-- > > Janitor, The Robertson Team > > mysecretbase.com > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358701 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
