August 29, 2019 at 4:27 pm
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?
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"
You may need a PostGres driver on the SSIS machine, but it looks doable from the docs.
Eddie WuerchMCM: 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