EDB Postgres Advanced Server vs Microsoft SQL Server

• PPAS Oracle compatibility, especially the PL/SQL syntax, has made migrating database-tier code very simple. Most Oracle packages do not need to be changed at all and those that do are generally for simple reasons like a reserved word in PPAS that is allowed in Oracle.
• PPAS xDB, the multi-master replication tool, is simple and - most important - does not break with network or other interruptions. We have been able to configure and forget, which our customers could never do with other multi-master tools.
• Most people had no idea that PPAS and PostgreSQL have full CRUD support for JSON. They think you need a specialized product and/or that JSON is read-only. Every organization that I have worked with is evaluating adding JSON to their relational model.

Read full review

• Good range of data types helps us store lots of diverse data
• Easy administration helps us control who has access and what they can do with the data
• Backup and restore processes are easy to manage and provide good security
• Data can be easily replicated from Server to Server for use in other countries

Read full review

• Documentation is excellent but spread out across many resources and can take a while to wade through—would benefit from having more intro level, getting started guides for various languages.
• Ruby support is excellent but more Ruby examples and beginner-level documentation would be nice.
• It is sometimes hard to find a community of users on StackOverflow so a larger community, and a dedicated forum with active members to answer questions and work through issues would be nice.

Read full review

• Enterprise is unbelievably expensive.
• Not tolerant of bad practices and poor query writing, really shows up when you do it badly!
• Deep insight into what is happening with query performance is not especially great (but as mentioned in the "Pros", software support from third parties does cover this).

Read full review

• Postgres Plus Advanced Server is quite complex and may take longer to implement certain things than simply using PostgreSQL depending on developer familiarity with the platform.
• Getting up to speed can be daunting so again, there is an upfront cost in time spent learning the platform, besides the potential for extra time spent on a feature-by-feature basis.
• The cost of Postgres Plus Advanced Server should be weighed against simply using PostgreSQL to decide which is the best solution for your business needs.

Read full review

• With just one server we can easily host databases for many applications, which makes it easier to maintain.
• The ROI on Microsoft SQL Server is very good as we have been able to set it and forget with out too much time invested in keeping it up and running.
• The Microsoft SQL Server down time has been minimal and 90% of the downtime is due to our user error.

Read full review