Data Compare automation table list
It would be nice to save data comparisons (in a definition file, etc) or pass in which tables to compare via command line / command utility. When comparing data in larger databases (say, 500+ tables) and I want to compare only a subset of tables (say, 50-100) the interface requires manually selecting only the desired tables. It would be nice to automate this task.
Thanks for taking the time to share this suggestion. This item has been around for a couple of versions of Visual Studio and we haven’t acted on it. Looking at the VS “15” plans, we’re not going to take action on this item, so we’re going to close it. If the suggestion is still relevant, please either take a look to see if there’s another suggestion that’s similar that you can vote on, or open a new suggestion.
- The Visual Studio Team
Hi guys! I want to know is it possible to save * .dcmp and open it when we want?
Is it possible to execute this file with command?
I could not work with Command Window:
Command "Sql.NewDataComparison" is not valid
Hello, guys, I want to know if it is possible for the * .dcmp project file to save the configuration of the tables you select the first time, for a data comparison. This is in Visual Studio 2013, or if VS 2015 already exists.
Tim Sneath [MS] commented
Hi Cristian, this idea is actually in the wrong place (extensions), so I don't think the right team is looking at it. Moving it to the database projects node where the right people may be able to help out. Thanks, Tim Sneath | Visual Studio Team
Cristian Vasile commented
Has anything changed on this?
I also need it, the same reasons....
Yes. To do a Data Compare between two databases, in order to generate a script to update a target database, we need to select tables to compare and columns for each tables. For example, we need to exclude the following columns : RowVersion, creation and modification dates, calculated columns, ..., all columns specific to a environment. In a big database with a lot of tables, it is impossible to do that manually each time we need to deliver a new version.
So we really need to be able to save the settings of a data compare to run it again later. And, we need to execute the data comparison in console mode, to automatize it for a continue integration or for an industrial deployment.