Skip to content

SQL Data Compare

Welcome to the SQL Data Compare feature suggestion list. Find out more information about SQL Data Compare at http://www.red-gate.com/products/sql-development/sql-data-compare/

If you have any questions, need help or have found a bug in SQL Data Compare, please visit the forums at https://forums.red-gate.com/viewforum.php?f=201 or our support portal.

SQL Data Compare

Categories

JUMP TO ANOTHER FORUM

(thinking…)

How can we improve SQL Data Compare?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

115 results found

  1. Update info page is broken -- provides no information on what is included in the update

    Fix the page -- give us some indication on what is fixed and/or what enhancements are in the update so we know if it is worth installing or if we might as well wait until next update.

    1 vote
    0 comments  ·  Admin →
    How important is this to you?

  2. 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
    2 comments  ·  Admin →
    How important is this to you?

  3. Project level variables / merge fields

    We use data compare to run a sync of lots of data across many tables all linked to a specific organization in a multi-tenant db.
    It would be great to be able to define a variable at the project level, e.g. InstanceID, then be able to set a sql comparison to InstanceID = [InstanceID] (or @InstanceID). That way we could copy a project and just edit the InstanceID instead of going into 30 definitions and changing every ID. Would be most useful as a simple text replace, so we could use "between 1 and 2" or like 'abc%'.

    1 vote
    1 comment  ·  Admin →
    How important is this to you?

  4. Move "automatically add new tables" to "data sources" tab

    If I'm working from an old file, sometimes I need to add to the definition in there. But there are new tables, so I need to turn off "automatically add new tables".

    However, the only way to turn it off is to change to the tables & views tab... which then adds all the tables you didn't want before you have a chance to turn it off.

    It save a lot of time to move this option to "data sources", so I could set it before changing to the tables tab and I now have to find all the new…

    3 votes
    0 comments  ·  Admin →
    How important is this to you?

  5. 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
    3 comments  ·  Admin →
    How important is this to you?

  6. add If not exists to data compare

    Any way of adding If not exists to the data script output when comparing data.

    225 votes
    18 comments  ·  Admin →
    How important is this to you?

  7. 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
    1 comment  ·  Admin →
    How important is this to you?

  8. 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
    11 comments  ·  Admin →
    How important is this to you?

  9. 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
    0 comments  ·  Admin →
    How important is this to you?

  10. 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
    5 comments  ·  Admin →
    How important is this to you?

  11. 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
    0 comments  ·  Admin →
    How important is this to you?

  12. Disable unique constraint indexes

    If a table has a unique constraint index on say the name column and the change is just sapping the names on the IDs. The script to update the names ends up failing because it causes a unique constraint violation, but if the index is disable, then the update runs, then the index is rebuilt the unique constraint does not cause a failure.

    12 votes
    1 comment  ·  Admin →
    How important is this to you?

  13. Provide an automatic custom key option on Tables & Views tab

    It's extremely time consuming to have to go to each individual table to create a custom key for comparing tables. Even with the common option of holding Shift to select a range. I have databases with hundreds of tables, and not all have a PKey. It would be nice to have an option that automatically selects all columns on the Tables & Views tab. You could even offer other options to select certain columns, or other ad-hoc options, for what columns to use in the compare process.

    4 votes
    0 comments  ·  Admin →
    How important is this to you?

  14. table Id

    I am trying to compare only 1 field in the 2 tables, BUT the Id of the table is included anyway in the compare. That makes the compare result wrong. I expect identical in the result, but because the Id is included then the result is wrong. How can I remove the Id from compare?

    1 vote
    0 comments  ·  Admin →
    How important is this to you?

  15. Ability to send bugreport from unlicensed trial

    I've got some bugs during trial and I would like to send bug reports to support, but only licensed users can do it...

    0 votes
    0 comments  ·  Admin →
    How important is this to you?
1 2 3 4 6 Next →
  • Don't see your idea?