To Toad for SQL Server community
Schema Compare report to include detailed comparison result.
Schema Compare report to include detailed comparison result. Currently this is only a summary report. Request to include comparison result for each object as well.
Browse Recent Ideas
-
I agree
0 votes
This idea is active.Schema Compare »Add your comment for Idea: Schema Compare report to include detailed comparison result. -
I agree
2 votes
This idea is active.Object Explorer / Schema Browser »Default Value Constraint Name
I have been unable to locate a way to rename a constraint for a default value and that the values that are being created are generally different from server to server since it is creating random characters at the end of the constraint. For Example: [DF__MyTable__lastM__5A30FF58] I would really like a way to name the constraint during creation or at least a way to rename the constraint that was created. I am always ...more »
4 comments for Idea: Default Value Constraint NameI have been unable to locate a way to rename a constraint for a default value and that the values that are being created are generally different from server to server since it is creating random characters at the end of the constraint.
For Example: [DF__MyTable__lastM__5A30FF58]
I would really like a way to name the constraint during creation or at least a way to rename the constraint that was created. I am always have to watch scripts that get created with the schema change to make sure that values with those random characters are not in it, otherwise the script will fail on remote servers since they are generally different.
« less full details »
-
I agree
2 votes
This idea is active.Just something cool or urgent »Schema column needed in Object Search results
Add your comment for Idea: Schema column needed in Object Search resultsA "schema" column in the results window of the Object Search would be great. Currently, you can't differentiate between objects with the same name appearing in different schemas within the results.
-
I agree
2 votes
This idea is active.SQL Editor »Transpose / Pivot Results
When working with tables that contain hundreds of columns but few rows, it is better to look at the data transposed with each column name as a row and with each row as a column. Basically, the equivalent of exporting the data to Excel, selecting it, and choosing paste, transpose. The card view in Toad was an attempt at doing that, but it fails miserably because: 1. It repeats the column names on every "card" -- ...more »
1 comment for Idea: Transpose / Pivot ResultsWhen working with tables that contain hundreds of columns but few rows, it is better to look at the data transposed with each column name as a row and with each row as a column.
Basically, the equivalent of exporting the data to Excel, selecting it, and choosing paste, transpose.
The card view in Toad was an attempt at doing that, but it fails miserably because:
1. It repeats the column names on every "card" -- wasting valuable screen real-estate.
2. It does not contain a vertical scroll bar, so if there are hundreds of columns, there's no practical way to get to them.
Desired: a new option on in the Results Window: Right-Click: Show: menu that reads: "Transposed View".
When selected, users would see data with the column names in the first column (frozen in place). Scrolling vertically displays the other columns, scrolling horizontally displays the other rows but keeps the column names visible.
« 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
1 vote
This idea is active.Import/Export data »Kamran
2 comments for Idea: KamranROW NUMBER SHOULD BE PROVIDED FOR SQL SERVER 2000 DATABASE WHILE MIGRATING DATABASE FROM LEGACY SERVERS TO NEW
-
I agree
3 votes
This idea is active.Import/Export data »Progress Bar When Selecting Large Text Files
Add your comment for Idea: Progress Bar When Selecting Large Text FilesWhen selecing a very large Text files, Import Wizard seems to be in a wait state while it analizes the file. This can take several minutes and to the user has no idea if it is performing the task requested. Eventually, the screen will go white for a time before it returns with information about the file. A Progress Bar or just a message telling us that it is "Analyzing file..." would be helpful.
-
I agree
1 vote
This idea is active.Just something cool or urgent »SVN - include Drops part
Add your comment for Idea: SVN - include Drops partHi,
it would be wonderful to have an option in version control that add the Drop section @ Check in) e.g.
/// IF exists (select * from sys.views ....
begin
drop view...
///
This option still exists in ObjectDetails -> Tab: Script
-
I agree
2 votes
This idea is active.Object Explorer / Schema Browser »View/Edit - Extended properties from columns
2 comments for Idea: View/Edit - Extended properties from columns
It would be wonderful to edit the extended properties from columns (tables/views).
-
I agree
1 vote
This idea is active.Object Explorer / Schema Browser »Script generation - Extended Properties from columns
1 comment for Idea: Script generation - Extended Properties from columnsAdd the ability to append also the extended properties from columns (tables / views).
--> Object Details --> Tab: Script --> Script Options: Extended properties
-
I agree
3 votes
This idea is active.Just something cool or urgent »Schema Repport should be more flexible
1 comment for Idea: Schema Repport should be more flexibleThe schema report should be more flexible in the following cases:
- remember the last settings
- configure the look of the report (not only what it contains)
- allow to add page breaks (f. e. I like to have one table per page...)
- remove the numbers in front of the fieldnames (this numbers make the report hard to read...)
-
I agree
1 vote
This idea is active.Just something cool or urgent »Health Check Reports
2 comments for Idea: Health Check ReportsI would like to see Health Reports for SQL Server similar to what we have in TOAD for Oracle.
-
I agree
1 vote
This idea is active.Just something cool or urgent »Mercurial DVCS Support
Add your comment for Idea: Mercurial DVCS SupportNeed support for Mercurial version control. Bitbucket, Kiln, local etc.
-
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
2 votes
This idea is active.SQL Editor »Table Description
To all: I recently was asked to come up with a simple script to describe a table/view column and is most useful ddl attributes. The below uses the INFORMATION_SCHEMA.COLUMNS which I happen to like for this purpose. It is very fast and very useful, I have submitted this to the Toad-SS idea pond so as to share the code. TDA and SQL Server user should give it a try. select table_name, Table_Schema,column_name, Ordinal_Position ...more »
Add your comment for Idea: Table DescriptionTo all:
I recently was asked to come up with a simple script to describe a table/view column and is most useful ddl attributes. The below uses the INFORMATION_SCHEMA.COLUMNS which I happen to like for this purpose.
It is very fast and very useful, I have submitted this to the Toad-SS idea pond so as to share the code. TDA and SQL Server user should give it a try.
select table_name, Table_Schema,column_name, Ordinal_Position
,DATA_TYPE
, isnull(cast(character_maximum_length as varchar(15)) ,'NA') as 'Char_Length' --- So as not to return nulls values.
, isnull(cast(NUMERIC_PRECISION as varchar(15)) ,'NA') as 'NUMERIC_PRECISION' --- So as not to return nulls values.
, isnull(cast(NUMERIC_SCALE as varchar(15)) ,'NA') as 'NUMERIC_SCALE' --- So as not to return nulls values.
, IS_NULLABLE
, isnull(cast(Column_Default as varchar(15)) ,'NA') as 'Column_Default'
from INFORMATION_SCHEMA.COLUMNS a
where table_name = 'MeterInventory' -- order by 3
« less full details »
-
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
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 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
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 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
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 »Make the tab bar scrollable
Add your comment for Idea: Make the tab bar scrollableMake the tab bar scrollable. Scrolling up/down using the mouse wheel on the tab bar should shift the tabs left/right. (this can replace the two arrows on the right hand side)
-
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 »
-
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
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
Social Web