Thanks for the details. Have you considered dping a blog post detailing the process
Russ Michaels www.michaels.me.uk cfmldeveloper.com cflive.net cfsearch.com On 29 May 2014 07:13, "Jaime Metcher" <jmetc...@gmail.com> wrote: > > 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:358702 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm