385 results found
-
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 votesAdminDevart (_, 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.
-
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. -
Add option to save data into snapshot
Optionally, make it possible to save data into a snapshot.
4 votes -
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 -
Additional Relation Notation for Database Diagram
To show a 'many' relationship on the child side, a 'crow's foot' shape is used now. SSMS uses 1 and * (asterisk sign) to show one-to-many relation. So you can add similar notation to the Diagram Document Options. (Now there are two options available: IE and IDEF1X)
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 -
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 -
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 -
Add Pan mode to navigate
Add the ability to pan the schema using the mouse. Like we see on other product with the hand tool icon. It would be simpler then using the scroll bar or or mouse wheel with keyboard.
4 votes -
Data compare / Copy selected records with foreign keys into another DB
Please implement selective export of certain records and all related records in child tables (by foreign key).
Doing whole data compare in our case is estimated at 7.5hrs, which is too long for practical use.
This feature would be very useful in our reproduce/troubleshoot workflows, replacing whole DB backup/restore, which is roughly 150GB, times 2, to be moved over network.4 votes -
single quote auto close
In smss while typing a query single quotes create a closing one automatically the move the carret back inside the to quotes. Is there a way to set up dbForge Studio for SQL Server in order to get the same behavior?
4 votes -
Schema Compare /Sync log
Currently on the command line, the /sync option allows you to specify a file to write the sync script to, instead of executing immediately. When no file is specified, the sync is executed immediately. I would like a way to send the results of the sync operation to a log file of type .txt.
I think it would be beneficial to have a couple of different logging levels:
0 - verbose; each object start and stop time, warnings, and errors
1 - warnings; only objects causing warnings or errors to occur
2 - only errorsWarnings should include the object…
4 votes -
Extensions, plagins, add-in
Do you plan adding user extensions for the IDE (plagins) or some other mechanism to extend the functionality with external utilities?
For example:
- Using the external xml (you could include the editor), add an ability to add menu items (main, popup menu for a database, object, in the editor) where an external program with parameters will run (on a modal window) upon a click: current connection string (with a password, asking the user's permission), current database, current object type, current object name, etc.
A return code will tell what to do ( -1 - error, 0 -nothing to do, 1-update…
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 -
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 -
FULL SCREEN
usefull for coding
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
- Don't see your idea?