How I can I monitor last 100 queries for a particular DB1 vote
How do I save the DB connection ...similar to how I can register servers in SSMS. Thanks1 vote
If a DML query contains an error, the file is not saved. It is absurd to have to go into Notepad to save a file.1 vote
Hi, we use a lot of json caluses in our db procedures e.g.:
"ParcelId" int '$.ParcelId',
"ParcelTypeId" int '$.ParcelTypeId',
"ShipmentId" int '$.ShipmentId',
"BarCode" nvarchar(100) '$.BarCode'
Why don't You prepare such a helper in dbForge Studio ? It could be located on the level of "Generate script as" menu for each table for instance. To have the possibility to prepare our own plugins would be also a good idea.1 vote
Database Explorer doesn't include System Procedure folder which would be great to have.
Capacity to copy a code snippets to create a new one.1 vote
When a value is changed in the Data Editor, the Data Editor logic compares the value with the existing value and makes a decision whether to update the existing value based on whether the new value is considered different. Currently, this equality comparison is case insensitive, which is a bug. It must be case sensitive. SSMS will update data based upon consideration for case sensitivity, but not the Data Editor.1 vote
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.1 vote
The "Add related tables"-function (same as in SSMS) is very useful when creating a database diagram from an old database.1 vote
would it be possible to add a RegEx search in the script to automatically rename the tabs
Show somewhere (the status line at least or perhaps in a new status window) the percentage of commands of a script that has been executed.1 vote
Please add a space automatically after accepting an intellisense suggestion.
For example after a table name, when typing "w", "WHERE" appears, when hitting tab it adds that word to the text area, yet I need to then manually add a space. Why not add it as part of the intellisense (as we're used with VS) so I can simply keep on typing seamlessly?3 votes
Typing "order" after a table name brings up the intellisense with "ORDER BY", yet when hitting tab to accept, only "ORDER" gets entered in the text area, the only way to get both words is by hitting Enter. Why not on tab like I'm used to?3 votes
Since V.6.0.563 in the diagram fonctionnality, the Container's title and the stamp's text color are white, resulting in very hard to read titles for the containers and impossible text to read in stamps.21 votes
When we go to a new customer site for an install, we typically get connected to the network, open schema/data compare for a deployment and then add a new connection. The problem is when we go back to that site (or remote connect in), it can be tricky to find the connection for the customer.
Can we have something in the connection manager to arrange the connections in alphabetical order so they are easier to find?3 votes
It would be great if the system would automatically refresh an object when you open it to edit. SSMS does pulls the current version, but this system just opens the cached version. This has cost me hours over the time I've used this product. One example use case:
- Right click a stored procedure > modify
- Make changes
- F5 to run update script
- Close window
- Sometime later, repeat and you get the version that was from before you made the first changes.
Add the ability to ignore Users in Schema Comparison.1 vote
This can be performed as follows https://docs.devart.com/schema-compare-for-sql-server/reviewing-the-comparison-results/using-object-filter.html
There are times that you may wish to perform two similar structure or data comparisons. It would be useful if when right-clicking on the tab of a data comparison window, in the context menu that appears, there was a "clone" option. This would generate a clone of the existing structure/data comparison window containing the exact same options of the original window. Then you would be able to just alter the few options you wish and perform the new comparison in the new window, without destroying the comparison that exists in the original window.2 votes
Like in Management Studio, I would like to be able to see the Execution Plan of my query.3 votes
This is already present in dbForge https://docs.devart.com/studio-for-sql-server/optimizing-sql-queries/working-with-plan-diagrams.html
When using the "Truncate Table" feature on a table which has an active table lock, dbForge completely freezes up and ultimately crashes. The app should "gracefully wait" rather than crash.3 votes
Could you please specify what product version you are using?
Please also provide us a screenshot of any possible error and perform the following:
1. Select ‘Tools → Options…’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Environment → Output’ branch.
3. Select the ‘Write queries sent by the program to the SQL Log’ and ‘Log application errors’ options.
4. Unselect the ‘Delete application log after closing’ option. Click ‘OK’.
5. Reproduce the issue and send us the *.log file with the latest date from the folder:
SystemDrive\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for SQL Server\
- Don't see your idea?