All geek questions in one place

Visual Studio SSDT Data Compare How to Compare Two Tables in the Same Database

Trying to do something simple comparing data in SSDT, but a bit tricky.

In one database, I have two tables that I want to compare.

These tables have the same schema, only different table names. And I just want this tool to give me a good way to compare data in both.

those.

tblOutput
tblOutput_210314

But this choice of two tables for comparison with each other in the same database, I do not see how to do it.

It looks like you can only select the name of the table that exists in both the source and target databases. Since the source and target database are the same, am I mostly comparing my table with myself?

Does anyone know a way to achieve this using Data Compare?

  • Visual studio 2012
  • SQL Server Data Tools
+4
2

. , , , Data Compare. :

. , :

  • , .
  • , .
  • , .
  • .
  • , .
+4

. , . .

CoffeeTableBooksDatabase , table_myBooks table_aFriendsBooks , .

, :

  • (: CoffeeTableBooksDatabase)
  • (: AnotherCoffeeTableBooksDatabase)

:

  • (: view_SomeBooks)
  • (, CoffeeTableBooksDatabase) (: table_myBooks) (: view_SomeBooks) , (: ).
  • (: AnotherCoffeeTableBooksDatabase) (: table_aFriendsBooks) (: view_SomeBooks) , (: ).

, . , .

+1

Source: https://habr.com/ru/post/1530393/

More articles:


All Articles