244 results found
-
index
SQL compare regularly identifies a difference between the same index between the same table stored on 2 different databases as it seems to get confused with a different index then says the the same index underneath the 'different' one, should be deleted! It must not compare on the name of the index but maybe an order? Is this a bug?
1 vote -
Support for Module Signing Comparison
Please could you consider adding support for the comparison of signatures between databases. Currently SQL Compare doesn't check for differences between module signatures, please refer to this forum post:
https://forum.red-gate.com/discussion/87404/module-signing-support
The consequence of this is that during deployment by SQL Compare, module signatures will be ignored, therefore causing deployed modules that depend on the signatures to fail during execution.
Additionally, should signatures be removed from a database using a command such as sp_refreshsqlmodule (which implicitly removes signatures), SQL Compare will not identify that the signatures have been removed.
1 vote -
1 vote
-
Menu bar display issues when using Remote Desktop app in Windows 10
I have trouble seeing the menu bar when using Remote Desktop app in Windows 10. The menu bar is very tiny and not completely visible. Very hard to work with.
1 vote -
User Permissions
I would like the option to compare user permissions, or system tables/views.
1 vote -
Script Generation: Control over the sp_rename of a table
When you add a non nullable column in a table, there is a warning that the script can fail. The generated script will issue will try to help by removing all contraints, rename the table and recreate it. This cannot be done on large table (with data). The only choice I have is to add the column as nullable, add the initialisation in the script and make it not null after. So, I would like to accept the warning and to let the 'alter table add column' been generated with a comment in the generated script. I guess to work…
1 vote -
Include option to only include diffs
The idea here is produce a summary - that is the content focuses on the changes.
For example:
For new objects - indicate "new", with one-line description - but do not include definition
For deleted objects - indicate "removed"
For changed objects - only the show the "diff" with a little context instead of the complete definition.1 vote -
Compare the OPTIMIZE_FOR_SEQUENTIAL_KEY property of an Index
By default this is 'off' in SQL 2019. But we have found some tables have significant performance improvements for load if its 'on'. Thus tuning requires these indexes to be on. For SQL Compare to remain useful it needs to highlight were where there is a difference in the property - and support deployments with the property to retain it as on.
1 vote -
Database scoped credentials are missing
SQL Compare ignore database scoped credentials. So you wont be able to create external data source from generated script. It's clear that password is not accessible. But if you prepare create statement with data available from sys.databasescopedcredentials and let us fill out secret it will be much better then to skip this object.
1 vote -
Separate ifg in the SQL Compare Options
Please break out the ifg switch in SQL Compare Options so file groups are separate from partition schemes and partition functions. Maybe ifg only ignores file groups, and create a second name ifp (or whatever) that would ignore only partition schemes and funtions.
1 vote -
Correct order when renaming column and adding column with the old name
After explicitly fixing column mapping, I encountered an error when renaming an existing column and then adding a new column using the old name (different casing).
SQL Compare had scripted the column add before the rename.
SQL Compare needs to be able to detect the conflict and script the rename before the column add.1 vote -
Allow option to not script logins when generating script and also add check for existing users to avoid errors
I was trying to create a copy of the development DB schema into local server. I got errors and warnings. The error I got was in the section of code that created the login and then attempted to create a user (myself). I didn't sent this error as it contained some confidential info. There also needs to be a way to remove things like login names from the generated email.
1 vote -
1 vote
-
ned.bush@ky.gov
Have pop-up screens (My Projects, Compare Progress, Save Script, etc.) open up on the same display as the main program when program is running on a computer with multiple displays.
I've noticed that if I'm running SQL Compare or SQL Data Compare and move it to my secondary display, it still tries to open up pop-up dialogs on the primary display. This can be annoying, especially if it has been a little while since I used the program and I forget it does this and can't spot why program seems to have stopped responding to mouse clicks. Also, when the…
1 vote -
Commented-out blocks of code should show as changed
When an entire block of code is commented out with the /* */ characters, SQL Compare only shows only the lines with these characters as changed. It does not show the unchanged block of code between them as changed, even though the impact of commenting out this code can indeed be a significant change.
I suggest that unchanged lines of code enclosed by /* */ around it should still show as a substantive change. When we recently deployed an SP update with a large block of code that was commented out during testing, it slipped in because the scrolling view…
1 vote -
Allow filters to be case INsensitive
Allow filters to be case INsensitive
When I add a filter e.g. schema name begins with "ABC" then objects with schema Abcdef will not be shown even though i have opted for case insensitive matching
this means that I have to make several OR filters to cover all combinations of upper or lower case letters1 vote -
excel
Include attributes to be changed in an object to an excel report in sql compare. include not only the object name to be changed but the actual change to fields
within the object or the script change to be made for programability items users roles and permission. e.g. Database.schema.objectinsource.change(details of change column to be altered in a table its original value its new value its datatype and length its nullability and any default constraints.1 vote -
beyond
Allow an object / script comparison to be opened in an external Diff viewer, such as Beyond Compare. Provide configuration settings to configure external diff viewer EXE, similar to what source comparison tools do.
1 vote -
Add next to table object names the record count in the table
When comparing tables I saw that for two tables auto-map has mapped some columns. Since I know the tables are not compatible I had to check that the target does not have any rows in the table. Please add some indicator on the object list so that I can know easily if there are any rows in the table
1 vote -
user defined type
I recently had to use SQL Compare to create a rather large add new and update deployment script.
I was pleased that it picked up User Defined Types in addition to the normal tables and stored procedures.
But it did not pick up the permissions for the User Defined Types, and that was a failure point when executing the stored procedures.
This was my first time working with User Defined Types before, and I thought it odd they needed permissions at all. I did not apply any in the development environment, and they worked there.
But the error was clearly…1 vote
- Don't see your idea?