268 results found
-
Add filter for Object Search
Please add a filter to Object Search results like 'Display distinct names of objects only' (or similar),. That will help with searching objects (tables/views) that contain certain data, but not data itself. Say when I search for string 'rufhweirfi' in my a database, it returns me 4000+ rows from 58 tables, but I need only names of objects that contain such data. That would help with searching pairs master-detail in database that has no relationships for tables.
4 votes -
We really need the ability to backup and restore Azure SQL databases
SQL Server (non-Azure) makes it very easy to backup and restore. Not so with Azure. Even if we can't restore to Azure, it would be great to backup the database like any other SQL database, and restore it to a local SQL instance.
4 votes
AdminDevart
(_, Devart)
responded
You could use dbForge SQL Azure Backup http://www.devart.com/dbforge/sql/sqlazurebackup/download.html
-
Automatically Update Schema Cache when Editing Objects
When changing database tables or code with dbForge, auto-complete won't adapt to the changes until the cache is manually refreshed.
You can force a refresh using the Edit menu, Code Completion, then Refresh Local Cache. There's also a hotkey for this-- Control-Shift-R.
That said, when dbForge is making a change to an object, it should automatically update its cache for that object without us having to manually refresh the full cache.
This is also a suggestion for your MySQL product:
4 votesAdminDevart
(_, Devart)
responded
Please note that you can use the ‘Automatically refresh suggestions cache every xxx minutes’ option available in the ‘General’ branch of the ‘Options’ window that can be opened by selecting ‘Tools → Options…’ from the main menu.
-
Allow to group/organize Functions or Stored Procedures within folders created by the user. This way, it is possible to group by functionalit
llow to group/organize Functions or Stored Procedures within folders created by the user. This way, it is possible to group by functionality.
Over time these kind of objects pile up and become increasely difficult to manage.4 votes -
Rename Tabs
It would be very helpful to rename tabs, or at least provide a customisable format beyond the default. It's very hard to remember which SQLx.sql tab you need to switch to when you've got several open at once.
4 votesAdminDevart
(_, Devart)
responded
This feature is available in dbForge SQL Complete and can be setups as follows:
1. Select ‘SQL Complete → Options…’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘SSMS Caption’ section. -
One Database Diagram for All Sql Server
Like "Enterprise Architect" do it, But it UI design very Bad ,no friendly.
So, I Hope you can develop it.4 votes -
Interface / engine to work with SSIS / legacy DTS packages
Abitlity to view/create/modify SSIS packages
4 votes -
Faster Way to Export Database Diagram
I'd like a hotkey option to copy database diagram to my chosen default format, like PNG. I'm currently having 3-4 steps to simply save the diagram as a PNG. I'd also like the option to COPY TO CLIPBOARD AS: PNG, JPEG, ETC.
One additional thought, attaching a comment to a table, not free floating. Kinda like a visio diagram. That would be nice for helping improve speed of documentation.
4 votes -
jobs
Add ability to also search in SQL Server Agent Jobs for references to stored procedures, tables etc. to dbForge Search.
Redgate SQL Search has this functionality.
4 votes -
Comment / Un-comment a block of Code.
Frequently I have the need to comment or un-comment a section of my SQL code, e.g. a set of columns or a portion of a WHERE clause. It would be nice if I could select the block, right-mouse, and select comment/un-comment to place the "--" characters in front of the selected lines of code.
4 votes -
Add option to check before insertion if record already exists
Add an option allowing to check if a record already exists when adding identical record.
4 votes -
Hide Relationships
Ability To Hide Relationships On A Diagram
4 votes -
When adding a column to existing table with existing data, provide option to update the column to the default value for all existing rows.
In SQL it is possible, when adding a column with a default value to a table with existing data, to set the value of the column in the existing rows to the default value:
ALTER TABLE {TABLENAME}
ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL}
CONSTRAINT {CONSTRAINTNAME} DEFAULT {DEFAULTVALUE}
[WITH VALUES]I would like to select this option when adding a column to the table in the designer, and also be able to include the option when scripting the changes to the table - when a schema comparison is done, have the WITH VALUES option included in the script.
4 votes -
Please, make it possible to connect MS SQL help in dbForge.
Please, make it possible to connect MS SQL help in dbForge. Following this improvement need to use sql server management studio completely disappear.
4 votes -
Create Guid
Add a new menu item "Set Value To" -> "New Guid" in context menu when clicking on a cell (if the cell is type of uniqueidentifier).
3 votes -
Filtering code completion
When you filter the objects in the Explorer->Tables view
It only logical that the auto completion in the Sql script would be filtered too.Maybe an option inside Options -> Code Completion -> "Use filtering on objects" would allow the user to select the desired flavor.
If you have that option selected, when you do a filter in object explorer, when you are writing a sql sentence autocompleting tables, it only shows tables with that particular filter.
Thank you.
3 votes -
On the customer License Information page, add a user editable field where we can log who has which license.
I purchase the licenses for my dev team, so when I purchase two licenses, one for myself (SQL Tools) and a separate on for one of my devs (Schema Compare) I would like to indicate which is assigned to whom. Currently on the License information page, both appear assigned to me. While two folks is easy, if we grow our usage of your products further, I would like to know who I've assigned which licenses to, while keeping them all under the one account.
All I'm looking for is a field that I as the customer can note this type…
3 votes -
LinqPad-like Script Browser
LinqPad has one useful feature that could be used here in dbForge Studio too. It has a panel which shows folder structure of one specific scripts folder (configurable location). In this folder users can organize scripts into subfolders (projects). And by double-clicking on script in this panel you open the script. This folder can also be synced (via dropbox or other cloud drives) so you have same structure and scripts on multiple machines. This is a similar feature request as project workspaces. Could be easy to develop and would really help us who work on lots of projects and databases…
3 votes -
CSV - Support importing data that uses brackets for negative values into money fields.
It is fairly common in other tools/database (like Access for instance) for exported money or currency type fields to represent negative numbers by putting brackets around the value. Currently when such values are imported they give a truncation warning and put the value in as positive.
(10.00) should go in as -10.00 instead of giving a warning and going in as 10.00.
3 votes -
Database Diagram Foreign Key Improvements
The routed line that maps relationship of the table to the parent with a foreign key align the line drawn between them to the columns mapped, so that easy to visualize the exact FK column matching visually.
That an additional display option allowed. Instead of just CONSTRAINTS alone, offer a Foreign Key option. This pane at the bottom wouldn't be the name of the foreign key, but instead the myid - references Accounts(Id) This would make the documentation easier to use.
3 votes
- Don't see your idea?