2 votes
When generating the output script for a schema compare, the drop for statistics is not being wrapped in a check to make sure the statistic exists.
For example:
USE AdventureWorks2008R2;
GO
IF EXISTS (SELECT name FROM sys.stats
WHERE name = N'ContactPromotion1'
AND object_id = OBJECT_ID(N'Person.Person'))
DROP STATISTICS Person.Person.ContactPromotion1
GO
5 votes
Hi,
It would be handy if in the 'linked servers' section of the schema browser you could drill down into a linked server's catalogs to see the various tables / views accessible.
5 votes
In the "Export Finished" dialog there is an option to open the exported file (shown as a link). What I am missing there is the option to open the containing folder. Because most of the times I just want to send the exported file to someone. So I need to go to the folder, zip the export file and send it as an attachment.
5 votes
In Toad for SQL Server 5.8 when you pull up the ALTER TABLE window, you currently have the use the up and down arrow icons to move the order of the existing columns.
Request for enhancement to allow for mouse drag and drop and multi-select of columns to change the order.
3 votes
The number of rows, that code completion fetch from a table should be configured (20 to 100 Rows or so...). The 20 Rows you fetch are many times to less. I need - especialy for my databases - arround 30 to 50 Rows to fetch.
3 votes
When I do a manual backup of a DB, I always select to add the current date time. TOAD adds the date and time all right. But it adds it in a strange and hard-to-read manner. It apparently uses a string of mdyyyyhns. This is very difficult to read, and the size constantly changes, as it only uses two digits when the number is greater than 10. I would prefer to see yyyy-mm-dd-hhmmss. Or, better yet, make it user configurable, ...more »
When I do a manual backup of a DB, I always select to add the current date time. TOAD adds the date and time all right. But it adds it in a strange and hard-to-read manner. It apparently uses a string of mdyyyyhns. This is very difficult to read, and the size constantly changes, as it only uses two digits when the number is greater than 10. I would prefer to see yyyy-mm-dd-hhmmss. Or, better yet, make it user configurable, but default to the aforementioned string. This should be very easy to implement, since it's just a change to a format mask.
« less full details »
0 votes
When using the schema compare tool, it is sometimes marking the foreign keys and indexes as different because they are generated in a different order, even though they are the same. Maybe if they were generated alphabetically this would reduce the differences dramatically. I only did a tables compare, which includes the indexes and keys.
4 votes
Dual monitor support. I have two monitors at work and I wish Toad can utilize both of them. Just if you can drag&drop document windows on another monitor should be perfect!
2 votes
Auto-replace:Add an option to the SQL Versions Pick list for "SQL Server (Any Version)". Currently, if you want to have a custom auto-replace keyword work in any version of SQL, you have to manually populate that keyword for every version by selecting the version, then populating it. I'd like to see an "Any version" option added to the list that would always be checked regardless of the version of SQL (In addition ...more »
Auto-replace:Add an option to the SQL Versions Pick list for "SQL Server (Any Version)".
Currently, if you want to have a custom auto-replace keyword work in any version of SQL, you have to manually populate that keyword for every version by selecting the version, then populating it. I'd like to see an "Any version" option added to the list that would always be checked regardless of the version of SQL (In addition to the version-specific ones).
I use this feature for example to automatically capitalize keywords like SELECT FROM INSERT INTO IN WHERE HAVING, etc as I type them.
« less full details »
5 votes
When one or more rows are deleted in a data grid the cursor jumps to the first record. The cursor should be as close to the previous position as possible. Normaly the next record after the last deleted record should be selected...
2 votes
The window list lists all tabs that are open. However, it doesn't adopt the connection colors that is used on the tabs itself. The tab colors should be applied to the window list as well. (Either color the whole item or just mark them with colored bullets)
3 votes
please consider to:
Filetable
Contained Database
User Defined Server Roles
2 votes
Please consider adding the Identity declaration value to the Data type column in Object Explorer or making an optional column for same. It is just as important information as default value.
4 votes
When adding a constraint using the alter table window, I see that when adding a FK constraint, the ability to use the NOCHECK option is not there, the user has to export the generated SQL to the editor and alter the script to change it from CHECK to a NOCHECK.
4 votes
Will adding ordinal position column to the Columns pane of the Object Explorer be handy when managing tables and views?
3 votes
Allow for sorting ascending/descending while using the table viewer (order-by in filter window). Right now it defaults to ascending only, and you have to click on "custom sql" and put in the desc yourself. Toad for Oracle has this feature.
To Toad for SQL Server community
Social Web