SQL Compare

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

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

SQL Compare

Categories

JUMP TO ANOTHER FORUM

  1. My company is using SQLCompare 14 and always create roll forward and roll back sql with 2 calls by reversing the input arguments., We output the database into file system and compare both directories. It took 15 sec for the "Registering data sources" because we have a big Database. We have 10 or more database so that adds up the time to several minutes to build a patch every time we check-in .
    Can we add a switch to create both forward.sql and rollback.sql at one time instead of call this 2 times? This can cut our build time in…

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Please see this thread

    https://forum.red-gate.com/discussion/comment/162865#Comment_162865

    I would suggest that because the proposed solution requires knowledge and access to the Registry this should be a feature to edit the list.

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. I just want to share the differences between two databases with the developer and will have to explain that added or removed does not mean that anything was actually added or removed yet.

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  4. While using command line to generate a difference report (in html format), if the two databases are identical, the console output says:

    Error: The selected objects are identical or no objects have been selected in the comparison. Use /include:Identical to suppress this error.

    If I include the /include:Identical switch, then the error is not reported on the console, but the output html file has all the objects in it.

    I don't want the console error as well as don't want the identical objects in the html file. This is what I want:

    1. Don't want to use the /include:Identical switch
    2. If…
    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. I understand that you have the ability to compare DBs to sqlproj but it would be nice to have it compare with a dacpac. That way I can build a project, persist that build number and deploy from that dacpac.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  6. Using SQL Compare version 11 for Microsoft SQL Server, I can exclude a user from the schema comparison:

    <exclude>Role:MyCustomUser</exclude>

    This works fine for excluding the user.

    However, the comparison engine does not exclude the user's mapping to roles. The script includes sp_addrolemember commands for the excluded user.

    When excluding a user, I expect their role assignments to also be excluded.

    I suspect this behavior may exist with object exclusions for other object dependencies. Have not tested other scenarios.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. I use SQL compare periodically as I have many clients who have the same core DB and so during development I use SQL compare iteratively to update schema, table and stored procedure changes through the 30 instances of the databases. I noticed that it progressively gets slower and consumes more RAM. Obviously I can close and restart to get a new allocation and it speeds up again. But I noticed that when starting it was consuming about 180Meg, then after maybe 15 compares the memory allocation was close to 1Gig. So something is definitely being allocated and not freed up.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  8. Add an additional "Compare all" button to compare all projects in the actual "Look in" folder. Show a simple is equal/different indicator on each project for the results.

    Consider using VS-style solution files or kind of meta-scp.

    This is somewhat similar to https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/13517250-auto-compare-after-oping-a-project-mass-compare

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. When comparing a TFS Changeset in SQL Compare it will show all schema changes that are different between the Changeset and the destination, but within a TFS Changeset, there is metadata within the Changeset to indicate which specific database objects are being changed within the Changeset. It would be a huge timesaver to allow SQL Compare to be able to only select the database objects that are actually being impacted by the Changeset by default. The situation I have is this:

    Developer 1 - Adds a table to database A and checks in the change to the development database, but…

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. When SQL Compare apply an automapping on column name of a table, there is a little yellow image with "Auto Map" displayed on the table. It would be nice if a menu or double click or else would be availaible to open directly the column mapping of this table. It would be faster to see the mapping applied and correct it if needed.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. The report header shows only the database name. Seeing BobsDB -> BobsDB isn't useful. I would rather have something like: DevServerName.BobsDB --> ProdServerName.BobsDB

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. There are some changes that are riskier than others, not because of the type of change, but because of the object. For example, some changes require rebuilding a table or index. This can be a simple process if there are a few hundred rows, but it's a risky, slow process if there are a few billion.

    It would be nice to add a "risk" value to certain tables, so that when I see a list of changes, I can determine if this particular object ought to be separated out as a different deployment.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  13. When you right click on an object to see the deployment script and other options, include options for running immediately the script to target database. (to make it more interesting,to run the change script to any of the 2 compared databases).
    Also, this should be dome on the right and left scripts at the bottom of the page.
    Thanks

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. It would be extremely helpful for the compare to highlight the one that is newer. When trying to decide if server 1 or server 2 wins, we need to know which ones were updated more recently on one or the other server.

    Since the date fields are on extreme sides, it's difficult to compare dates.

    Color for the newer one or putting the date columns in the center would be two ways to help with this. Color/bold would be ideal.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  15. hello, i appreciate that we only need this feature because my company's processes are lacking but what I would love to have is to be able to...

    right-click an object in SSMS and click an option called something like 'compare against other environment'.

    it would then bring up a message box where you could browse an object-explorer for the corresponding object.

    the use cases I see all the time for this are

    1. when people have stored procs next to each other called

    spSomeProc
    sp
    SomeProcv2
    sp
    SomeProcnew
    sp
    SomeProc.old

    etc on the same database.

    2 when you…

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  16. Hello

    It would be great if there is documentation that explains how SQL Compare works. Everything I came across so far explains what it does but I didn't find the actual internals of it. I am particularly interested in how SQL Compare handles the dependencies between various objects. For example, how can it create a view before creating the tables the view is using?

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. Data Compare almost always fails because of frequent (but short) network outages. If we could specify a long timeout, that would solve this problem.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. I would be ideal if there was the ability to compare just a single Schema in databases. Example, exclude all dbo object and just include all objects in the XX schema. This would speed up the compare, as we would only be comparing objects in the XX schema and ignoring the 10K objects in the dbo schema.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  19. File->Create scripts folder should script index fill factor. When the created folder is compared against a DB I can optionally include/exclude the fill factor as I need

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. I am trying to do a schema compare and deploy but the source database has 99k objects. Is it possible to chunk the deploy feature?

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?