301 results found
-
Selectively disable connections
Currently I have 10 production servers and a couple of dev/test servers added to my Database Explorer, it would be awesome if there was an option to manually DISABLE/ENABLE a server entry. That way I have extra protection agains accidentally running a script on the wrong db.
3 votes -
Make the restore database have the option to ignore errors
Make the restore database have the option to ignore errors, so easy can fix minor mistakes without having to redo the backup
1 vote -
drag and drop column names into query
Multi-select column Names (works).
Drag and drop as a COMMA List in the SQL Editor (does not work)Even better, if the SQL Text area is empty or being dropped after a ; with no open SQL statement, include "Select " + $fields + " from " + $table with it!
4 votes -
Make possibility to display on the diagram stored procedure call from another of procedure in order to see the relationship between them
I have a complicated database. The procedures call each other. It is necessary to visually see the relationships between them
3 votes -
Peek overview of Views, functions, and stored procedures.
when you type in a query window and you have the following types of database objects are returned: Views, Functions, and stored procedure. It will be a great feature to have a view of the code of the object.
This way it will be easier to find out which Stored procedure or view to change by simply hovering over the database object instead of going to the defintion and right click and select modify.
3 votes -
Create T4 Templates for WebAPI.
It would be great if there were T4 templates for generating Microsoft WebApi endpoints reather than MVC controllers. MVC is ok but amI, as I a im sure more and more developers are, creating client apps which access data via web apis or similar. Of course the advantage of this it that these webapis dont care what the client is and the client dosent care what is behind the webapi.
1 vote -
Save layout of stored procedure editor
It would be nice if the default view for stored procedures was "what I used last" rather than "half a screen of parameters, even when there are no parameters".
Admittedly I have quite a few stored procedures with long lists of parameters (because MySQL/ConnectorC++ is horrid), and even for those I would rather see the default view have the splitter dragged up to hide the "parameters" text.
I spend most of my SP editing time dealing with longer, more complex stored procedures, and having to constantly drag that splitter back up so I can have most of a screen of…
3 votes -
Show hint with database object comment in the Database explorer
Hello, guys!
I like to write comments for my objects and it will be helpful if comments will be shown in the hint on mouse hover on the database object in the Database explorer.3 votes -
Folder/group feature for Database Explorer?
Would it be possible to add a group/folder feature to the connection explorer, so connections can be organized?
209 votesAdminDevart (_, Devart) respondedPlease note that you can assign one of the available document categories with colors to a connection as follows:
1. Right-click a connection in Database Explorer and select ‘Modify Connection…’ from the popup menu. The ‘Database Connection Properties’ dialog opens.
2. Switch to the ‘Connection’ tab.
3. In the ‘Document Category’ drop-down menu, select one of the available options or add a new one by clicking the three-dotted button. -
Selected colums to clipboard
It would be nice to have a possibility of copy into the clipboard all selected column names from a table or view.
It's really weary to copy them on by one.1 voteAdminDevart (_, Devart) respondedCould you please clarify whether you were referring to the Data Editor or Table Editor functionality?
-
Disable foreign keys when deleting or truncating table
When deleting or truncating a table I would like to have the option to disable foreign key checks for this operation. This could be a simple check box which is unchecked by default.
If foreign keys are present, I either have to drop the database and recreate the whole schema or delete one-by-one figuring out the correct order or I have to write an SQL script with a lot of drop table statements and surrounding them with the foreign key checks setting.
This is cumbersome, especially for development purposes when I have to clear test data very often or deploy…2 votes -
data comparisons, use foreign keys, save script
In Data comparison wizard there is the oppotunity to filter a table.
1. I want to create a Dump for only one Person-Dataset with all datasets of other tables that have a relationship to this person using foreign keys.
2. I want to save this script to reuse for other Person-IDs1 vote -
Ability to group objects by prefix in Database Explorer
For instance, several tables (views, procedures, functions, etc.) have
identical prefix. So, it would be convenient to have these objects separated
into the following, let's say, two groups:
1.
Tables
--prefix1
---- table1
---- table2
......
--prefix2
----table1
---- table2
Views
--prefix1
----view1
---- view2
......
--prefix2
----view1
----view2
2.
prefix1
--Tables
----table1
----table2
......
--Views
----view1
----view2
......
prefix2
--Tables
----table1
----table2
......
--Views
----view1
----view220 votes -
1 vote
-
Allow to switch float number decimal point from ',' to '.' in GUI. Countries other from Russia do not use ',' as decimal point
Allow to switch float number decimal point from ',' to '.' in GUI. Countries other from Russia do not use ',' as decimal point
1 voteAdminDevart (_, Devart) respondedThis setting depends on the locale of your operating system and can be changed in the ‘Region and Language’ section of your Windows settings.
-
Backup all databases
A backup for all databases (or choosen) will be useful. These function should be startable from the windows task planer for a good backup strategy.
36 votes -
SQL History: log in plain mode without parameter
I know that in SQL LOG dbforge could store ALL query sent to DB. It would be great if dbforge stored them in plain form with parameter already substituted (not with :p1, :p2 .. and so on)
5 votes -
Allow per column, per table grid display configuration
We work with tables that need to display the data in a format that is meaningful to us. Default display in grids doesn't cut it these days.
Allow us to add custom display formats for any field including binary. This could be done by maintaining a small embedded database per table and column. Then allowing a dialogue to select or enter new formats.An extension to the configuration dialogue for date time display could be a starting point.
Once done, this configuration can be applied to any column and any table.
Doing this would instantly cure all the feature requests…
1 vote -
Toggle USE <database> statement
Hello,
I'm currently looking into available tools to perform DDL and DML comparison from the command line for an automation project of database continuous delivery. So besides a tool running from the command line it also needs to be able to generate the necessary scripts.
After a day of playing around with both dbForge schema and data compare, everything is looking fine and they seem to be good candidates for this project.
Unfortunately I'm currently stuck with one challenge. As the comparison phase is only done once, in the beginning of the automation chain, the generated scripts need to be…3 votes -
restrict the restore option
if any of the users accessing or using the database please restrict the restore option.
35 votes
- Don't see your idea?