SqlDataCompare file - how to save?

Roberto Ortega 6 Reputation points
2020-11-20T22:52:41.757+00:00

When I choose "New Data Comparison..." from the Tools/SQL menu, the resulting "file" is named "SqlDataCompare1" in the title of the window.

It takes a while to specify exactly which tables and columns I want to compare, and which index each should use, and I want to save that setup!

However, I can find no way to save this file!

Is there a way to save a SQL Data Comparison in SSDT for Visual Studio 2019? I see this has been forthcoming for 7 years.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,583 questions
{count} votes