Heroku Postgresql to MS sql

• dopydb

  SSCertifiable

  Points: 6634

  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

• Site Owners

  SSC Guru

  Points: 80385

  August 30, 2019 at 5:10 pm

  #3675801

  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: 12265

  September 1, 2019 at 12:54 am

  #3676102

  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: 6634

  September 2, 2019 at 1:50 pm

  #3676341

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