replicate empty table structures from SQL Server to Snowflake

Highlighted
Four Stars

replicate empty table structures from SQL Server to Snowflake

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

Thirteen Stars

Re: replicate empty table structures from SQL Server to Snowflake

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-sqldevmodele...

 

-----------