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?
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:
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.