<ul data-eligibleForWebStory="true"><li>A new feature in preview for SQL Server 2025 is the 'schema compare' in the Visual Code extension.</li><li>The feature allows comparing schemas between two databases to ensure alignment.</li><li>The user creates two identical databases 'db1' and 'db2' with tables and data.</li><li>After running a schema compare, no differences were found between the databases.</li><li>Changes are made to 'db1', including adding a column, dropping a column, changing a column's data type, creating a new schema, and table.</li><li>Running the schema compare again shows the schema changes made.</li><li>The comparison results indicate that a table will be deleted and recreated instead of a straightforward schema transfer.</li><li>The process is repeated with 'db2' as the source and 'db1' as the target to revert the changes effectively.</li><li>Using the 'Switch Direction' option in schema compare helps in managing changes from both databases effectively.</li><li>The script generation feature provides a script reflecting the changes made during the comparison.</li><li>Caution is advised when applying changes to production databases based on the generated script.</li></ul>

SQL Server 2025: Local SQL Server Container – Schema compare preview

Discover more