I have posted this question in the coding forum, I got no answers. I think I should post it here, it is more like a database question. Sorry for the double posts.

How difficult will it be to rewrite the php codes from php interbase/firebird to php mysql?

I am using php and interbase/firebird platform. I have clearly marked out the sql statements in my programming. If I need to transfer my codes to php and mysql. All I need to do is modifying the interbase sql codes to mysql sql codes. Right?

I have been setting up MySQL for the third party software and I have read the mysql maual. That is my current mysql experience.

How difficult it would be to modify Interbase sql codes to MySQL sql codes? I know some sqls are vendor's own statements. These have to be treated differently. Anyone can share his experiences, big picture and small details?

How difficult to transfer an interbase database structure to mysql database structure?

What cannot be transferred? What should I know in this transfer?

Any web sites, links, articles, pitfalls, your experience, anything regarding transfer from php interbase/firebird to php mysql?

Thanks!

    It really kinda depends on how many features of interbase you've used. If you're using constraints, stored procs, et. al. then you will have a bit of work ahead of you as you move all that work into PHP.

    If not, then it's probably pretty straightforward.

      I didn't use the stored procedure, constraints or sub-query. So I think the conversion should be easy.

      Anyone really did that? could you give me any advices based on your experiences, anything even small details?

        Sorry, all my conversions have been into Postgresql...

          2 years later

          Sxooter or anyone else has both expertism in InterBase(FireBird) and MySQL:

          I have been using InterBase(FireBird) for more than 4 years. My database is not very large. And it works perfectly.

          I don't have too much knowledge in MySQL. But from what I know, InterBase(FireBird) is easy to use, performance is good too. And InterBase(FireBird) has the stored procedures etc, which MySQL before 5.0 doesn't have.

          It seems InterBase(FireBird) is better than MySQL as a web site database, but the problem is not too many web hosting companies support InterBase(FireBird).

          Shoud I use MySQL instead of FireBird for the reason of the web hosting companies' supports? Would InterBase(FireBird) get attention from the web hosting companies in the near future? When Cobalt machine is popular, we can find InterBase support easily, but when Cobalt is out of the favor in web hosting, the InterBase support goes with it. It happens so quickly. I can find InterBaes support in town easily 2 yeas ago. Now it is difficult. Would that be changed again soon?

          1. Could any one comparing MySQL and FireBird as the web site back end database?

          2. What should I pay attention when I transfer my PHP/InterBase codes to PHP/MySQL codes? Any info regards this kind transfer is welcomed. (I didn't use stored procedure etc. in InterBase so I don't think that would be a problem for transferring to MySQL, but what else popular used in InterBase but not in MySQL I have to know?)

          3. What are the major difference points in terms of php programming I have to know when I php program for MySQL (as before I only program php for InterBase)?

          Thanks!

            Write a Reply...