Can I throw out a suggestion? Consider a trigger on the database that updates a new record and changes it's timestamp when it's inserted or updated? Then you don't need to migrate.
andy -----Original Message----- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: Thursday, July 29, 2010 2:52 PM To: cf-talk Subject: Re: Need a west coast (US) based CF host Nothing against Railo. My main project right now is a Railo site (altho we're keeping it CF9 compatible) with a mySQL database. Works a treat. I just don't know this other site well enough to be able to say, "yeah, let's jump over to Railo and convert your MS SQL database to mySQL" :) There's also a flex-based admin area and I'm not sure how well that would work. At this point in time... probably not something that the client would want to undertake (all of the UAT that would be necessary to ensure that all facets of the site still function properly). They're a small non-profit and I don't think they have the manpower to even do that, nor do I think they'd want to pay me to take that on. Appreciate the feedback tho. I'd heard Alurium's name mentioned before. Their prices do look appealing. Just not a good fit for this particular client right now :\ On Thu, Jul 29, 2010 at 12:40 PM, Scott Stewart <webmas...@sstwebworks.com>wrote: > > Charlie, I think they are exclusively MySQL... I ported over an > implementation of blogCFM and it works fine, Railo's pretty complete > as far as tag support goes.. > > On Thu, Jul 29, 2010 at 3:29 PM, Charlie Griefer > <charlie.grie...@gmail.com> wrote: > > > > Hey Scott: > > > > Hmm... not sure that the current site will run under Railo. Also, > > their current database is SQL Server (I probably should have mentioned that). > > Looks like Alurium is exclusively Railo/mySQL (?) > > > > Thanks, > > Charlie > > > > On Thu, Jul 29, 2010 at 12:12 PM, Scott Stewart > > <webmas...@sstwebworks.com>wrote: > > > >> > >> Charlie, > >> > >> I think Alurium is located on the West Coast, plus they're cheap > >> and you can run CFML (Railo) http://www.alurium.com > >> > >> On Thu, Jul 29, 2010 at 3:09 PM, Charlie Griefer > >> <charlie.grie...@gmail.com> wrote: > >> > > >> > Hey all... > >> > > >> > I know this topic ("can somebody recommend a CF host") comes up > >> > frequently... I hate to bring it up again, but I must :) > >> > > >> > I have a client that needs to be on shared hosting (they don't > >> > have > the > >> > funds for VPS, unfortunately) on a server with the clock set to PST. > >> > They're a company that's physically based in CA... recently > >> > moved > hosts > >> to > >> > an east-coast based company, and now timestamps are off by 3 > >> > hours > when > >> they > >> > add events. > >> > > >> > According to the previous developer, they're using a calendaring > system > >> > (specifically, a particular version of a calendaring system) that > isn't > >> set > >> > up to handle time zone differences. He's told me that trying to > update > >> the > >> > code to handle this would "open a whole new can of worms". > >> > > >> > I've explored the options, and the path of least resistance seems > >> > to > be > >> to > >> > relocate the site to a server based on the west coast. Or at the > >> > very least, a server whose clock is set to PST. > >> > > >> > A quick google turned up Illuminated Hosting ( > >> > http://www.illuminatedhosting.com/), but I'm not familiar with them. > >> Does > >> > anybody know of this company? Or of any others that have servers > >> > set > to > >> > pacific time? > >> > > >> > Thanks! > >> > Charlie > >> > > >> > -- > >> > Charlie Griefer > >> > http://charlie.griefer.com/ > >> > > >> > I have failed as much as I have succeeded. But I love my life. I > >> > love > my > >> > wife. And I wish you my kind of success. > >> > > >> > > >> > > >> > >> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335869 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
