Comparison Data and Objects

In this article we cover some code that we can use to make database schemas match by comparing the objects in the databases.

I need to programmatically compare SQL Server tables, columns, indexes and constraints between databases to determine what is the same, differences and additions. How can this be accomplished?

In this article we look at a way to compare database schemas between two different databases using C# and JSON.

Using sys.sql_expression_dependencies DMV to find SQL Server object dependencies.

In a previous tip we have shared scripts that could be useful for finding SQL Server object dependencies during your application development or database upgrades. The scripts did not include checks for synonyms dependencies. How can we check SQL Server sy

Learn how to perform SQL Server database schema synchronization via SQLPackage.exe with PowerShell for stored procedures, views, functions and more.

There is often a need to determine if two tables have the same structure and data in the tables. Read this tip to learn how to do this quickly with PowerShell.

There are a lot of resources available about system objects that will display object dependencies. There are also great examples of how you can use it. In this tip we will share a couple of useful scripts that you can use for your application development

This article shows different ways to compare SQL Server data, datatypes and tables using TSQL and some development tools.

In my last tip SQL Schema Comparison with Visual Studio 2010, I showed how to compare schema objects, synchronize them or get incremental deployment scripts. This is good way to synchronize the schema objects between two different environments, but we a

Often we need to compare databases across two different environments (or even sometimes in the same environment) to identify the schema object differences, so that one database can be brought in sync with another one. For example, we normally do developme

Learn how to sort and compare SQL Server unicode and binary data results.

In this article we look at different ways to determine if one SQL Server database object is dependent on another database object.

One problem that DBAs often face is maintaining lookups tables across multiple servers or sites. These tables could either be replicated or manually updated, but in any case sometimes the data in these tables get out of synch. In a previous tip we talke