110 results found
-
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 -
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 -
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…
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.
-
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 -
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 -
Excluding columns from data comprison with options to include them in the deployment script
Excluding columns from data comprison with options to include them in the deployment script because we need these columns as placeholders
54 votes -
Read from SQL Native Compressed Backups
Compare does not read from SQL backups that have used the native compression, although they can read from Redgate Backup files that have been compressed. I think that it should also be able to read from SQL compressed backups, as not all users will have Redgate Backup software.
This would be beneficial to all, because it would create a way of restoring lost data without using a partial restore, to any user that has this Compare software.52 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 -
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 -
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 -
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 -
Provide support for custom comparison queries
While browsing the improvements, I notice a whole set of ideas centered around the ability to filter data, providing support for data types that may have changed between stages in the database lifecycle (development to QA to production for instance), and the ability to filter columns, changing column names, etc.
All of this could be supported by providing custom SQL query support in SQL Data Compare.
The tool should provide for a custom comparison query for the source and destination table.
21 votes -
Relaxed data type matching for comparisons
I'm using SQL Data Compare extensively as part of a refactoring project. As we optimize data types we end up with situations where we cannot compare source and destination table data due to mismatching data types. I'd like to request a flag that implements implicit/explicit SQL Server data type conversions. For example, I want to be able to compare and synchronize DATATIME/SMALLDATETIME to DATE or VARCHAR to TINYINT/SMALLINT/INT.
19 votes -
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 -
Include History tables together with temporal tables in comparison
I need to compare and sync history of temporal tables as well when testing our system in different environments. Competitive products already have this feature.
16 votes -
Custom computed comparison key for matching table records
Originally introduced in this thread: https://forum.red-gate.com/discussion/comment/149220#Comment_149220
This is a common problem for us when using Data Compare. Parent table has unique constraint on a char field alongside an identity field which also serves as a one-to-many foreign key in the child table. The child table uses an identity field to distinguish each row but there's no guarantee the id's will be the same across databases so only the parent can be matched but the child table only has the parent_id identity fk which is not a viable comparison key.
My proposed solution would be to allow user to define a…
15 votes -
Provide option to include USE statement in deployment script (just like SQL Compare)
Currently, we have to manually edit every SQL Data Compare deployment script to add a USE <DB> statement at the top. We would like to see an option in the tool like SQL Compare has.
14 votes
- Don't see your idea?