259 results found
-
Allow Ignore for OPTIMIZE FOR clauses
In single-tenant database environments with multiple databases sharing similar schemas, OPTIMIZE FOR clauses can be used to prevent query plan regressions. However, database object comparison tools should include an option to ignore these clauses, since optimisation parameters that work for one database may not be suitable for other single-tenant databases.
3 votes -
Tag updated function
Quite simple really... on the "Actions" menu include a new option: "Include updated". This would select every change that is newer on the source that is either not present or older on the destination.
This would save a lot of time picking through things where there are a lot of changes, especially with multiple developers working on the same database.
3 votes -
Allow comparison of system stored procedures in master database
We have a handful of system stored procedures in the master database that SQL Compare effectively ignores when doing comparisons. Since all MS system stored procedures are in the 'sys' schema, allow for comparison of system SPs that are not in the 'sys' schema. Seems pretty simple and very useful.
3 votes -
Include *.snp filenames in SQL Compare reports
The DatabaseName/ServerName included in some SQL Compare report headers is completely worthless.
A value-added proposition would be to include the actual *.snp names in the header.
This is Red Gate SQL Compare *.html code:
var datasource1type = "snapshot";var datasource1server = "thisinfoisIDENTICALandworthless";var datasource1database = "IT";var datasource2type = "snapshot";var datasource2server = "thisinfoisIDENTICALandworthless";var datasource2database = "IT";
This does not appear to be rocket surgery...
3 votes -
Melhorar o uso de memória
Cada vez que é feita uma comparação de database aumenta o uso da memória. Só liberar a memória quando sai e volta pra aplicação.
2 votes -
Sort objects in deployment script
As per:
https://forum.red-gate.com/discussion/85655/feature-request-sort-objects-in-deployment-script
When generating the sql compare deployment script - all objects are scripted in a seemingly random order.
This could be covered by an option to enable/disable it.
And obviously, there is a dependency order which much take priority first. But after that all objects should be scripted in alphabetical order.
Use case for this is generating the same update script multiple times and committing it to source control. If this is done during a RC phase, the later iterations of the script will be 90% the same with minimal differences.
Currently as it stands, objects get moved…
2 votes -
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 -
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 -
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 -
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 -
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 -
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 -
SQL Search Right Click Modify
If would be handy in SQL Search to be able to right click/Modify instead of double clicking, waiting for what could be a last treeview list in SSMS to open, then having to right click/modify.
2 votes -
Rebuild partition instead of dropping & recreating primary key when only changing data compression
SQL Compare currently attempts to drop and recreate a primary when changing compression.
REBUILD PARTITION ALL WITH (DATA COMPRESSION PAGE|ROW|NONE
would be more efficient and less intrusive since, among other things, it doesn't require dropping and recreating all foreign keys.2 votes -
Trigger Comparison/Ordering
I have TableOne in DatabaseA and DatabaseB. DatabaseA.TableOne has Trigger1,Trigger2 and Trigger3. DatabaseB.TableOne has Trigger2 and Trigger3. After all table columns are analyzed, DatabaseA.Trigger1 is compared to DatabaseB.Trigger2 and naturally they show as different. I'd like to see Trigger1 "compared" to blank, then both Trigger2s compared, ... Try to match up on trigger name and if there isn't a match, show blank
2 votes -
Allow migration of Indexes ONLY
I have multiple databases which have the same columns (mostly) but sometimes differing defaults.
They also have different indexes.
I'd like to choose to ONLY sync indexes across.
Obviously the system would need to be intelligent enough to sync only those that have the columns they use/include in both source and destination.
2 votes -
Selective Changes
Allow the selection of what changes you want instead of updating the whole object. For example, a table may have column changes that you don't want to promote but indexes that you do want to promote.
2 votes -
Unecessary table rebuild
The tool will try to rebuild the whole table even when the only thing needed is the addition of one column. If you need it, I can send an image of the comparison results. To work around it, I search for rebuilds within the generated script and substitute them by the needed command, specially if the table is a very large one.
1 vote -
SQL Compare Flagged store procedure difference but could not see where
SQL Compare Flagged a difference between Test and Production Store Procedure but I could not see where. I had to use notepad++ compare to see a Single Space. Please make this visible in the next release.
1 vote -
Flter save location does not exist causes exception
After you specify a file path and save your filter.
Delete the directory where the filter was saved
Click the "Save" button again and you get an exception. Need a "Save As" function or something to override the setting you set last time.1 vote
- Don't see your idea?