# Best way to import data (not ddl) from Google Cloud SQL into Fly.io Postgres

**URL:** <https://community.fly.io/t/best-way-to-import-data-not-ddl-from-google-cloud-sql-into-fly-io-postgres/8432>\
**Category:** Questions / Help\
**Tags:** postgres, login-only\
**Created:** [November 3, 2022, 5:51pm UTC](https://community.fly.io/t/best-way-to-import-data-not-ddl-from-google-cloud-sql-into-fly-io-postgres/8432 "2022-11-03T17:51:22Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![lubien](https://sea1.discourse-cdn.com/fly1/user_avatar/community.fly.io/lubien/32/41919_2.png) [@lubien](https://community.fly.io/u/lubien)\
**Post date:** [November 3, 2022, 6:26pm UTC](https://community.fly.io/t/best-way-to-import-data-not-ddl-from-google-cloud-sql-into-fly-io-postgres/8432/2 "2022-11-03T18:26:29Z")

</div>

I think this post might help you:

> [@Transferring Postgres from Heroku](https://community.fly.io/t/transferring-postgres-from-heroku/6611/14):
>
> Wuhu tada it finally worked for me. Thank you so much @tj1 for leading me on the way. Here is a precise breakdown of what I did for it to work, with a lot of repetition from @tj1 's advice: Get your latest dump by running heroku login heroku pg:backups:capture heroku pg:backups:download In one terminal, launch: fly proxy 15432:5432 -a my-db-app-name # make sure it's the name of your db-app, not your main app In another terminal, list your db names to get the exact name of your DB with…

---

_[View the full topic](https://community.fly.io/t/best-way-to-import-data-not-ddl-from-google-cloud-sql-into-fly-io-postgres/8432)._