379 results found
-
Generate CREATE script for filtered objects (e.g. Procedures)
Filter Objects in databse explorer and then select contecxt menu item to generate the CREATE script.
This would be much faster and easier to handle than the newly integrated Generate Script Wizard.9 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 -
If exists then add or create behaviour while generating sync script
Can you please add functionality for if not exists condition while generating sync script for tables and procedures.
for example : if db compare tools detects that a column needs to be added into other database in such a way that it will first check if that column does not exists in target table then only create that column.
and if exist procedure then drop and create procedure.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 -
More options to customize diagram
It's possible to have a fine grained control on several to render several element on diagram. For example now I see field with not null attribute with a font normal and field with Null attribute in Italic and not in black color but in gray.
Can we have full control on way this element be rendered?
Some times can help can change background of table box or header color to group related table that can appear anywhere on page without use the actual "container" feature.8 votes -
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 -
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 -
column mode
It would be nice to have a "column mode selection" or "vertical selection", just like the one existing on "Sublime"
7 votes
AdminDevart
(_, Devart)
responded
Could 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
-
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 -
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 -
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 -
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 -
Save Query as Object
While designing a query user should have possibility to save Query as Object - Microsoft Access approach.
Then user comes back to this query and re-use: execute or modify.
This would be advantage for those projects where user operates with similar entities.
Use Scenario: I create a query "Active Users", save this query.
Then I write another query which uses entity "Active Users". In my new query designed I drag and drop existing query as Table and e.g. join real table with "Active Users" entity.7 votes -
Ability to specify FROM and JOIN clauses when building complicated UPDATE queries in Query Builder
When building an UPDATE query in Query Builder, make it possible to specify the FROM and JOIN clauses in order to define source tables.
7 votes -
When I execute a Query, if the Results are hidden, I would like them automatically shown
When I execute a Query, if the Results are hidden, I would like them automatically shown.
7 votes -
Allow to enter which windows credentials to use
For example, I regularly work from home on a VPN from a non-domain joined machine. I would like to be able to able to type my domain credentials in so that I can authenticate as my Active Directory user.
6 votes -
Save Window Layouts
The ability to save and restore different window layouts
6 votes -
1 PDF per record export function in the Report-Designer
...including a "filename-builder" with query data:
[AddressID]-[InvoiceID]-[Date].pdf - for example
6 votes -
Relationship names on a DB diagram are not "comments". Need ability to show table descriptions independent of showing relationship names.
When "show comments" is selected, both table descriptions and the names of relationship lines are displayed. The relationship names are not comments, and mostly clutter up an otherwise clear and concise diagram. Show comments should only show table "comments"; a separate button/option is needed to display relationship names for those who want to see them (I do not).
6 votes -
Add status icon to tab when query is executing
When a query is executing for a long time, I sometimes switch to a different tab to continue other work. It would be great to have a status icon on the tab that shows whether a query is actively executing on that tab!
6 votes
- Don't see your idea?