75 results found

1. 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

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   3 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

2. add If not exists to data compare

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

   225 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   19 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating
   AdminStephanie (Product Manager, Redgate) responded

   We'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.

3. Suppress columns with identical data

   Similar to the option to suppress identical rows, I'd like to suppress columns that are identical on both systems. Especially when comparing tables in a DW environment where we may have 10s-100s of columns I'd rather not scroll across the 100 columns that are identical in order to find the one columns where we have differences.

   Our primary Data Compare application is to validate data changes in th DEV/QA system by comparing against the good PROD data. These comparisons typically involve large tables (100s of columns, millions of rows)

   49 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Delete…  ·  Admin →
   completed  ·  Andrew Farries responded

   SQL Data Compare V12.1 adds an option to hide columns having identical data in the source and target. The feature is described in our release notes:

   https://documentation.red-gate.com/display/SDC12/SQL+Data+Compare+12.1+release+notes

   Please let us know on the SQL Data Compare forums if you have any feedback about this feature:

   https://forums.red-gate.com/viewforum.php?f=201

4. 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

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   2 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

5. 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… more

   42 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   2 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

6. Enable comparison of columns encrypted with Always Encrypt

   Currently if you try compare tables with encrypted columns, you get a cast error. It doesn't tell you that encryption is not supported. In fact it took your help desk two weeks to tell me it doesn't and suggest I post a feature request here. I do not know what mechanism you use to connect to SQL Server, but all of my other SQL Server clients support it seamlessly. That includes ODBC. Even if you didn't want to enable decrypting the data you at least could just allow the comparison on the encrypted values, and let the user worry about whether or not the keys are the same. This is a major feature of SQL Server that has been around for several years. It is quickly becoming the standard to encrypt data. On top of this, your documentation implies that it works on encrypted data. So much so, that your own tech support thinks it does.

   Currently if you try compare tables with encrypted columns, you get a cast error. It doesn't tell you that encryption is not supported. In fact it took your help desk two weeks to tell me it doesn't and suggest I post a feature request here. I do not know what mechanism you use to connect to SQL Server, but all of my other SQL Server clients support it seamlessly. That includes ODBC. Even if you didn't want to enable decrypting the data you at least could just allow the comparison on the encrypted values, and let the user worry about… more

   8 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

7. 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… more

   25 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   2 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

8. 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

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   17 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

9. 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

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   3 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Submit Rating

10. Accurate floating point comparison in SQL Data Compare

    This was already discussed on the Red Gate forums in 2007:
    http://www.red-gate.com/messageboard/viewtopic.php?t=5875

    As of SQL Data Compare 9.1.0.365, the problem still exists.

    From the forum thread:

    """
    I find that very often, a column containing floating point numbers will show as different [in SQL Data Compare], even though visual inspection of the results [in SQL Server Management Studio] shows that it is the same.
    """

    It's difficult to know if the data in the float column has actually changed, or if it's just SQL Data Compare making an innacurate comparison.

    It reduces my confidence that the data has been synchronized correctly.

    This was already discussed on the Red Gate forums in 2007:
    http://www.red-gate.com/messageboard/viewtopic.php?t=5875

    As of SQL Data Compare 9.1.0.365, the problem still exists.

    From the forum thread:

    """
    I find that very often, a column containing floating point numbers will show as different [in SQL Data Compare], even though visual inspection of the results [in SQL Server Management Studio] shows that it is the same.
    """

    It's difficult to know if the data in the float column has actually changed, or if it's just SQL Data Compare making an innacurate comparison.

    It reduces my confidence that the data has been synchronized… more

    6 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    3 comments  ·  Delete…  ·  Admin →
    completed  ·  AdminStephanie (Product Manager, Redgate) responded

    In SQL Data Compare v10, there is now a “Use maximum precision for floats” option

11. Data obfuscation / masking

    Perhaps include an option to allow for data masking / obfuscation in SQL Data Compare.
    I think this will help with moving data from Prod to Dev for example.

    1 vote

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    1 comment  ·  Delete…  ·  Admin →
    declined  ·  Richard Mitchell responded

    You may want to investigate our tool SQL Data Generator which can do exactly what you want.

    We’ll be looking into making it easier to setup masking so if you’d like to chat about your details requirements please don’t hesitate to get in touch.

12. Provide AWS AMI for Redgate SQL Data compare

    Provide AWS AMI for Redgate SQL Data compare

    3 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

13. provide additional binary data view options (i.e. PDF, Word, HTML)

    When i am comparing tables with binary data i am limited to Ansi or Unicode Text, Hexidecimal or Picture. We are storing PDF, Word and HTML documents and i would like to be able to view those better to see the differences. If this is not possible how about an export to open the data into the actual application (like an "open with....." option)

    5 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

