382 results found
-
"smart rename" to rename an object in database automatically and its reference and dependency
"smart rename" to rename an object in database automatically and its reference and dependency.
Just like competitive product "red-gate sql prompt" did.By the way , Devart DBforge Studio for SQL Server is very good and powerful IDE for me. I've bought a licsence.
Thank you and best wishes.
Happy New Year. ^_^4 votes -
Data Viewer is not working after a day of application activity
Data Viewer is not working after a day of application activity
Data Viewer stops displaying anything in a day after being started. You will need to restart the application so it starts working again.
3 votesAdminDevart (_, Devart) responded
Please let us know if the issue still persists in the product version 4.0 http://www.devart.com/dbforge/sql/studio/download.html
-
Don't resize results pane
It would be great if the results pane a consistent height rather than resizing to the take up all available space not used by the query. Sometimes you'll run a query that to get an idea of the type of data in a table but mean to expand on the query. With the current set up you have to resize the results window to write a multi line query after running the initial one line query.
3 votesAdminDevart (_, Devart) responded
Please note that you can redirect the query result to the Data window:
1. Select ‘Tools → Options…’. The ‘Options’ window opens.
2. Navigate to the ‘Environment → Documents → SQL documents’ section.
3. Select ‘Redirect data to Data window if Data view is closed’. -
Disconnect studio from Delphi
In Delphi if you use the Devart SQL server components, dbForge studio is launched automatically. There is a bug if you close Delphi, studio hangs and is no longer usable.
3 votesAdminDevart (_, Devart) responded
Could you please let us know what version of dbForge Studio for SQL Server you are using?
-
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) responded
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\ -
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) responded
This 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 -
Align the equal signs in the SET block of UPDATE statements
It would be nice if SQL Formatting for UPDATE statements could align the equal signs in the SET block, this would make for a very readable and clean SQL statement.
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
- Don't see your idea?