To Toad for SQL Server community
64-bit Toad
Would you like 64-bit Toad to be available?
Browse Popular Ideas
-
I agree
9 votes
This idea is active.General & Installation »6 comments for Idea: 64-bit Toad -
I agree
8 votes
This idea is active.SQL Editor »Execution Plan should work with variables
3 comments for Idea: Execution Plan should work with variablesExecution Plan should work with variables.
Test SQL: select 'test' where '' = :par1
-
I agree
6 votes
This idea is active.SQL Editor »Fast code completion
1 comment for Idea: Fast code completionI wish my code completion come up with suggestion faster
-
I agree
6 votes
This idea is active.General & Installation »Toad should remember all print settings for an active session
1 comment for Idea: Toad should remember all print settings for an active sessionToad should remember all print settings for an active session and active editor (data grid), so that repeat printouts for that same data grid/editor/session don't have to be configured from scratch each time the data is reprinted. This would include margins, header setup, and footer setup.
-
I agree
6 votes
This idea is active.SQL Editor »Code completion in UPDATE..SET..FROM
3 comments for Idea: Code completion in UPDATE..SET..FROMToad should support code completion in UPDATE..SET..FROM
For example, code completion for:
UPDATE x
SET foo=123
FROM Bar x
should work the same as for:
UPDATE Bar
SET foo=123
Toad should support code completion for joins in FROM statement:
UPDATE x
SET foo=123
FROM Bar x JOIN Bar2 y ON x.id=y.xid
WHERE y.foo2 = 234
-
I agree
5 votes
This idea is active.Session Browser »Make session browser more nice and intelligent
Add your comment for Idea: Make session browser more nice and intelligentI want to see more charts and display deadlocks info
-
I agree
5 votes
This idea is active.Import/Export data »One click export should remember last save location
Add your comment for Idea: One click export should remember last save locationPlease make Toad remember the last save location for one click export (I mean right click on grid > Quick export > File). Default foder for one click export is always "my documents" in XP. This is annoying.
-
I agree
4 votes
This idea is in review.Just something cool or urgent »Report settings used from printer...
1 comment for Idea: Report settings used from printer...Reports should adapt to printer settings. In Europe we don't have "Letter"-Size Paper! We use DIN A4 as stanstd paper. Each Report can only printed after the paper size has manual changed. And this each time a report is printed...
-
I agree
4 votes
This idea is active.SQL Editor »Support of syntax in the Code Completion
2 comments for Idea: Support of syntax in the Code CompletionHello!
I need support of syntax in the Code Completion.
It will help me in the code writing.
-
I agree
4 votes
This idea is active.Import/Export data »Import and Export - XML file
Add your comment for Idea: Import and Export - XML fileThe XML file (.tim) should allowed to edited on the Toad editor, so that minute changes can be made. Currently I do this outside of toad and it is time to allow for easity edits of these file types.
-
I agree
4 votes
This idea is in review.Import/Export data »Importing Column - Add new Field should allow for any position
Add your comment for Idea: Importing Column - Add new Field should allow for any positionThe Import wizard allow for the addition of a new field, but it doen't allow the new field to placed in a different column location. Therefore this is either a bug or a new feature.
-
I agree
4 votes
This idea is active.SQL Editor »Omit "Editor ...", "Viewer ..." from tabs
2 comments for Idea: Omit "Editor ...", "Viewer ..." from tabsNow in 5.7 beta, tabs have icons on them. Editors have a notepad icon, viewers have a magnifier icon and so on. I suggest that you omit the words "Editor ..." or "Viewer ..." from the tabs to save screen real estate. The user can already tell if the tab is an editor or a viewer by looking at the icon. However for the tabs that are less frequently used (e.g. Data diff viewer) you should keep the name.
-
I agree
4 votes
This idea is active.Import/Export data »Import data from any ADO/OLE-DB data source
Add your comment for Idea: Import data from any ADO/OLE-DB data sourceIn the past I have the problem to import datas from others DB's, for example Ms-Access and now I don't see in your import wizard this feature.
It's more important and useful for DB admin or DB developer, import data from any other data source, for example Access,MySQL,Firebird, etc,etc,...
-
I agree
4 votes
This idea is active.Import/Export data »Export to EXCEL - allow formatting
Add your comment for Idea: Export to EXCEL - allow formattingIt would be wonderful to be able to tell EXCEL that a column is a date or a number or text prior to exporting. Also a checkbox for autofiltering would be nice.
-
I agree
4 votes
This idea is active.Data Compare »Optional Identity Insert By Table
When generating the scripts for the data compare, there is an option to turn on/off "Exclude Identity Columns". In my particular scenerio, I have some tables that need the identity columns included, then I have others that do not need them. I know that the generated script can be edited manually, but I think it would be nice to be able to specify (optionally, of course) the Exclude Identity Columns on a per table basis ...more »
Add your comment for Idea: Optional Identity Insert By TableWhen generating the scripts for the data compare, there is an option to turn on/off "Exclude Identity Columns". In my particular scenerio, I have some tables that need the identity columns included, then I have others that do not need them. I know that the generated script can be edited manually, but I think it would be nice to be able to specify (optionally, of course) the Exclude Identity Columns on a per table basis or for the entire script.
« less full details »
-
I agree
4 votes
This idea is in review.Object Explorer / Schema Browser »Quick Jump To Column In Viewer Table Using Object Explorer
I would like to see the following (only because it drives me crazy) - Under the object explorer using the tables tab, when a table is selected you get a list of fields below. I use this to see what the proper name of a field is or to see if a field exists. And if it exist I'll use the viewer table to find the column to see some values. I could use a select statement to do this but at times I want to see everything. I ...more »
4 comments for Idea: Quick Jump To Column In Viewer Table Using Object Explorer
I would like to see the following (only because it drives me crazy) - Under the object explorer using the tables tab, when a table is selected you get a list of fields below. I use this to see what the proper name of a field is or to see if a field exists. And if it exist I'll use the viewer table to find the column to see some values. I could use a select statement to do this but at times I want to see everything. I drives me crazy to horizontally scroll a table (350+ fields) to find a column (this is what I've inherited - NO normalizing whats so ever).
If you could allow a double click on a field in the object explorer the viewer table would go to the selected field(column) automatically - this would be very convenient.
Thanks!
Dan Borden
« less full details »
-
I agree
4 votes
This idea is active.Just something cool or urgent »SQL Server Compact Support
2 comments for Idea: SQL Server Compact SupportIt would be great to have support for SQL Server Compact Edition. SQL Server Management Studio 2012 dropped support for this, and the tooling built into Visual Studio is awful. Compact Edition may not be as commonly used as the full versions, but for those who have a need for embedded databases, even limited support in a proper tool like Toad would be fantastic.
-
I agree
3 votes
This idea is active.Just something cool or urgent »Add Code Snippits for DMV (2008 R2 and beyond)
Add your comment for Idea: Add Code Snippits for DMV (2008 R2 and beyond)DMV are becoming quite popular and have a tab or groups or snippit section of DMV (Dynamic Management Views) would elevate Toad-SS into the next level already being explored by othe vendors such as RedGate and Ideara
-
I agree
3 votes
This idea is active.Data Compare »Generate Test Data
Add your comment for Idea: Generate Test DataI need to generate test data for set of the tables. I need it on frequent basis, please consider to add this feature in Toad.
-
I agree
3 votes
This idea is active.Just something cool or urgent »Asynchronous batch processing
Add your comment for Idea: Asynchronous batch processingAllow the ability to process sequential batch section in a script file in asynchronous as well as sequentially. This is like a ETL process where you have the horse power to process alot, but you don't want to segregate the batches into seperate editor sessions.
-
I agree
3 votes
This idea is active.SQL Editor »Enable Horizontal Scrolling with Tilt Wheel Mice
Add your comment for Idea: Enable Horizontal Scrolling with Tilt Wheel MiceEnable Horizontal Scrolling with Tilt Wheel Mice that include this feature.
For some reason the horizontal scrolling features of Microsoft Intellipoint tilt wheel mice do not seem to work in the Toad Editor Window. Add support for that.
-
I agree
3 votes
This idea is active.Object Explorer / Schema Browser »Displaying connection info in the Object Explorer
Add your comment for Idea: Displaying connection info in the Object ExplorerWould you like to see connection info at the top of the Object Exporer pane?
If you consider it helpful, please vote for this idea so it can implemented in future releases.
-
I agree
3 votes
This idea is active.General & Installation »Converge Idea Pond and all community pages into a single one
I just got to know about "Idea Pond". I appreciate the effort to keep track of feature requests in a better way, but I think the community sites for Toad are already way too fragmented. - For Support: Mailing groups or toadworld (toadforsqlserver.com) - For Bugs: Quest support (why should anyone bother filling in that crappy webform in order to be able to report a bug?) - For Feature requests: Idea Pond - And also for ...more »
3 comments for Idea: Converge Idea Pond and all community pages into a single oneI just got to know about "Idea Pond". I appreciate the effort to keep track of feature requests in a better way, but I think the community sites for Toad are already way too fragmented.
- For Support: Mailing groups or toadworld (toadforsqlserver.com)
- For Bugs: Quest support (why should anyone bother filling in that crappy webform in order to be able to report a bug?)
- For Feature requests: Idea Pond
- And also for other Toad variants (Oracle, DB2, Mysql, ) totally separated communities (which makes sense to some extent)
I just don't understand why you just don't merge all these stuff in a single environment like launchpad or something similar.
« less full details »
-
I agree
3 votes
This idea is active.SQL Editor »Allow multiple rows in tab bar
3 comments for Idea: Allow multiple rows in tab barI usually have many editors open at the same time. To avoid scrolling right/left each time I want to change the tab, I suggest that you provide an option to allow multiple rows for the horizontal tab bar. Of course I can always use the window list, but then I need two clicks each time I change to another tab.
-
I agree
3 votes
This idea is active.SQL Editor »Configure Code Formatter By Example
Make it easier to configure the code formatter. Some ideas: 1. Make the code example in the preview pane a COMPREHENSIVE example (i.e. the minimum number of cases of different SQL constructs that would illustrate the current formatting configuration.) 2. Possibly make this a separate dialog or screen so that one could see the effects in the preview pane in realtime as one changes the custom configuration. 3. Consider ...more »
1 comment for Idea: Configure Code Formatter By ExampleMake it easier to configure the code formatter.
Some ideas:
1. Make the code example in the preview pane a COMPREHENSIVE example (i.e. the minimum number of cases of different SQL constructs that would illustrate the current formatting configuration.)
2. Possibly make this a separate dialog or screen so that one could see the effects in the preview pane in realtime as one changes the custom configuration.
3. Consider building a "Format Analyzer" that reads a template file. You'd supply the user this template file containing a set of SQL constructs and different cases that the user needs to consider. The user would manually format a copy of the template using whatever editor they like (TOAD, or something else) and make it look like they want it. Then feed it to the Format Analyzer which does its best to produce a configuration that would produce that formatting.
When the analysis is done, it should produce a report of the settings it chose, and why, and a machine-formatted output of the configuration template so the user can compare their input with it.
== Obviously there are a lot of ways this feature could "go wrong," but don't dismiss the idea yet! ==
If the user deletes stuff, or moves it around, or adds extraneous things to the template so the analyzer has trouble working, scold the user for doing that (!!) :-) and tell them to try again from a clean copy of the template. (Ease of use doesn't come for free and no SQL developer in their right mind should expect the program to exhibit human understanding!)
The analyzer may find 2 different values for a setting, neither of which exactly reproduce the user's formatting, but both of which are pretty close. Choose 1 arbitrarily and, when done, create a report window (or some kind of output) listing these pairs of choices, including what the setting is, what the 2 choices were, and what the unchosen alternative would have produced.
It is conceivable the analyzer might be forced into a mutually-exclusive pair of choices if the user's formatting is creative enough. (Maybe they right-aligned keywords everywhere except in one or two places, for example?) Again, do the same treatment as above: choose 1 arbitrarily and report on the either/or choice and why the user's example forced this.
« less full details »
Social Web