Heroku Postgres vs Microsoft SQL Server

Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Heroku Postgres
Heroku Postgres

259
149
+ 1
37
Microsoft SQL Server
Microsoft SQL Server

3.8K
2.7K
+ 1
525
Add tool

Heroku Postgres vs Microsoft SQL Server: What are the differences?

Developers describe Heroku Postgres as "Heroku's Database-as-a-Service. Based on the most powerful open-source database, PostgreSQL". Heroku Postgres provides a SQL database-as-a-service that lets you focus on building your application instead of messing around with database management. On the other hand, Microsoft SQL Server is detailed as "A relational database management system developed by Microsoft". Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.

Heroku Postgres belongs to "PostgreSQL as a Service" category of the tech stack, while Microsoft SQL Server can be primarily classified under "Databases".

"Easy to setup" is the primary reason why developers consider Heroku Postgres over the competitors, whereas "Reliable and easy to use" was stated as the key factor in picking Microsoft SQL Server.

According to the StackShare community, Microsoft SQL Server has a broader approval, being mentioned in 470 company stacks & 425 developers stacks; compared to Heroku Postgres, which is listed in 74 company stacks and 38 developer stacks.

- No public GitHub repository available -
- No public GitHub repository available -

What is Heroku Postgres?

Heroku Postgres provides a SQL database-as-a-service that lets you focus on building your application instead of messing around with database management.

What is Microsoft SQL Server?

Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.
Get Advice Icon

Need advice about which tool to choose?Ask the StackShare community!

Why do developers choose Heroku Postgres?
Why do developers choose Microsoft SQL Server?

Sign up to add, upvote and see more prosMake informed product decisions

What companies use Heroku Postgres?
What companies use Microsoft SQL Server?

Sign up to get full access to all the companiesMake informed product decisions

What tools integrate with Heroku Postgres?
What tools integrate with Microsoft SQL Server?

Sign up to get full access to all the tool integrationsMake informed product decisions

What are some alternatives to Heroku Postgres and Microsoft SQL Server?
MongoDB
MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
ClearDB
ClearDB uses a combination of advanced replication techniques, advanced cluster technology, and layered web services to provide you with a MySQL database that is "smarter" than usual.
Heroku
Heroku is a cloud application platform – a new way of building and deploying web apps. Heroku lets app developers spend 100% of their time on their application code, not managing servers, deployment, ongoing operations, or scaling.
Google Cloud SQL
MySQL databases deployed in the cloud without a fuss. Google Cloud Platform provides you with powerful databases that run fast, don’t run out of space and give your application the redundant, reliable storage it needs.
Heroku Redis
Heroku Redis is an in-memory key-value data store, run by Heroku, that is provisioned and managed as an add-on. Heroku Redis is accessible from any language with a Redis driver, including all languages and frameworks supported by Heroku.
See all alternatives
Decisions about Heroku Postgres and Microsoft SQL Server
Amazon ElastiCache
Amazon ElastiCache
Amazon Elasticsearch Service
Amazon Elasticsearch Service
AWS Elastic Load Balancing (ELB)
AWS Elastic Load Balancing (ELB)
Memcached
Memcached
Redis
Redis
Python
Python
AWS Lambda
AWS Lambda
Amazon RDS
Amazon RDS
Microsoft SQL Server
Microsoft SQL Server
MariaDB
MariaDB
Amazon RDS for PostgreSQL
Amazon RDS for PostgreSQL
Rails
Rails
Ruby
Ruby
Heroku
Heroku
AWS Elastic Beanstalk
AWS Elastic Beanstalk

We initially started out with Heroku as our PaaS provider due to a desire to use it by our original developer for our Ruby on Rails application/website at the time. We were finding response times slow, it was painfully slow, sometimes taking 10 seconds to start loading the main page. Moving up to the next "compute" level was going to be very expensive.

We moved our site over to AWS Elastic Beanstalk , not only did response times on the site practically become instant, our cloud bill for the application was cut in half.

In database world we are currently using Amazon RDS for PostgreSQL also, we have both MariaDB and Microsoft SQL Server both hosted on Amazon RDS. The plan is to migrate to AWS Aurora Serverless for all 3 of those database systems.

Additional services we use for our public applications: AWS Lambda, Python, Redis, Memcached, AWS Elastic Load Balancing (ELB), Amazon Elasticsearch Service, Amazon ElastiCache

See more
Amazon RDS
Amazon RDS
Heroku Postgres
Heroku Postgres
Amazon RDS for PostgreSQL
Amazon RDS for PostgreSQL
Amazon EBS
Amazon EBS
PostgreSQL
PostgreSQL
Amazon EC2
Amazon EC2

I could spin up an Amazon EC2 instance and install PostgreSQL myself, review latest configuration best practices, sort Amazon EBS storage for data, set up a snapshot process etc.

Alternatively I could use Amazon RDS, Amazon RDS for PostgreSQL or Heroku Postgres and have most of that work handled for me, by a team of world experts...

See more
Interest over time
Reviews of Heroku Postgres and Microsoft SQL Server
No reviews found
How developers use Heroku Postgres and Microsoft SQL Server
Avatar of Brillium, Inc.
Brillium, Inc. uses Microsoft SQL ServerMicrosoft SQL Server

We've always counted on SQL Server as our database backend. It has served us well over the years. It isn't the cheapest part of our stack, but with the plethora of tools provided by 3rd parties, we have found an incredible and scalable method of keeping our data available and easy to maintain.

Avatar of Andrew Miller
Andrew Miller uses Microsoft SQL ServerMicrosoft SQL Server

Defacto, industry standard for backend relational databases. Entity Framework makes designing, migrating & maintaining SQL Server databases a breeze. LocalDB is especially helpful during development.

Avatar of David Flynn
David Flynn uses Microsoft SQL ServerMicrosoft SQL Server

Our core systems that we integrate with are using SQL Server 2012 / 2016 database servers. We use database views on core system databases to help build our domain model.

Avatar of PSESD
PSESD uses Heroku PostgresHeroku Postgres

Stores the admin database for the SRX apps - includes an audit log, error tracking, and SRX admin message log.

Will also store PRS rules when refactor is complete.

Avatar of Tim Lucas
Tim Lucas uses Heroku PostgresHeroku Postgres

Rock solid transactional storage of user, purchase and course activity data. During development database dumps were easy to create and download locally for testing.

Avatar of datapile
datapile uses Heroku PostgresHeroku Postgres

We use heroku PostgreSQL databases for testing alongside our sandboxed application(s) in heroku.

Extremely simple, practically a one-click setup.

Avatar of Olo
Olo uses Microsoft SQL ServerMicrosoft SQL Server

Main transactional database. SQL Server 2012 Enterprise with AlwaysOn Availability Groups for high availability and disaster recovery.

Avatar of Hunt Norment
Hunt Norment uses Heroku PostgresHeroku Postgres

4 years of experience using Heroku Postgres for data storage and management.

Avatar of Kyle Fretwell
Kyle Fretwell uses Heroku PostgresHeroku Postgres

Created several tables for users, brands, deals, campaigns, and tracking.

Avatar of Arbor Health, LLC
Arbor Health, LLC uses Microsoft SQL ServerMicrosoft SQL Server

Managing script output and input, as well as data cleansing.

How much does Heroku Postgres cost?
How much does Microsoft SQL Server cost?
Pricing unavailable
Pricing unavailable
News about Heroku Postgres
More news