110 results found
-
Synchronize only a subset of data
It would be tremendously useful if SQL Data Compare would support an option to pull only a subset of data from one database and synchronize it with another. This subset could be keyed off of one or more tables. With the current product the end user must construct their own where clauses in order to perform filtering. Furthermore, this filtering does not seem to check any foreign keys to make sure that related records are pulled. It would be very useful if there were an option to "instruct" SQL Data Compare to follow the foreign keys when filtering on one…
25 votes -
Make INSERT statements more efficient using shorter SQL
The INSERT statements that Data Compare should take advantage of the shorten INSERT syntax. For example.
--USE THIS
INSERT INTO dbo.AgiisErrorCode
( Error_Code, Description )
VALUES ( '1', 'Test' ),
( '2', 'test2' ),
( '3', 'test3' )I--nstead of.....
INSERT INTO dbo.AgiisErrorCode
( Error_Code, Description )
VALUES ( '1', 'Test' )INSERT INTO dbo.AgiisErrorCode
( Error_Code, Description )
VALUES ( '2', 'test2' )INSERT INTO dbo.AgiisErrorCode
( Error_Code, Description )
VALUES ( '3', 'test3' )The .SQL files will be smaller, use less network bandwidth, and arguably, insert faster.
Thanks!
72 votes -
Generate data insert script from database
It would be nice to have the ability to generate a data insert script from a database without having to use SQL Data Compare. Currently, the way I do this is to create a second, empty database with the same schema, perform a data compare operation between the current database and the newly created, empty database, and then generate a deployment script. I wrote an application to do this using the SQL Data Compare API, but it is still problematic because it requires that you build a second database first, which requires that you have the schema scripted. It is…
42 votes -
Only select to compare static data
When you do a data compare it would be great if you could select to only diff the static data tables and their data so that data in other tables automatically are ignored.
40 votes -
Create an option to use MERGE INTO versus insert, update, delete
It would be nice to have an option to have the results scripted for MERGE INTO instead of the insert, update, delete. This makes it more friendly to have successful "re-deploy" situations if someone has already deployed the data and the merge into script could handle it.
35 votes -
Export Comparision Results to a SQL table
We would like the option to generate the comparison result sets from SQL Data Compare to an actual SQL table for further processing. Currently our only option is to export to a CSV file.
54 votes -
If a table does not have the primary key, give us an option to use all columns on one click
When some tables cannot be compared because they do not have the primary key, give us an option to "use the combination of all columns" for all those tables, with a single click.
Even when there are duplicates, give us an option to "ignore duplicates if all others are identical".
9 votes -
Add "ignore inconsistent line endings" project option
We have a lot of data in character-based columns that is essentially the same, but because of inconsistent line endings (CR vs CR+LF) cannot be easily confirmed as "identical". For each cell we have to open the viewer and visually inspect whether we only have line ending differences or there are other (meaningful) differences.
31 votes -
add If not exists to data compare
Any way of adding If not exists to the data script output when comparing data.
225 votesWe've had a few requests for supporting MERGE statements - https://redgate.uservoice.com/redirect/suggestions/3100622. Would MERGE help this or are you still looking for IF EXISTS on INSERTS? If you'd like to chat about this, please reply.
-
Filter columns to compare across all tables
I would like to have a global filter that lets you eliminate certain named columns across all tables. I have 5 columns that are in every single table - last update date, last update time, last update user, record status and record delete flag. I want to eliminate them from the comparisons in all tables without individually selecting each table in all the databases.
168 votes
- Don't see your idea?