Activity overview
Latest activity by VFPeter
Please ignore this issue. I noticed that the tester had created a varchar field for numeric data when dumping from flat file to table. / comments
Please ignore this issue. I noticed that the tester had created a varchar field for numeric data when dumping from flat file to table.
Thanks @Tianjiao_Li. I have added to the user voice forum here: https://redgate.uservoice.com/forums/147879-sql-data-compare/suggestions/35726938-exporting-only-mismatch-fields-to-csv / comments
Thanks @Tianjiao_Li. I have added to the user voice forum here:https://redgate.uservoice.com/forums/147879-sql-data-compare/suggestions/35726938-exporting-only-mismatch-fields-to-csv
Comparing Numeric fields
Is there an option to compare numeric field? Currently, 1.0 and 1.00 is flagged as different. So it is for 1.20 and 1.2.
It worked! There were some issues with some of the Field Names. After it was corrected, everything worked great! I do have another question that I have posted here as it is different: https://forum.red-gate.com/discussion/84162/exporting-only-mismatch-fields-to-csv#latest / comments
It worked! There were some issues with some of the Field Names. After it was corrected, everything worked great!I do have another question that I have posted here as it is different: https://forum...
Exporting only mismatch fields to csv
After doing the data compare when you export, is there a way to only send mismatch columns to the CSV file for each row?
I manage to make some progress. I was able to select the two tables and also set the comparison key. But when I execute "Compare", it is not including these two tables. Any ideas? [image] [image] / comments
I manage to make some progress. I was able to select the two tables and also set the comparison key. But when I execute "Compare", it is not including these two tables. Any ideas?