topic Re: replicate empty table structures from SQL Server to Snowflake in Talend Studio

replicate empty table structures from SQL Server to Snowflake

talendstar — Sat, 16 Nov 2024 07:06:35 GMT

I need to replicate a SQL Server database with a large number of tables to Snowflake using Talend.

However before I setup my Talend flows I need to create empty tables that mimic table structures in SQL Server.

Since I am working with a large number of tables - I am wondering if there is a way to replicate table structures easily?

I guess I can generate SQL Server scripts and modify them to be Snowflake compliant and get my empty database shell that way - however that will be super time consuming. Is there a fast and efficient way to accomplish this using Talend? or any other method that may be use here?

thanks

Re: replicate empty table structures from SQL Server to Snowflake

vapukov — Fri, 07 Dec 2018 01:36:18 GMT

I do not work with Snowflake regular (just a few tests), but the standard way - it is reverse engineer database into model, than re-engineer model to different source (logical model for example).

For my work I use dbSchema and VisualParadigm, both not know about SnowFlakes, but you could check articles how people work with Oracle SSDM:

https://www.snowflake.com/blog/customizing-oracle-sddm-to-support-snowflake-variant/

https://kentgraziano.com/2015/11/20/tech-tip-connect-to-snowflake-db-using-sqldevmodeler/

https://kentgraziano.com/2015/12/29/better-data-modeling-discovering-foreign-keys-fk-in-sqldevmodeler-sddm/