I have a Mysql database.Please let me know if I can port bto Mysql database.
Ciro Guerra Lara
From what I've read on the postings it would be difficult because of certain features lacking in MySQL because of it's design approach.
PostreSQL is closer to Oracle on this design issues so it's easier to port to PostreSQL which is also open source and freely avaiable.
Joseph William Baker
I understand that MySQL now supports stored proceedures.
I'd much prefer MySQL over Postgress because of it's GPL license.
> I'd much prefer MySQL over Postgress because of it's GPL license.
What would be the problem with the BSD license in PostgreSQL?
> I have a Mysql database.Please let me know if I can port bto Mysql database.
If you ask this way, chances are you can't.
If you're looking to a strong DBMS on GPL license, I advise you to have a look on SAP DB : http://www.sapdb.org
It looks to be a really powerful DBMS. I'm using it for testing J2EE Servers (JOnAs and JBoss) and I can tell you it's a good DBMS (for my use) :
- easy installation
- transaction management supported
- runs as well on Windows, Unix, Linux... (contrary to PostgreSQL)
- under GPL license (expect for the interfaces under LGPL)
- I've read can manage BLOB (Long Binary) and CLOB (Long ASCII)
You should have a look.
What is so great about the GPL license. The freebsd license which postgres is licensed under gives you considerably more rights.