245 results found
-
Remove schemabinding
I think its not removing the 'WITH' when doing remove schema binding for dependent objects
v 13.7.3.9483
1 vote -
pin "object definition box"
Allow for pinning of the Object Definition Box so that it is always visible.
It would be nice if you could make the ODB (that's what I'm calling it from now on) could be pinned or made to float so that I could reference it as i type.
The object explorer does provide the same functionality... technically but its nice have the "source" immediately visible as opposed to the multiple folders in the Object Explorer.
1 vote -
CONSTRAINT of current_timestamp generates code that will not run in SQL
tsql source has line:
[CreateDate] datetime default CURRENTTIMESTAMP,
the script that is generated:
ALTER TABLE [dbo].[AirFlowData] ADD CONSTRAINT [DFAirFlowDaCreat82DA8F3] DEFAULT (currenttimestamp()) FOR [CreateDate]Error executing script:
Incorrect syntax near '('.1 vote -
monthly subscription
I would like to start using the Red Gate Toolbox but I cannot afford the cost nor will my company pay for it. Is there an option to be billed monthly?
1 vote -
Post script bit value column auto-update
Add an option that will run post-script to set newly added columns that are of a bit value type and that are scripted with a default value to that value after the addition of a bit column.
1 vote -
Source and Target script folder source should stay with their currently selected path instead of switching to the last used on either side.
This was the behavior in previous versions (at least it was for SQL Compare 10) and not sure when it was changed. But constantly switching folder paths make it error-prone and annoying. As an example, let's say I first chose Folder A/Folder B as Source and then Folder C/Folder D as Target. If I go back to source to pick another folder, now it points me to Folder C/Folder D instead of Folder A/Folder B as I originally selected.
1 vote -
Option to omit schema from filename created with SQL Compare
When the target of the compare is a scripts folder, SQL Compare will create new items with the schema name as part of the file name, such as "person.Contact.sql".
Could this be made optional?
It doesn't affect the filename when altering, only creating.
This behaviour causes us issues because we use Visual Studio database projects where the schema is part of the path, not the filename. For example such as "AdventureWorks\Person\Tables\Contact.sql"1 vote -
Ignore unmapped tables
Can you provide an option in the tool to ignore unmapped tables for comparison?
1 vote -
Allow indexes to be excluded by filtering
I have 2 databases - production, and archive. Archive has all the indexes of production (starting with "IX") but also has some archive only ones (starting with "AIX"). Would be nice if I could add a filter to "exclude indexes starting with 'AIX-'" to my comparison - currently I have to export to a script, and manually delete all the "drop index AIX_..." sections.
1 vote -
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 -
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 -
1 vote
-
Filter for sensitivity of column data type comparison
For example, I would like to ignore when a column is a VARCHAR on both databases but with different lengths so I can focus on when the 2 data types are completely different eg. VARCHAR and NUMERIC.
1 vote -
Add Control+Insert to products
In Windows operation systems it is a common way to use Control+Insert keys instead of Control+C to copy selected text.
This is necessary to support left-mouse-handed people and it's driving me crazy that it does not work within your product(s).
At least I would love to use this option when working within the Comparison to copy code from a left or right script using Ctrl+Ins.
For completeness you should also keep "Shift+Insert" for Paste and "Shift+Del" for Cut operations in mind.
Thank you1 vote -
Ability to create a separate re-runnable script for each object being updated in SQL Compare, instead of just one big script. This is very
Ability to create a separate re-runnable script for each object being updated in SQL Compare, instead of just one big script. This is very important to our business.
1 vote -
Attempt to detect table renames
SQL Compare should try to detect renamed tables and use sp_rename. At the moment, the existing table is dropped and a new table is created with the new name. To avoid data loss, it is necessary to create a migration script but SQL Compare should be able to detect this in a similar way to how it detects column renames.
1 vote -
Refresh clears the details at the bottom. Clicking on highlighted object does not bring up details.
SQL Compare ver 14.2.16.16006 Professional. When I select an object that is different, the details pane is brought up from the bottom. If I click on Refresh, a re-compare is performed and the detail pane goes away. The object that was previously highlighted, is still highlighted. When I click on that object, the detail pane does not come up. I need to click on another object to bring up the detail pane, then click on the original object.
1 vote -
Page Not Found error when I try to get details on updates
Getting page not found error again when I try to get full details for updates to SQL Compare. URL being hit is https://documentation.red-gate.com/display/SC14/SQL+Compare+14.3+release+notes.
I get the feeling that this needs to be added to the "new version number" checklist or something alone those lines. Had similar issue a few builds back.
1 vote -
Add a keyboard shortcut to Next/Previous diff.
It would be nice to be able to navigate to the next diff (or previous) using a keyboard shortcut (e.g.: CTRL-N, F8, etc...)
1 vote -
Option to ignore stats based on name
When recreating statistics that were "Auto Created" they now become non "Auto Created".
This means when comparing the database against the original, because SQL Compare doesn't display "Auto Created" statistics, it looks like there are loads of new statistics
I found this as I am trying to change collation of everything in a database and have to recreate the statistics.
Please can there be an option to ignore statistics if they match based on name and the only difference is "Auto Created"?
1 vote
- Don't see your idea?