Sql Server Data Tools -

SQL Server Integration Services (SSIS): For ETL and data movement.

Business Intelligence (BI) ToolsSSDT replaced the old Business Intelligence Development Studio (BIDS). It provides the designers and project templates for: sql server data tools

SSDT is for Development: Use it for building new features, version controlling schema changes, and CI/CD automation. It is a "code" tool for Developers. Conclusion SQL Server Integration Services (SSIS): For ETL and

The fix? They learned that for large tables with a NOT NULL column and a default, SSDT’s “smart” offline deployment strategy (which avoids online ALTER operations that could lock the table for hours) backfires. They had to change the deployment settings: disable the “allow offline deployments” or explicitly tell SSDT to use an online ALTER TABLE ADD WITH VALUES command. It is a "code" tool for Developers

After an hour of panic, the senior DBA looked at the actual script SSDT generated for that specific environment. Because the staging table already had 50 million rows, SSDT didn’t just add the column with a default—it created a new temporary table with the new schema, inserted all 50 million rows into it (leaving the new column as NULL because the default was applied at table creation, not during the bulk insert), renamed the tables, and swapped them. The default constraint was there, but the insert operation into the temp table never invoked it. The column was NULL for every existing row, violating the NOT NULL constraint.

Unlike traditional scripting where you write CREATE TABLE or ALTER TABLE scripts, SSDT allows you to simply define you want your database to look like. You create a "state" of the database in your code.

One Friday afternoon, a junior developer was tasked with a seemingly simple change: add a new NOT NULL column to a fact table called FactTransactions . Following standard practice, she opened the SSDT project, added the column to the table definition, and hit “Publish.” SSDT helpfully generated the deployment script, showing a standard ALTER TABLE ADD command. She deployed to the development environment—no issues. Then to QA—fine.