254 results found
-
Fix the selection of working folders
Let me change the location of the users data folders. The application creates a folder inside the Documents folder. When I change the location in the Application options dialog still a folder inside the Documents folder is being used. I want my Documents folder not to be used by this application
3 votes -
Add Version # to your objects/DB
When running a deployment (especially for the automated DevOps part, but even for creating a deploy script) you should have the option to enter/update a new Extended Property value called like “RedGate Version #” with whatever the version number you get from the source control for that object. Ideally it would be nice to also update that in the database level Extended Property as well, but at least on whatever object you are making a change to with that deployment. That way you can self-document what the latest version control number was for that particular object (or the DB as…
6 votes -
Easier Method to Snapshot Multiple Databases from same server(s)
1) SQL Compare has handy database snapshot ability to a folder. It would be great if rather than creating 1 database snapshot at a time you could tick each of the databases you'd like a snapshot created for.
2) Would be cool if like SQL Multiscript tool, you can speficity multiple servers and databases and have the snapshots named and/or placed in folders with server and database names.
3 votes -
1 vote
-
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 -
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 -
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 -
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…
3 votes -
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 directions8 votes -
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 -
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 -
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 -
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…8 votes -
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 -
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…8 votes -
Script subfolder exclusion
When using script as a comparison source allow the ability to exclude one or more of the subfolders.
4 votes -
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 -
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 -
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 -
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
- Don't see your idea?