Re: Need advise on migrating from mSQL/MySQL...

From: "Brian Tully" <btully@bestweb.net> > >Hi there. I've been asked to look into migrating several of our websites >from a mSQL backend (UNIX/Apache/Perl) to Informix Foundation.2000. While >I'm far from an expert on mSQL, I was hoping some of you might have >experienced such a transition and could offer some advice on what to >expect. >I'm leaning towards a MySQL solution but there's a possibility that we >could >get a very good deal on the Foundation.2000 licensing - thus the pressure >is >on me to come up with an "informed decision". I've gleaned as much info as >possible from Informix' website, but I'm still uncertain as to how >difficult >a switchover it's going to be (considering I have nil experience with >Informix db's). Well, if you're just going to use Informix as a repository and leave the front end alone, I can only imagine you may have some minor SQL incompatabilities (probably at the same level as the differences between MySQL and mSQL) There is quite a bit of administration involved in keeping IDS going. But the upside is that IIF will allow you to go places MySQL could never take you. You have to weigh up the cost of the admin against the (relatively) unlimited opportunities that IIF 2000 will offer you with the extensible database and the built-in JVM. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com