-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 10/16/12 6:54 AM, Baskar Bharadwaj J wrote: > This is to understand the database support in the lastest version. > Postgresql is the default database. Since OpenNMS uses hibernate, > it should ideally be easy to support multiple databases (MS Sql, > Oracle). Though, would like to check with everyone on how easy it > is to move to other database. i.e., What may required to be > migrated? Any succesful efforts in this area in the past? any > bottlenecks? rough indication of complexity/time required?
The hard part would be reimplementing the Pl/PgSQL stored procedures we require, as well as fixing any postgresql-specific dialect problems. Plus a few places (in the installer and such) that we check for PostgreSQL-specific things. My guess would be it's still another 4 or 5 man-months to make it all work properly (which is why we haven't gotten there yet... Especially since there isn't a strong need to move off PostgreSQL, it's a great and powerful OZ^H^Hdatabase.) - -- Benjamin Reed The OpenNMS Group http://www.opennms.org/ -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.17 (Darwin) Comment: Using GnuPG with Mozilla - http://www.enigmail.net/ iD8DBQFQfVBDUu+jZtP2Zf4RAgaYAJ4+Rd9lgrA9NBMCV3mIEThL+7Hy1QCdEupC ywvlciwAgMkeKkcZcLBueh0= =wVCd -----END PGP SIGNATURE----- ------------------------------------------------------------------------------ Don't let slow site performance ruin your business. Deploy New Relic APM Deploy New Relic app performance management and know exactly what is happening inside your Ruby, Python, PHP, Java, and .NET app Try New Relic at no cost today and get our sweet Data Nerd shirt too! http://p.sf.net/sfu/newrelic-dev2dev _______________________________________________ Please read the OpenNMS Mailing List FAQ: http://www.opennms.org/index.php/Mailing_List_FAQ opennms-devel mailing list To *unsubscribe* or change your subscription options, see the bottom of this page: https://lists.sourceforge.net/lists/listinfo/opennms-devel
