Menu
Does Heroku support SQL Server? What should I write my SQL Server database connection string in order to make it run in Heroku?
<connectionStrings>
<add name="DatabaseConnection"
connectionString="Data Source=Hp\HpLaptop;Initial Catalog=PracticeDB;Integrated Security=true"
providerName="System.Data.SqlClient" />
</connectionStrings>
811
Heroku Postgres is a managed SQL database service provided directly by Heroku. You can access a Heroku Postgres database from any language with a PostgreSQL driver, including all languages officially supported by Heroku.
Heroku offers a free plan for hosting PostgreSQL databases. This can be handy if you're getting started with a new project or "just quickly need a hosted database" for experimentation or prototyping.
Heroku delivers the core open-source data projects that are widely adopted by developers— PostgreSQL, Redis, and Apache Kafka. Heroku data services are fully-configured, optimized, secure, and ready for production apps.
Heroku is agnostic about your choice of datastore but they do not offer SQL Server like they offer Postgres as an addon. If you've an external SQL Server database and the appropriate environment on Heroku then there is nothing stopping you from connecting to it.
To connect you would configure your adapter/driver in the same way you would traditionally for your framework of choice. Of course the credentials should be stored in the environment rather than committed to the repo.
102
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
