- or
No existing idea results
- ~ No ideas found ~
245 results found
-
When tables have different number of indexes the compare will show differences when in reality the indexes are the same, just not aligned.
A table on server 1 has 2 indexes. The same table on server 2 has 4 indexes. Depending on the order that the script generates the DDL the compare might show all 4 indexes as different/new where it should show 2 as the same and 2 new.
89 votes -
Allow comparing objects of all types with different names, not just tables.
It would be nice to be able to use RGSC to compare such objects by re-mapping. A recent change allows doing this, but with tables only. All other objects would be a helpful touch.
This could be useful for several scenarios, including demonstrating a proposed change to a current version. We also sometimes end up with different test versions of objects that differ slightly with less than helpful comments. (b/c all our devs' code is self documenting!)45 votes -
Option to script indexes and triggers into their own sub-folders
Project level option to script indexes and triggers into their own sub-folders. This allow for a more granular check-in and makes text diffs more clear.
37 votes -
Pull filter from source controlled database
When comparing a source controlled database (SSC) to a live database, it would make sense to use the source controlled database's object filter (filter.scpf file) when running the comparison instead of having to manually recreate the filter inside of the SCP project. Also, it would be better if the SCP project stored a link to the filter file used instead of storing the filter string, as it is very inconvenient to have to maintain these separately. If the filter file is changed in SSC, I want SCP to be able to pick up the change automatically.
11 votes -
Color-coding servers
For safety when moving among servers, I have the desktop backgrounds of my servers color coded as follows:
My workstation - green
Other developers' workstations - blue
Development - yellow
UAT - orange
Production - redIn SQL Server Management Studio, I've colored the status bar for any query window in the corresponding servers the same way.
It would be nice if I could color-code the two halves of the "compare to" window in SQL Compare and SQL Data Compare the same way, based on the server/instance name!
Even better, could it pull the color values from some SQL Server configuration data for the status bars I already am coloring?
For safety when moving among servers, I have the desktop backgrounds of my servers color coded as follows:
My workstation - green
Other developers' workstations - blue
Development - yellow
UAT - orange
Production - redIn SQL Server Management Studio, I've colored the status bar for any query window in the corresponding servers the same way.
It would be nice if I could color-code the two halves of the "compare to" window in SQL Compare and SQL Data Compare the same way, based on the server/instance name!
Even better, could it pull the color values from some SQL Server…
76 votes
- Don't see your idea?