Stack Overflow
Stack Overflow

Questions tagged [data-comparison]

74 questions
10
votes
1 answer

mySQL select differences between two tables in different databases

I have two databases: old and new. Both have a comments table. There are 100 comments in the old table that are not in the new. Comments have been added to the new table and there is a conflict in IDs so querying by ID will not be an option. I need…
Jason Yost
  • 4,807
  • 7
  • 42
  • 65
9
votes
1 answer

Visual Studio 2017 Data Comparison, command line

I'm using this function in Visual Studio to easily sync data from one database to another https://msdn.microsoft.com/en-us/library/aa833428(v=vs.100).aspx You can save the Data Compare settings into a .dcmp file. Everytime I open the .dcmp file, it…
Jack
  • 5,680
  • 10
  • 49
  • 74
8
votes
3 answers

Visual Studio SSDT Data Compare how to compare two tables in a single database

Trying to do something simple Data Compare in SSDT but proving a bit hard. In one database, I have two tables I want to compare. These tables have the same schema, just different table names. And I just want to see if this tool will give me a nice…
StevieB
  • 6,263
  • 38
  • 108
  • 193
7
votes
2 answers

How do I compare two nested data structures for unittesting?

For those who know perl, I'm looking for something similar to Test::Deep::is_deeply() in Python. In Python's unittest I can conveniently compare nested data structures already, if I expect them to be equal: self.assertEqual(os.walk('some_path'), …
cfi
  • 10,915
  • 8
  • 57
  • 103
6
votes
1 answer

Visual Studio Data Comparison with less columns

My project currently has a database which contains several tables, the most important of which has one binary column with very large entries (representing serialized C# objects). There are a large number of entries in the production database, and…
Dan McElroy
  • 426
  • 4
  • 19
5
votes
2 answers

Can you ignore columns when doing a SSDT data compare?

I frequently use the SSDT data comparison tool to sync up database data from our integration environment to our production environment. However, I typically run into scenarios where columns should be ignored and never synced up. Even if I review…
charlie
  • 4,612
  • 1
  • 22
  • 18
4
votes
0 answers

Can I compare the contents of two databases in Azure Data Studio?

I have two databases and I want to do a data comparison between the two. In SSDT this can easily be achieved using the Data Compare feature, but I'm trying to move to using Azure Data Studio. I can see there's a schema comparison extension in Data…
Roo
  • 55
  • 1
  • 7
4
votes
2 answers

SQL Server query with same functionality as Excel VLookup

I have 2 columns of data that I need to compare with each other - Column A and Column B. Column A: Steve Jane Mary Peter Ed Scott Ted Column B: Peter Scott David Nancy Column A has a larger amount of data than column B. But it may not have all…
slayernoah
  • 4,382
  • 11
  • 42
  • 73
3
votes
0 answers

Ignore dependencies in Visual Studio SQL Schema Compare

Is it possible to ignore the auto-selecting of dependencies in Visual Studio SQL Schema Compare? It's doing more harm than good - if I want to select a change in stored procedure with dependencies, it auto-selects the dependencies even if the…
Kajbo
  • 1,068
  • 3
  • 16
  • 31
3
votes
1 answer

How to export result of SQL server - "New Data Comparison" to an Excel file?

I am using Visual Studio 2017. Functionality - Open Visual Studio - Go to Tools - Click SQL Server - New Data Comparison After mentioning source and target database and running the tool, I get results - (Different Records, Identical…
hvirdi
  • 31
  • 1
  • 6
3
votes
2 answers

SSIS with millions of data to compare from source and target

I am trying to learn about SSIS and have few doubts regarding to that. I have want to compare 2 tables.1 table is in Sql Server and another is in Oracle. Both table will have same schema like below : Sql Server: Id Amount 1 100 2 …
I Love Stackoverflow
  • 6,738
  • 20
  • 97
  • 216
3
votes
3 answers

Ruby - Show Deltas Between 2 array of hashes based on subset of hash keys

I'm attempting to compare two arrays of hashes with very similar hash structure (identical and always-present keys) and return the deltas between the two--specifically, I'd like to capture the folllowing: Hashes part of array1 that do not exist in…
Kurt W
  • 321
  • 2
  • 15
3
votes
6 answers

Is there a free (or very cheap) tool for highlighting changes in data for sql server?

Note for bounty: please answer only if you know a tool that can monitor what changes in the same db, don't mention tools that compare 2 dbs. A visual tool, like Embarcadero Change Manager is appreciated. I'd like to have a tool that allows me to see…
UnDiUdin
  • 14,924
  • 39
  • 151
  • 249
3
votes
0 answers

Visual Studio Data Compare Bug when syncing 'Microsoft.SqlServer.Types.SqlGeography' types

An error is raised when attempting to run a script generated by Visual Studio's data compare tool. I could not find a solution though Google search. This happens on all dev machines I have attempted it on in the office. I am executing it from…
Microsoft Developer
  • 1,919
  • 1
  • 20
  • 27
2
votes
1 answer

How to create a DataTable that contains the comparaison result of two DataTables having the same structure?

This question has already been asked several times on Stack Overflow, but before marking it as a duplicate, please have a look at my issue. I am trying to compare two database tables for changed values. Basically, I am trying to log updated data…
Glenn singh
  • 233
  • 1
  • 6
  • 18
1
2 3 4 5