257 results found
-
Hide Relationships
Ability To Hide Relationships On A Diagram
4 votes -
Filter on modified date
Hi,
It would be good to add a "modified date" filter to the defaults. Currently it is very hard to display only recently modified elements.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 -
"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 -
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 -
FULL SCREEN
usefull for coding
4 votes -
Rename tabs individually
There should be possible to rename a tab. This should override the SSMS Caption template. It should not override the filename if it is a file that is saved to disk.
4 votes -
Copy to clipboard search results
In the search window has the ability to copy into clipboard current line. Is it possible to modify to copy all the rows or selected rows ?
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 -
On the customer License Information page, add a user editable field where we can log who has which license.
I purchase the licenses for my dev team, so when I purchase two licenses, one for myself (SQL Tools) and a separate on for one of my devs (Schema Compare) I would like to indicate which is assigned to whom. Currently on the License information page, both appear assigned to me. While two folks is easy, if we grow our usage of your products further, I would like to know who I've assigned which licenses to, while keeping them all under the one account.
All I'm looking for is a field that I as the customer can note this type…
3 votes -
column totals
Show column totals (sum) or average at the bottom of the column. This would be great with a right click of the column header then click then click Group Footer then click Sum or Average
3 votes -
CSV - Support importing data that uses brackets for negative values into money fields.
It is fairly common in other tools/database (like Access for instance) for exported money or currency type fields to represent negative numbers by putting brackets around the value. Currently when such values are imported they give a truncation warning and put the value in as positive.
(10.00) should go in as -10.00 instead of giving a warning and going in as 10.00.
3 votes -
Update SQL Server 2025 to Scripts Folder sync
Please update SQL Server 2025 to Scripts Folder sync. It currently doesn't work for the json data type or new functions, such as json_objectagg
3 votes -
LinqPad-like Script Browser
LinqPad has one useful feature that could be used here in dbForge Studio too. It has a panel which shows folder structure of one specific scripts folder (configurable location). In this folder users can organize scripts into subfolders (projects). And by double-clicking on script in this panel you open the script. This folder can also be synced (via dropbox or other cloud drives) so you have same structure and scripts on multiple machines. This is a similar feature request as project workspaces. Could be easy to develop and would really help us who work on lots of projects and databases…
3 votes -
Rollback script
When comparing schemas and data, but in my case more important the schemas, it would be nice if a "rollback script" would be created. Like, if the comparison generates script "ALTER TABLE tbl ADD clmn int" then in addition to it a "rollback" file will be created with the statement "ALTER TABLE DROP COLUMN clmn".
It will help to rollback all the changes immediately in case of something got broken.
I just had this situation where I went from test to prod and I had to roll everything back because of some malfunctions appeared that were not seen in tests.…3 votes -
Export Data to SQL with Structure
I would like to export data from a table to SQL and have the option of the SQL doing a "DROP TABLE" "CREATE TABLE" to create the table and insert the data. Currently the options only allow for data insert, update, etc. Please add the ability to include the structure of the table and fields.
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 -
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 -
Filtering code completion
When you filter the objects in the Explorer->Tables view
It only logical that the auto completion in the Sql script would be filtered too.Maybe an option inside Options -> Code Completion -> "Use filtering on objects" would allow the user to select the desired flavor.
If you have that option selected, when you do a filter in object explorer, when you are writing a sql sentence autocompleting tables, it only shows tables with that particular filter.
Thank you.
3 votes -
Have an option for unlocking a DB that dbForge has exclusively locked
When I try to restore a database (from SSMS on the server), sometimes dbForge has the DB exclusively locked and the restore fails. I end up then needing to close all my tabs in dbForge, and then shutting down dbForge.
Why not have an option to release dbForge's lock on the DB?
3 votes
- Don't see your idea?