250 results found

1. Ignore permissions doesn't

   SQL Compare 14.2.4.15334
   I have checked "Ignore permissions" and "Ignore users' permissions and role memberships", but deployment script is creating grants for existing permissions on tables being recreated (replacement table created & populated, old table dropped, & replacement table renamed). Expectation is that it obeys the ignore options.

   2 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

2. Export HTML via "Generate Comparison Results Report" using Command Shell

   There should be a way to Export HTML via "Generate Comparison Results Report" using Command Shell.
   When we have a ".scp" file which contains the Information about the Databases to be compared, which is saved as a project.scp.
   In this case, if we have a ".scp" file, then is there any command to export the html.?

   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…)
   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

3. Databases with a large amount of objects hangs

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

4. More efficient scripting for non-varchar/nvarchar extended properties

   At the moment, extended properties that are varchar or nvarchar are scripted out by SQL Compare as literals ('value' or N'value'). Unfortunately every other data type is scripted out over three lines (plus a GO), declaring an @xp variable of the appropriate data type, SELECTing (not SETting) its value, and finally adding the property.

   With heavy use of extended properties, or even mild use of non-(n)varchar properties, change scripts (and object scripts in SQL Source Control) can become huge pretty quickly. This causes various issues, not least of which is readability during peer review/PR approval.

   I'd like to see this done much more efficiently if possible — for each unique combination of data type and value found in the extended properties, a variable is declared with that value (one line) and added to each property (one line per property).

   The current use of literals for varchar and nvarchar could be preserved, and even extended to use literals for some of the simpler data types (int, money and varbinary would be really easy, though you'd need to use a currency symbol for money; float/real would be a bit more difficult, anything else would be overkill I think).

   This would also mean that all of those unnecessary GO lines could be removed from between every single extended property (you could have one batch for constants and then one batch per data type/value combo, or just one batch for all properties if the variables were given unique names).

   I just got a random table source control script from one of our repos, and it's a 21-column table. There are two custom bit extended properties on all of our tables, and the suggested changes (one batch for each data type and property) take this file from 201 lines down to 79 (more optimisation could be done by abstracting the redundant repeated identifier arguments passed to sp_addextendedproperty, but whether that would harm or improve readability is up for debate).

   At the moment, extended properties that are varchar or nvarchar are scripted out by SQL Compare as literals ('value' or N'value'). Unfortunately every other data type is scripted out over three lines (plus a GO), declaring an @xp variable of the appropriate data type, SELECTing (not SETting) its value, and finally adding the property.

   With heavy use of extended properties, or even mild use of non-(n)varchar properties, change scripts (and object scripts in SQL Source Control) can become huge pretty quickly. This causes various issues, not least of which is readability during peer review/PR approval.

   I'd like to see this… 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

5. Compare/Merge objects with different names and/or reside in same DB

   (1) the ability to compare 'similar/same' objects that are name differently
   (2) the ability to compare objects in the same database that are named differently
   (3) the ability to merge specific changes that are found, in both directions

   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

6. Create scripts folder ignoring fill factor

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

7. powershell cmdlets for SQL Compare

   It would be nice to have clean powershell cmdlets (like SCA) for SQL Compare rather than having to use the old-school command line and arguments.

   2 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

8. Software updates not appearing when Help, Check for updates is used

   Currently using version 14.1.7.14336. clicking on Help, Check for updates. I get you are running the latest version. But there has been 3 updates released since. The current update is 14.1.10.14805 released 01/27/20.
   Trying to see why this happening. How long does it take for the software to see these updates.

   2 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

9. Exlcude specific items from Deploy script from Comparison Results screen

   SQL Compare
   Sometimes I want to exclude specific items from deployment script when doing a comparison. For example, when comparing a table, exclude a specific trigger on that table.

   This is a SSDT feature that is missing in SQL Compare.

   I know custom filters can be used to achieve this, but this it is cumbersome for "ad hoc" choices, and I could not achieve the results wanted for the example below.

   Using a trigger associated as with a table as an example:
   Assume there is a schema change with a specific table that includes a trigger. Assume that the trigger on the source should not be copied to the target, but other schema changes on the table should be copied.
   In the comparison results screen - allow an action on the row for the modified table to exclude the trigger from the deploy script.

   The resulting deployment script would simply exlude the trigger from update.

   A more shophisticated choice would be "preserve". This would exfectively keep the target definition (if it exists) - a choice required is a table rebuild is required.

   The existing filters panel should not be affected by this (beyond reflecting the resulting filter rule from the exclusion made on the table).

   SQL Compare
   Sometimes I want to exclude specific items from deployment script when doing a comparison. For example, when comparing a table, exclude a specific trigger on that table.

   This is a SSDT feature that is missing in SQL Compare.

   I know custom filters can be used to achieve this, but this it is cumbersome for "ad hoc" choices, and I could not achieve the results wanted for the example below.

   Using a trigger associated as with a table as an example:
   Assume there is a schema change with a specific table that includes a trigger. Assume that the trigger… 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

10. Add window management to detached pop=out window

    In SQL compare, if you open the pop-out widow to view differences in a separate window, the normal window controls like maximize and minimize are not available. you cannot double-click the title bar (or Alt+enter or F11 or anything) to maximize it.

    Request adding missing window management to the differences window

    2 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

11. Create deploy and rollback at one invoke

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

    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… 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…)
    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

