-
Ken Rosensteel presented Bull's PL/SQL-to-PL/pgSQL tool at PGEast last year. Now a free public demonstration version of this tool is available. The demo tool provides a wide range of translation possibilities (but not the full tool capabilities). The user just pastes in the PL/SQL Stored Procedure text itself for a quick translation, and then the user can evaluate the results.2 comments
You are welcome to try out the free demo tool at http://www.postgresmigrations. -
As mentioned in an earlier post, we're announcing the start of a PUG for Arizona. The first meeting will be Thursday, March 29, from 5 to 7 at Bull's facility in Northwest Phoenix. Refreshments will be provided.0 comments
You can join and get onto the mailing list and RSVP for the first meeting at https://www.bigtent.com/groups/azpug
We look forward to meeting other PostgreSQL lovers and to help grow the PostgreSQL community in our part of the world. -
11 comments
Why aren't more people/companies using PostgreSQL? Why aren't they moving from proprietary databases to PostgreSQL?
Possible answers: I haven't heard of PostgreSQL. I don't think PostgreSQL will meet my needs. I don't know how to get away from my database vendor.
I'd like to hear some of the reasons for not considering PostgreSQL when creating or migrating a database.
-
We want to set up a Postgres Users group in the Arizona/Southwest area. Are you interested? We're in metro Phoenix. Any local Postgres users out there?1 comment
-
0 comments
ISVs and PostgreSQL
We should be seeing all ISVs (Independent Software Vendors) migrating their products to PostgreSQL. Why? Because it's one of the fastest ways to increase their ROI and decrease their current customers' costs.
ISVs use a database in their product and typically require their customers to pay for the software license and support.
-
0 comments
Advantages of Migrating from a Proprietary Database to PostgreSQL
The obvious advantage of migrating from a proprietary database to PostgreSQL is the absence of a yearly licensing fee. Regardless of what you currently pay for your licensing, it's cheaper – i.e., zero dollars - to use PostgreSQL. Also, with multiple vendors to choose from, the Maintenance cost can be substantially lower.
-
1 comment
Why an open source database is good for business
Annual payments to the DBMS vendor shouldn’t make up the largest portion of your yearly IT expenditures. Your staff is trained, your applications run fine, now is the time to embrace the growing IT business trend and make use of “Open Source” software.
The Enterprise State of Open Source Today
Open source software has progressed significantly from the days when you had to roll-your-own, download it from a website, compile, and hope it worked.
-
0 comments
When considering a new database system or any new software system that will become a cornerstone of your IT, you have to ask ‘Who else uses this system and what do they think about the product’. This is especially true of an Open Source product. Because there is no vendor standing to make millions from the sale of the software, you will not see Super Bowl ads touting Free Software and there is no Marketing team providing glossy brochures. So how do you find the other major users of Open Source Software.
-
1 comment
This is one of a series of blogs related to the automated conversion of PL/SQL to PL/pgSQL.
One of the Oracle stored procedure conversion topics that we will be presenting at the PGEast conference in New York is that of CONNECT BY query translation. In this case the issue is mainly the SQL itself. In other blogs I will discuss solutions for more general topics like Oracle Packages and Global Variables.
See our presentation: Large Customers Want PostgreSQL Too !
https://www.
-
1 comment
We had an excellent attendance and a good discussion today at the PGEast Presentation
The presentation covered experiences with large customer database conversions we have recently completed and also described a new tool that was developed to convert Oracle Stored Procedures in the form of PL/SQL to PostgreSQL PL/pgSQL
The presentation is linked:
-
2 comments
When considering a database migration from Oracle to Postgres, one area that requires serious deliberation is that of translating Oracle’s PL/SQL source code to Postgres’ PL/pgSQL. It is a well documented fact that this translation can very challenging due to the proprietary nature of PL/SQL, and that the translation usually results in expensive recoding and extensive testing of the resulting procedures. It is also well understood that the functionality provided by PL/pgSQL and the semantics of the Postgres server do not necessarily behave in the same manner as the Oracle server and its PL/SQL, even in cases where the syntax is comparable.
Upcoming Events
Arizona PostgreSQL Users Group (AZPUG)
Latest Blog Entries
Bullion Server, the gold standard in Tier 1 virtualization
 |
 |
