401 results found
-
Is it possible to change the default location of .dgen files?
The default location for custom data generation configs is:
C:\Users\Public\Documents\Devart\dbForge Studio for SQL Server\Data Generators
This is different than the location for the other project-related files and this makes it tough to check in and share, etc.
Is it possible to change this default location?
I have a feature request in about this, but maybe there's a hack or even something I'm missing to set this location?
1 vote -
Schema compare does not work for many identical scripts / texts
Schema compare is incorrectly marking scripts as "update" yet text wise they are completely identical (including control characters and white spaces)
3 votes -
I'd like to be able to edit or delete user defined (custom) data generation configurations directly from the GUI
I'd like to be able to delete user defined (custom) data generation configurations directly from the GUI.
Currently, you can create (but not delete, nor edit) user defined custom data generator configurations easily.
Often it is necessary to delete these custom configs because you've created new ones...or saved it too many times...or for other reasons. However, there's no option to delete from the GUI. In order to delete them, you have to find their location and delete xml files found under C:\Users\Public\Public Documents\Devart\dbForge...\Data Generators... there you're presented with only timestamped files with no naming that indicates which user defined generation…
1 vote -
When you have an existing data compare and you change the target, it doesn't work
Take two identical databases on different SQL Server instances (or on prem vs Azure). Ensure they are identical by doing a schema compare. Take a data generation file that is configured and works for one database. Take that file and change the target to the new database. The pre-existing configuration does not get applied to the new database.
The workaround is to create a copy of the existing data generation file, open the new configuration .dgen file in a text editor and change the ConnectionString line in the xml to match the new database's properties. In order to get the…
1 vote -
Script Object as Create / Alter (ctrl- F12) into named tab instead of no name
After Script Object as Create / Alter (ctrl- F12) please name the new tabbed window with the scripted object's name instead of SqlQuery99.sql.
And also please make this forum easier to search.
I can't believe nobody asked for this feature before, but I couldn't find an existing item to upvote.
I hate duplicate tickets just like anyone!2 votes -
As a developer, I'd like to be able to check in custom data generator configurations...
As a developer, I'd like to be able to check in custom data generator configurations with the rest of my project's configuration into source control.
Currently, the xml configuration files are stored in a separate far-off location /Users/Public/... and this makes it not ideal if you want to version your generator configurations to share with the rest of the team through Git, as an example.
1 vote -
Please add the new sql server 2022 features
SQL query window does not accept adding the 'WINDOW xxx AS' clause to a query with a window function.
1 vote -
Orderly Fashion Data Pump (From parent to children + referential integrity)
I am trying to do a data pump but once it is finished the data is almost useless because I don't need 1,000 records per-table, but as many as meaningful are, the children records derived from smaller amounts of records in its corresponding Mater or Parent tables
So If have for instance ... let's say Businesses (1) and Stores (2) so I'd like to pump data just for these entities not 1,000 business and 1,000 stores but 1,000 billing records, 10,000 stock count records, 8,000 items catalog for each store ... derived from previous node ... like a tree structure…
1 vote -
Transpose SQL Result
I want the ability to transpose the SQL result so you only view one record at a time and having the option to sort the column names or the values. And then adding buttons to iterate through the result set.
And no, the card view does not serve this purpose.
3 votes -
Data Pump pass through imported file name
When it comes to bulk Data Pump imports from multiple files (e.g. Excel, *.csv), I'd really appreciate the ability to pass through the source import file name (as text) to a dedicated column within the destination SQL Server data table against each imported record.
Personally, I use the DevOps PowerShell Automation import pathway and would find it a really handy addition for basic audits if it was accessible as a parameter on Invoke-DevartDataImport
Thanks!
1 vote -
Executing a query across multiple servers
The only thing that prevents me from using DBForge is the inability to run a single sql query on 10 different SERVERS simultaneously and see the aggregated resultset. In SSMS you can simply create a folder and put all of your server connections into that folder and then when you right click on the folder it allows you to connect to all X servers in that folder simultaneously. If you run a top10 query and you have 10 servers configured in that folder you get back a single 100 record resultset. Without a feature like this I can't leave SSMS…
1 vote -
Clear google sheet before exporting
Would be great if before exporting data into from SQL Server to google sheets the sheet is cleared, that way if in a second export less rows are exported there are no risk in export duplicates records.
1 vote -
Automate data pump functionality
Create an automation component for the data pump functionality in dbForge whereby a user can set a source file containing data and then automatically have that data imported into a SQL table on a schedule or via a trigger.
3 votes -
Support for Microsoft Fabric
We really need support for Microsoft Fabric SQL endpoints, at the moment when i try to connect i get the error : "FUNCTION 'SESSIONPROPERTY' is not supported."
But i can connect with others IDEs.Please add this to your product!
3 votes -
pin tab
how is possible there is no simple thing as pin tabs?
1 vote -
Allow the renaming of table names when exporting data to Excel. Currently if the sheet name is over 31 Characters Excel generates errors
It would be really handy to be able to rename tables when they are exported to Excel as anything past 31 characters and Excel will generate an error. The SQL server Data Import/Export tool has the ability to do this and comes in very handy.
3 votes -
remote changes source control
For source control (GIT) at the remote changes tab add a ignore/delete option.
I started working with the database and deleted/renamed some stored procedures. When I detached and attached my source control (GIT) it wants to add the procedures which I have removed.
This is fine when someone else changed it, but now I specifically want to delete this procedures. When working with this I can add them again, to delete them afterwards, or I can delete them in the folder and check them in with GIT, bypassing dbForge.The easy solution would be to add a ignore/delete/keep local option…
1 vote -
migration
Migration Based Deployment System
I’m searching for an option that the database keeps a log of the migrations (scripts) that are already performed. When I’m deploying new migrations it can simply look which migrations are already done (or set to not done) and continue from there.
When my colleague is then updating his database he can execute all scripts which aren’t yet done on his database. This will results in his database being completely updated while saving, updating of removing the data (This is done without a compare (just script executions) which is great, because his changes aren’t removed). Then…
3 votes -
formating Value and Numbers in result of Query Like show numbers separated by separators
There is an option to change the way Date and Date-Time shown is the result of Query if you add other thing like show numbers separated by separators etc.
1 vote -
Auto re-draw causing loss of user specified relationship lines on diagraming tool
Fix issue with diagram tool auto redrawing relationship lines when tables are dropped and recreated with no changes to relationships from old to new tables.
Specifically I reverse engineered my tables into the database diagraming tool. Then painstakingly organized the tables then adjusted all the relationship lines so they take a short path and do not cross then saved the diagram.
When re-opening it everything is fine. But - if I ever drop and recreate the tables (e.g. with a script to change the schema) the diagram tool auto-redraws all the relationships and the diagram becomes a mess.
Please fix.…
1 vote
- Don't see your idea?