12. Script subfolder exclusion

    When using script as a comparison source allow the ability to exclude one or more of the subfolders.

    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

13. Prevent ProjectGuid changes in RedGateDatabaseInfo.xml (conflict with SQL Source Control)

    We use both SQL Compare and SQL Source Control to track schema changes. When you update scripts using SQL Compare, it sets the ProjectGuid property in the RedGateDatabaseInfo.xml file. When you check in changes using SQL Source Control, it removes the ProjectGuid from the file. This creates extra work because source control indicates there are differences or conflicts when this is the only change. It would be helpful if the two tools functioned the same.

    2 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

14. It would be helpful to provide the capability to examine two objects within the same database.

    I've worked over many years with multiple teams and I observe the same phenomenon. The proliferation of OLD, _BAK, _20191123, _ETC objects as developers try out new things for all sorts database artifacts; Tables, Views, Sprocs, etc. I would find it immensely helpful to compare two such artifacts, TABLE and TABLEOLD (for example) to see what has been changed.

    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…)
    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

15. Column Filters

    In the results grid, give the ability to filter the results instead of having to sort, great example is the schema column, let us filter by schema instead of having to sort and then scroll to find the schema we want to look at.

    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…)
    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

16. Install update ribbon obscures the 'to and from' database machine name

    With a deadline looming I needed to do a comparison, but I could not see the 'to and from' database machine name until I installed the update. It was hidden underneath the ribbon.

    2 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

17. Search within objects

    Compare already has a search filter, however it would be great if you could also search within the objects and not just by the object names.

    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…)
    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

18. Make activation work

    Downloaded the trial version then my company paid for the toolbelt but when I click on Activate I get a error so cannot activate the software.

    Can’t connect securely to this page
    This might be because the site uses outdated or unsafe TLS security settings. If this keeps happening, try contacting the website’s owner.

    So, I'm contacting you...

    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…)
    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

19. Save Group By Value in Sql Compare

    Save the state of the Group By drop down so that we don't have to change it with each managed project.

    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  ·  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

20. Add a possibility to update all installed Redgate tools

    I have installed the SQL Toolbelt and I would like to update all its components in one shot. Currently, It is possible only by downloading the setup of Toolbelt from Redgate site and "re-installing" the products.

    When I go to Help->Check Updates for particular component, let's say SQL Compare, only this component can be updated. And mostly I have to close All my SQL Server Management Studio (SSMS) session and Visual Studio (VS) Sessions for the
    update, which is time-consuming, but I guess makes sense.

    But after this, I start again all my SSMS and VS sessions and When I start next Redgate component, let's say SQL Data Compare, it might also ask for an update. And I have to repeat the procedure of shutting down my SSMS. and VS-sessions. Having some 10
    Redgate components installed (SQL Toolbelt), I have to repeat this process several times per week, which is not that productive.

    Therefore, I would like to update all components, let's say weekly, so having to stop my SMS and VS-sessions only weekly, which would be totally ok.

    Whether this multi-component update tool is launched either from each components Help -> Check Update or as a separate update tool from Windows menu, I think both would work.

    PS. This feature is initiated based on my Support-ticket: https://productsupport.red-gate.com/hc/en-us/requests/147081

    I have installed the SQL Toolbelt and I would like to update all its components in one shot. Currently, It is possible only by downloading the setup of Toolbelt from Redgate site and "re-installing" the products.

    When I go to Help->Check Updates for particular component, let's say SQL Compare, only this component can be updated. And mostly I have to close All my SQL Server Management Studio (SSMS) session and Visual Studio (VS) Sessions for the
    update, which is time-consuming, but I guess makes sense.

    But after this, I start again all my SSMS and VS sessions and When I… 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  ·  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