August 29, 2019 at 4:27 pm
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
August 30, 2019 at 5:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
September 1, 2019 at 12:54 am
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
September 2, 2019 at 1:50 pm
thanks Eddie, pretty sure it will be fine with some work, just wanted to hear if the community had good/bad experiences
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy