Heroku Postgresql to MS sql

  • dopydb

    SSCertifiable

    Points: 6634

    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

    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

    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

    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