400 results found
-
Add Test mode for SQL
I used to work with Apex SQL where there was test mode. This is a very simple, but convenient feature. There was a button "Test Mode" beside the "Execute Script" button. The button had two states - pressed and unpressed. Clicking the button added two rows. "BEGIN TRANSACTION" was added at the beginning of the script and "ROLLBACK TRANSACTION" was added at the end. When unpressing the button, the two rows disappeared.
2 votes -
Provide a way to disable auto-commit mode.
When auto-commit is turned off, your DML is always embedded in a transaction, without a commit or a rollback. Then, make it clear that there is an open transaction, and provide a commit and a rollback button. Many other tools provide this important feature
2 votes -
Bulk data type adjustment for external import
When importing data, there needs to be a way to adjust the data type for multiple fields at the same time. I can select multiple fields and choose edit, but after adjusting to varchar(255), the data type only changes for one of the selected fields at a time. I have 134 fields to set the data type to varchar(255). I don't have time to set the data type for each field. Very frustrating and unproductive. I can't use this product until this feature is added.
2 votes -
Clone data comparison window
There are times that you may wish to perform two similar structure or data comparisons. It would be useful if when right-clicking on the tab of a data comparison window, in the context menu that appears, there was a "clone" option. This would generate a clone of the existing structure/data comparison window containing the exact same options of the original window. Then you would be able to just alter the few options you wish and perform the new comparison in the new window, without destroying the comparison that exists in the original window.
2 votes -
When I reformat the document it doesn't put Aliases, Table Names or Column Names in [] even though I have that option on.
When I reformat the document it doesn't put Aliases, Table Names or Column Names in [] even though I have that option on.
Formatting should enforce the rules I have in place. I want Table Names, Column Names, Aliases all enclosed in [].
2 votes -
Generating Scripts with per table schema<->data selection
When selecting objects to script, there are global checkboxes for Schema and Data. I'd like to see two columns in the tree-list of objects, where I can individually mark a table for just schema or just data, or both (default)
2 votes -
Script Object as Create / Alter (ctrl- F12) into named tab instead of no name
After Script Object as Create / Alter (ctrl- F12) please name the new tabbed window with the scripted object's name instead of SqlQuery99.sql.
And also please make this forum easier to search.
I can't believe nobody asked for this feature before, but I couldn't find an existing item to upvote.
I hate duplicate tickets just like anyone!2 votes -
Order by
In data comparison window, you can filter a table (WHERE) but you cannot sort the data shown on the resulting grid after the data comparison (ORDER BY).
1 vote
AdminDevart
(_, Devart)
responded
To perform comparison, dbForge reads out data to the cache. It can’t sort the data, because, to display in the resulting grid, dbForge reads the data from the cache upon scrolling and doesn’t keep it in the grid in order to avoid out of
memory errors. -
Hi. I suggest to add the feature for select only a database, on Connection Properties.
Include the option for to open only the connection with database specified.
1 voteAdminDevart
(_, Devart)
responded
This option is added. Please upgrade to the latest product version https://www.devart.com/dbforge/sql/studio/download.html
-
About comments in view
How do I enable comments display in the editing view?
1 voteAdminDevart
(_, Devart)
responded
Could you please clarify this?
Please also let us know whether you are able to perform this with, for example, SSMS?
-
Object Search/Find
in the drop down for the Database Connections that list the connections to sql server and databases, please give an option for search ALL. we use 4 sql servers with views that point back to other servers. (Linked Servers)
thx
1 voteAdminDevart
(_, Devart)
responded
Could you please provide us a screenshot of where exactly you would like it to be present?
You can send a reply straight to our support system at supportATdevartDOTcom and alexaATdevartDOTcom
-
Don't resize DBForge when I drag (for example to move to a different monitor)
When I click the header of DBForge and start dragging, the window minimizes. When I'm dragging it to another monitor, I must then maximize the window. Please leave the window size where it is set.
1 voteAdminDevart
(_, Devart)
responded
Could you please let us know what screen DPI you have set for both the monitors?
-
Close tabs with Ctrl + W
When run a script there are to much open tabs, close the tabs with Ctrl+W will be easy for mayor order.
1 voteAdminDevart
(_, Devart)
responded
Could you please describe it in more detail? A video or screenshots would be also of help.
-
1 voteAdminDevart
(_, Devart)
responded
Could you please describe this in more detail?
-
Schema comparison ignore users
Add the ability to ignore Users in Schema Comparison.
1 vote
AdminPMs
(Admin, Devart)
responded
This can be performed as follows https://docs.devart.com/schema-compare-for-sql-server/reviewing-the-comparison-results/using-object-filter.html
-
1 vote
-
debug and unit test support with local variables
Within SQL Server Management Studio 2012, while debugging and stepping through a stored procedure source code many levels deep, one has access to the local variables pane. That pane shows variable name, value, and then type. That pane is so close to being helpful, yet it falls short by having the value and type in the wrong order.
It would be great to be able to copy the whole local panel and paste that as source to an editor as DECLARE @<variable name> <type>=<value> for each of the local variables.
That would greatly facilitate recreation of the cases that one…
1 vote -
Ability to select objects to print on Query Profiler Plan Diagram
Though I can selet objects in the plan, I cannot "Select all" by using Ctrl-A, to print just a part of the plan.
1 vote -
1 vote
-
Align the equal signs in the SET block of UPDATE statements
It would be nice if SQL Formatting for UPDATE statements could align the equal signs in the SET block, this would make for a very readable and clean SQL statement.
1 vote
- Don't see your idea?