You can use the SQL Server Data Tools (SSDT) to create and modify snowflake schema in a graphical interface. SSDT also provides features such as schema compare, data compare, and code analysis to ...

Creating a new SQL Server Database Project. Importing a database schema from various sources such as an existing database, a .sql script file, or a Data-tier application (.bacpac) into the project.