Heroku Postgresql to MS sql

Question

Post reply

Heroku Postgresql to MS sql

dopydb

SSCertifiable

Points: 6687
More actions
August 29, 2019 at 4:27 pm

#3675504

hi
just doing some initial research on the possibility of extracting postgresql data hosted on heroku to a local MS sql instance.
has anyone done so using SSIS or any other tool? is it something that can work well?

mal

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80330 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Eddie Wuerch SSChampion Points: 12535 More actions · Answer 2

You can connect to Heroku PostGres from an external client: "...except for private and shield tier databases, they are accessible from anywhere and may be used from any application using standard Postgres clients"

https://devcenter.heroku.com/articles/connecting-to-heroku-postgres-databases-from-outside-of-heroku

You may need a PostGres driver on the SSIS machine, but it looks doable from the docs.

Eddie Wuerch
MCM: SQL

dopydb SSCertifiable Points: 6687 More actions · Answer 3

thanks Eddie, pretty sure it will be fine with some work, just wanted to hear if the community had good/bad experiences