- or
No existing idea results
- ~ No ideas found ~
115 results found
-
Exclude special schema from datacompare
I would be nice if you could set a filter in the project file which indicates which schemas to ignore.
So tables in this schema will never shown in the database project.18 votes -
SQL Data Compare needs the cool functionality of exporting reports as HTML currently found in SQL Compare!
The below description moved from https://redgate.uservoice.com/forums/147879-sql-data-compare/suggestions/3137395--report-switch-similar-to-that-of-sql-compare:
I would like to see SQL Data Compare get the /report switch like SQL Compare does. With SQL Compare I usually generate an interactive report to store along the generated script in our build process. This allows to review changes packaged into a given build. Having the same kind of reporting capability from SQL Data Compare would allow us to get the full picture of a given build's database changes (for static data, precisely).
112 votes -
Compare Sys tables - I want to compare SQL Jobs
Please add an option to make the Sys tables available for comparison. I want to compare SQL Agent Job definitions in the MSDB database. At this time, SQL Data Compare and SQL Compare cannot do this. Everytime I have to promote jobs to a new environment, I have to do a manual comparison of the SQL Job defintion. Very tedious.
51 votes -
Filters for the "Tables & Views" tab
Filters for the "Tables & Views" tab
When working with databases that contain thousands of table, it takes so long to generate the list of tables and views that data compare is practically useless. It would be great if when you click the "Tables and Views" tab, it would not automatically try to retrieve the entire schema list, but rather give you the option to specify a filter for schema and/or object name and then click a button to build the list on demand. So when you only nee to sync one, or a few tables, it could retrieve the filtered list of objects very quickly.
Filters for the "Tables & Views" tab
When working with databases that contain thousands of table, it takes so long to generate the list of tables and views that data compare is practically useless. It would be great if when you click the "Tables and Views" tab, it would not automatically try to retrieve the entire schema list, but rather give you the option to specify a filter for schema and/or object name and then click a button to build the list on demand. So when you only nee to sync one, or a few tables, it could retrieve the…
76 votesThanks for all the feedback on this suggestion. The team will take the item under review and we’ll update here with next steps.
-
Show how many records have been processed in a table (useful for large tables)
It would be real nice to have a counter displayed on the "SQL Data Compare - Running" screen that shows which record number is being processed for a given table, for example "Processing record X of Y total records". This would be useful for large tables that have lots of binary data (images, files, etc.). This would help us determine whether or not SQL Data Compare is stuck in a loop. Right now the tool does show which table is being compared, which is useful, however, we have one table that has 25 GB of data in it (mostly PDF files and images), so I know the comparison process will be slow. Seeing an actual counter would help us know if any progress is being made. I realize that updating this counter might slow down the comparison process, so perhaps there could be a setting to turn this feature off or on.
It would be real nice to have a counter displayed on the "SQL Data Compare - Running" screen that shows which record number is being processed for a given table, for example "Processing record X of Y total records". This would be useful for large tables that have lots of binary data (images, files, etc.). This would help us determine whether or not SQL Data Compare is stuck in a loop. Right now the tool does show which table is being compared, which is useful, however, we have one table that has 25 GB of data in it (mostly PDF…
11 votes -
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 or more tables so that all related records in other tables are automatically pulled. This scenario is very useful when trying to create smaller development or test databases from very large datasets. It is very time consuming trying to build all the where clauses from scratch to make sure that related records are pulled when trying to grab 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!
75 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 not possible to do this with an existing database for which you don't have the schema. Perhaps there is a Red Gate tool or API that would allow this already, but I am not aware of one.
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?