267 results found
-
Ability to set path for storing *.design files
When a sql script is being edited and saved in same directory automated created *.design file. The *.design files in working directories is no good. I suggest to add ability set path for storing *.design files in separate directory. By default it can be temp directory.
12 votes -
Add option to hide schema as part of the table name in database diagrams.
Add option to hide schema as part of the table name in database diagrams. Since the new version 5.4 table name in database diagram show "SchemaName.TableName". Sometimes long table name get cropped so we have to extend the table's box to see the table name. Diagram need to be larger now... not good...
I'll go back to an older version for the time being.11 votes -
Sound notification at the end of long-runnig script
It would be very useful to have an option to enable sound notification of completion of long script execution (when it lasts for more than n seconds)
11 votesAdminDevart (_, Devart) respondedIn version 6.0, the feature Execution Notification is added. It’s managed by the ‘Environment → Documents → Notifications’ section of the ‘Options’ window (select ‘Tools → Options…’ from the main menu).
Will that be enough or should there also be an option to choose a file to play?
-
Retrieve Data select top n rows
Would you be able to change the 'Retrieve Data' context menu so that rather than doing a 'select * from table' it does a 'select top n from table' (where 'n' is a number I can configure).
I like having the retrieve data menu, but I avoid using it because with some tables it can lock up the system due to it selecting all rows (which can be millions of rows).
11 votes -
Multiline tabs
Please add multiline tabs. I often have many tabs and it's much easier to navigate between them visually (i know where is each of them) then with dropdown or arrows.
Also, please add more descriptive names in document tab names, something like SQL1.SERVERNAME.DATABASE, or options with parameters so that everyone can name tabs based on connection. Now everything is SQL1, SQL2, SQL3 regardles on which database I'm connected to (and I'm usually connected to more that one database). Coloring helps me to distinguish between development and production database, but it's not easy do distinguish between two or more production databases…
11 votes -
cyclic automatic query refresh
A cyclic automatic query refresh should be possible. I'm a developer and like from time to time to observe my data. An idea is to have some buttons to <refresh every second>, <refresh every five seconds> and <refresh every 30 seconds>.
10 votes -
Export Data multiple queries to single excel, pdf, html tables...
When you do multiple queries in a single SQL editor window, the results are tabbed down in the DATA window.
If you whant to export all of them to a single file (ex: excel2007), you have to export every single of them.And also if you add the requested feature of exporting the executed SQL sentence would be ÜBER! :)
10 votes -
Recent Files
Clear Recent Files (All) and single item by click right button
10 votes -
Auto-refresh before editing a view or table
When right-clicking a view or table, please have SQL Studio do a background "refresh" of the view or table before opening the edit window so the user can be assured of getting the current code or view. If I don't remember to hit F5 or 'refresh' I get old, cached data which can be very confusing and frustrating.
9 votes -
Enable Autofilterrow
Please enable Autofilterrow in gridviews!
(Feature from DevExpress)Regards
8 votes -
Vertical Guide Bar for Tabstops
Make an option for the editor to show vertical lines for each tab stop. On long scripts, I sometimes find myself putting a piece of paper up to the screen, which is of course silly.
It would be even better if the lines were distinguishable some way-- perhaps with a tiny number, or if you hovered over them, it could show a tooltip of the first few lines before the start of that indent.
8 votes -
Database Diagram Export to PDF
I'd like to be able to export the database diagrams to a pdf, or something more scalable when publishing my diagrams to my teams documentation library.
8 votesAdminDevart (_, Devart) respondedPlease note that you can export Database Diagram to one of the available formats with the ‘Export to Image’ feature available in the popup menu of the diagram. Please also see the following article http://blog.devart.com/how-to-save-database-diagrams-as-an-image.html
-
Add properties dialog and shrink option
Simple feature missing from dbForge Studio SQL - DB properties dialog, so I cannot, for example, view size of DB.
Also - a related feature - database shrink option is not there. Shrinking whole DB and/or just transaction logs is a common task in our workflow, to save space on DB server, after a backup was restored.Both features are present in MS SQL Management Studio. If dbForge is to replace MS tool, it must have these two features.
8 votes -
Query Builder Union Support
hi guys
a simple UNION like
SELECT TOP 10 contactnumber FROM contacts c JOIN addresses a ON c.addressnumber = a.addressnumber
UNION
SELECT TOP 10 contactnumber FROM contacts c JOIN addresses a ON c.addressnumber = a.addressnumberwill create an error "1 Not unique table/alias: 'c' Query.sql".
It would be nice to see the querybuilder processing these kind of sql's.
kind regards
peter8 votes -
Database Explorer - group connections by document category
It would be nice to have an ability to group our connections in Database Explorer by it's document category.
7 votes -
Customize TAB name in multi queries
On a multiple execution query, allow to customize the name of the results tabs, by default only shows the table name, useless if the tables are the same.
7 votes -
Comparing and synchronizing Views using a different schema-mapping doesn't work
When comparing and synchronizing views while using a different schema-mapping:
*) equal views are marked as different cause of the different schema in the view name and the different schema within the select -> please adapt the compare-logic to accept the correct displayed sqls as equal
*) the generated sql for updating views doesn't work because they contain the right schema (target) in the view name, but the wrong schema (source) within the select -> please replace objects with the source schema within the select of the view with the target schema7 votes -
column mode
It would be nice to have a "column mode selection" or "vertical selection", just like the one existing on "Sublime"
7 votesAdminDevart (_, Devart) respondedCould you please describe this in more detail and specify what functionality of dbForge it relates to? Screenshots would be also of help.
You can reply straight to our support system at supportATdevartDOTcom
-
The ability to save a set of scripts as a project or a solution.
Allow the grouping and saving of scripts into a project or solution. This would allow the grouping of related scripts into a single file set that can then be opened more easily. This would also allow a developer to more easily keep scripts related to a specific job synchronized and loaded.
For example, loading the Paycheck project will load all of the scripts related to the Paychecks task. Then, by loading the Employee project will switch out the scripts with the ones for the Employee task.
7 votes -
Have a count on the number of filtered records on the result grid
When analyzing data I often filter the result grid from a query to see how many records there based on certain conditions. The problem is that it doesn't show the number of records after the filter has happened. I then usually export to Excel and then count it that way which is not that productive.
7 votes
- Don't see your idea?