381 results found
-
Prevent dbForge from crashing when truncating a locked table
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 votesAdminPMs (Admin, Devart) respondedCould 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\ -
Support SHOWPLAN diagrams
Like in Management Studio, I would like to be able to see the Execution Plan of my query.
3 votesAdminPMs (Admin, Devart) respondedThis is already present in dbForge https://docs.devart.com/studio-for-sql-server/optimizing-sql-queries/working-with-plan-diagrams.html
-
Select All in right-click
I would appreciate a SelectAll (equiv of Ctrl-A) item to the right-click menu in the resulting datagrid...
3 votes -
Ability to export data from all pages at once when Paginal mode is turned on
Implement an option in Data Export wizard to export data from all pages at once when Paginal mode is turned on.
3 votes -
Dependency Diagram
It would be nice to have a tool which allows me to see all dependencies like a graph for a specific object. This helps me to identify all possible impacts; this would be a killer feature.
3 votes -
Convert in Data Editor http:// to links
In Data Editor, convert text fields starting with 'http://...' to links.
3 votes -
Add schema name into DB diagram
Add schema name into database diagram tables names, eg into brackets like in SSMS
3 votes -
3 votes
-
Create virtual foreign keys in database diagrams without writing them into database
I like to create visualizations of Data Warehouses using dbforge. In a Data Warehouse, foreign keys are typically not created physically.
If I could create data base diagrams in dbforge, importing existing tables and creating virtual foreign keys it would be the perfect tool for DWH documentation.3 votes -
Default Date Only on Datetime Picker for stored procedure parameters
When entering parameter values on a stored procedure of the type of datetime or smalldatetime the datetime picker defaults to the current time, but might better default to midnight or allow the user to quickly change the time to midnight (such as a button click) as it is too laborious to change all of the times to midnight, which I'd guess may be the most common usage for stored procedure/function datetime/smalldatetime entries (dates without the time).
3 votes -
default database
When click New SQL default to the database used last for the connection, do not default to the master database
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 -
Quick SQL statement formatting for development IDE
I would like to have my current SQL query be copied to the clipboard and formatted for pasting in the Visual Studio IDE. Example:
Select * from MyTable
would get copied into the clipboard as:
String sSQL = "Select * from MyTable";Obviously larger statements are more complex.
3 votes -
Save remote server address or add flag "Save this server address"
Save remote server address or add flag "Save this server address" for choosing from "Server" dropdown when new connection is created
3 votes -
Allow export to new tab in dbforge
When exporting SQL, many times I want to open it and run it or parts of it inside dbforge. For that reason, and because I am used to it from SSMS, I would like to export to new query window.
3 votes -
Keyboard assignments for "go to next/previous difference" right-click functions
Need a way to quickly move up and down a column of data rows to find data differences in the Different Records tab.
3 votes -
Ability to filter by schema in 'Generate Script" wizard
Provide a multiple select schema dropdown or list to filter ALL objects (tables, views, procedures, ...) in 'Generate Script' wizard automatically by the selected schema(s).
3 votes -
Retain rich text formatting when selecting and copying text to clipboard
When selecting SQL from a query or stored procedure, then Copying (Ctrl+C) and pasting into an email (rich text, like Outlook), it would be good to retain the rich text formatting when pasting text.
SSMS does this very nicely (with Outlook, anyway).
3 votes -
Quick filter for Object Explorer
It seems to me that it would be convenient to quick filter or highlight objects in object explorer simply by typing (condition "contains" by default not only starting) or pressing the key combination. Thanx.
3 votes -
Quickly Update Source Schema
An option to quickly get the update script for a single table in the opposite direction. (From Target back to source). I need to get all changes done by other developers and some developers make changes to one of two different databases, and I need to merge changes to/from the two main databases.
3 votes
- Don't see your idea?