14. Make the target (server+database) independent of the data set (tables and views)

    I'd like to store in a Data Compare project file a list of targets that I can select very easily. A target is server+database. It includes credentials as well. I don't want to re-enter them all the time.

    I don't want to make many project files for them.

    The same is true for a selection of tables and views. I compare very large database and I need different subsets of tables depending on the current task I'm working on.

    Again, why a separate project file for them? I don't want that.

    Given that I need to vary both target and data sets I would require a quadratic number of project files! And what if I need to change other settings. I then would need to update quadratically many project files for that.

    This would be very valuable. I spend easily 25% of the time using the product configuring these things. And it's such an annoying kind of work.

    I'd like to store in a Data Compare project file a list of targets that I can select very easily. A target is server+database. It includes credentials as well. I don't want to re-enter them all the time.

    I don't want to make many project files for them.

    The same is true for a selection of tables and views. I compare very large database and I need different subsets of tables depending on the current task I'm working on.

    Again, why a separate project file for them? I don't want that.

    Given that I need to vary… more

    11 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

15. Option SyncOptionIncludeExistenceChecks should be applied to data updates

    We use SCA with the following setting:

    <SyncOptionIncludeExistenceChecks>True</SyncOptionIncludeExistenceChecks>

    Yet when a migration script is created for a table with data tracking enabled, there is no existence check:

    PRINT (N'Add 1 row to [dbo].[ReleaseNote]');

    SET IDENTITY_INSERT [dbo].[ReleaseNote] ON;

    INSERT INTO [dbo].[ReleaseNote] ([ReleaseNoteID], [AppVersionID], [ReleaseNoteText], [DisplaySequence], [DisplayCondition])
    VALUES (14, 4, N'You can now save calculations.', 2, NULL);

    SET IDENTITY_INSERT [dbo].[ReleaseNote] OFF;
    GO

    I just got an error for the statement above, since the record already existed. Can you please update SCA to apply existence checks to table inserts?

    6 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

16. BUG: RedGate Data Compare "Calculating time remaining" is inefficient and incorrect

    RedGate Data Compare "Calculating time remaining" is inefficient and incorrect
    1. It ignores filters set on the tables. So baseline counts are incorrect.
    2. Since it ignores filters set on the tables, it takes much longer, especially on large partitioned tables.
    3. It runs the count queries sequentially on each data source, even though they could run in parallel.

    3 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

17. Data Compare - Save table/rows selected for deployment

    Please add this feature when saving projects. It would be useful when the project has not been deployed, but saved for a future deployment or re-review without having to re-select all the tables.

    "The project does not remember which tables or rows of data were selected for deployment."

    3 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    2 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

18. Make SQL Data Compare respect the "do not use transactions" setting

    The use case for this may be a bit odd but I've had a very big compare to do today - refreshing takes nearly an hour.

    Now I'm putting the data from 20 or so tables into another. Trying to pass the contents of all the tables in one transaction blows out the server logs, it's just too many rows.

    However, turning off the "use transactions in deployment scripts" option is ignored until I refresh the data. That means waiting nearly an hour before SQL Data Compare will respect the value in the project settings.

    That really doesn't make any sense to me. Can you make it so that the value of the setting is reflected every time I press the "deploy" button, rather than the "refresh" button?

    The use case for this may be a bit odd but I've had a very big compare to do today - refreshing takes nearly an hour.

    Now I'm putting the data from 20 or so tables into another. Trying to pass the contents of all the tables in one transaction blows out the server logs, it's just too many rows.

    However, turning off the "use transactions in deployment scripts" option is ignored until I refresh the data. That means waiting nearly an hour before SQL Data Compare will respect the value in the project settings.

    That really doesn't make… more

    3 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

19. SQL Data Compare - Automatically select linked static tables for comparison when using Source Control

    When I am comparing a SQL Source Control Repository against a DB, we need find an option to only compare tables which are linked for static data in source control.
    This seems like a glaring missing feature, since I now have to create a project that manually maps all the tables that have static data and ignore everything else, and manually update it when new static tables are included in the repository.

    4 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    3 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating

20. Export results in format that can be imported back into Data Compare for review

    The SQL Data Compare GUI is the best way to review differences. I'd like a way to export my results to a file that can be re-imported for others to view, without having to go back through the comparison process.

    4 votes

    Vote Vote Vote

    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    1 vote 2 votes 3 votes Remove votes

    You have left! (?) (thinking…)
    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Submit Rating