# Can I migrate data from Snowflake to On Prim SQL Server using DBT

**URL:** <https://discourse.getdbt.com/t/can-i-migrate-data-from-snowflake-to-on-prim-sql-server-using-dbt/3746>\
**Category:** Archive\
**Created:** [February 3, 2022, 9:15am UTC](https://discourse.getdbt.com/t/can-i-migrate-data-from-snowflake-to-on-prim-sql-server-using-dbt/3746 "2022-02-03T09:15:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![preeti.rai](https://avatars.discourse-cdn.com/v4/letter/p/0ea827/32.png) [@preeti.rai](https://discourse.getdbt.com/u/preeti.rai)\
**Post date:** [February 3, 2022, 9:15am UTC](https://discourse.getdbt.com/t/can-i-migrate-data-from-snowflake-to-on-prim-sql-server-using-dbt/3746/1 "2022-02-03T09:15:33Z")

</div>

Can I migrate data from Snowflake to On Prim SQL Server using DBT.

I want apply all my transformations on snowflake DB and once data is available in the final tables, I want the data to be migrated to SQL Server which is On Prem.

Any suggestions will be appreciated.

Best Regards, Preeti

---

<div class="post-metadata">

**Author:** ![emcp333](https://avatars.discourse-cdn.com/v4/letter/e/7cd45c/32.png) [@emcp333](https://discourse.getdbt.com/u/emcp333)\
**Post date:** [February 22, 2022, 9:38am UTC](https://discourse.getdbt.com/t/can-i-migrate-data-from-snowflake-to-on-prim-sql-server-using-dbt/3746/2 "2022-02-22T09:38:07Z")

</div>

have you seen projects like say … meltano or airbyte which deal with this sort of workflow? and Meltano includes DBT… DBT as I see it is just one step in your question… the transformation… but sourcing or moving of data … that is left up to things like apache airflow, airbyte, meltano, etc…