257 results found
-
Data compare / Copy selected records with foreign keys into another DB
Please implement selective export of certain records and all related records in child tables (by foreign key).
Doing whole data compare in our case is estimated at 7.5hrs, which is too long for practical use.
This feature would be very useful in our reproduce/troubleshoot workflows, replacing whole DB backup/restore, which is roughly 150GB, times 2, to be moved over network.4 votes -
Extensions, plagins, add-in
Do you plan adding user extensions for the IDE (plagins) or some other mechanism to extend the functionality with external utilities?
For example:
- Using the external xml (you could include the editor), add an ability to add menu items (main, popup menu for a database, object, in the editor) where an external program with parameters will run (on a modal window) upon a click: current connection string (with a password, asking the user's permission), current database, current object type, current object name, etc.
A return code will tell what to do ( -1 - error, 0 -nothing to do, 1-update…
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 -
FULL SCREEN
usefull for coding
4 votes -
jobs
Add ability to also search in SQL Server Agent Jobs for references to stored procedures, tables etc. to dbForge Search.
Redgate SQL Search has this functionality.
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 -
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 -
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 -
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.4 votes -
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 votes
AdminDevart
(_, 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’. -
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 -
Support SHOWPLAN diagrams
Like in Management Studio, I would like to be able to see the Execution Plan of my query.
3 votes
AdminPMs
(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
-
history
Please move the Clear button for Query History from the main UI screen to be in the Options menu. In context, it seems like it is going to clear the search filters rather than wiping out the entire query history. It does warn you - but the history is so useful and important. Clearing it out should be a harder, more explicit step than just clicking twice. Not that I've done that... Multiple times...
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 -
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 -
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 -
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
- Don't see your idea?