Re: DB & MDB2 Portability
| From: | Paul Scott | Date: | Fri, 03 Mar 2006 05:29:35 +0000 |
| Subject: | Re: DB & MDB2 Portability | ||
| References: | 1 2 3 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-23213@lists.php.net to get a copy of this message | ||
On Thu, 2006-03-02 at 09:30 +0100, Lukas Smith wrote:
>
> http://cvs.php.net/viewcvs.cgi/*checkout*/pear/MDB2/docs/datatypes.html
>
Thank you very much. The docs and examples in CVS seem to be a little
more comprehensive. Appreciate the link.
> MDB2 does require that you use the appropriate datatypes inside the
> RDBMS in order to do the mapping reliably. If you really care about
> portability the best thing to do is to use MDB2_Schema to reverse
> engineer your current schema into the MDB2 xml schema format. Then you
> can recreate your database using compatible datatypes.
>
OK, MDB2_Schema seems like the way to go then. I will take a look and
see what I can come up with.
I will also try and document my experiences as thoroughly as possible,
so that the next user can benefit from this too. As I mentioned earlier,
I am porting from PHP4+Pear DB to PHP5.1 + MDB2, so I am bound to run
into some issues that someone else may benefit from too.
I appreciate the help! Great work on the package BTW, its going to take
me a while to get into all the cool features!
--Paul