-
import dbf file
When we do an import for dbf file, the first file is ready to create a new table with the file name for the table's name. At the end, when the import is done, we can click on "Import more". We select a new dbf file but it tries to import in an existing table or the previous table name and a number at the end. It must always be the file name for the table name when we want to import to a new table.
Thanks a lot!1 vote -
V.6.0.563 Container's title and stamp text color
Since V.6.0.563 in the diagram fonctionnality, the Container's title and the stamp's text color are white, resulting in very hard to read titles for the containers and impossible text to read in stamps.
21 votes -
Save a file even if it contains errors
If a DML query contains an error, the file is not saved. It is absurd to have to go into Notepad to save a file.
1 vote -
Data Editor should be case sensitive when determining whether to update
When a value is changed in the Data Editor, the Data Editor logic compares the value with the existing value and makes a decision whether to update the existing value based on whether the new value is considered different. Currently, this equality comparison is case insensitive, which is a bug. It must be case sensitive. SSMS will update data based upon consideration for case sensitivity, but not the Data Editor.
1 vote -
Shortcut Ctrl +Alt+o conflict with windows Alt+o - local alphabet letter
Shortcut Ctrl +Alt+o is in conflict with windows Alt+o . So you can't get the Polish letter 'ó' what is annoying when try to comment your code in Polish not only because the letter, but especially because jumping out of your current context. Suggestion: option for you own definition of the short cut.
10 votes -
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 votesAdminit (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\ -
enable
Window headings are only sql, sql1, sql2 an not the name of the datatable.
1 vote -
Save breakpoint information when closing a query
If you set a breakpoint, then close the query, when you open the query back up, the previously set breakpoint is no longer present.
1 vote -
Search does not find all objects
Search does not find all stored procedures in a case sensitive database. The default case insensitive search misses some objects. To make it work, you must specify the exact case sensitive search string and make the search case sensitive. The default server collation in my instance was case insensitive.
1 vote -
update data in grid when using join updated more than the one row
I changed the grid to update a table, but the update did not use the primary key of the selected row and updated thousands of rows! My expectation is that the PK of the selected "update" table would be used to update one row. This is a terrible bug and makes the update feature unusable when using a join.
1 vote -
The toolbar moves every time I click execute query or click away and back to the window. I put them where I want them and they reset with e
I customize the tool bar and arrange them how I want them and the reset on their own if I do anything like execute a query, move to another tab and move back, etc. They should lock in place and be the same on each query window.
1 vote -
Increase UI response and overal performance (SQL Data Compare)
Opening windows takes much time.
I believe the most often used features must work as fast as possible to provide the best experience (including not only processing but opening windows).
See how long it takes to open "New Data Comparison" and moving through tabs "Source and Target", "Options", "Mapping".
The app itself opens slowly as well opening "dcomp"-files.1 vote -
13 votes
-
Commit in Git
After making Commit several times in Git, dbForge Studio For SQL starts eating a lot of RAM
12 votes -
Pewrmit override Alias name assignment during Query design when LONG table names prevent viewing of columns/fields in the columns window.
From a SSMS Query window execute a statement like:
CREATE TABLE #tempAllBin (ID Int);
Then, in your query designed, browse to the TempDB and locate the new temp table. It will have a name like: "#tempAllBins________________________________________________________________________________________________________000000090BC2".
Select this table name and drag it into the query designer window in your tool. - The length of the table name makes it impossible to view the column names in the column window, as well as a number of other complcations arising from the length of that table name. I see no way to assign a SHORTER ALIAS Name in your query designer…3 votes -
Ability to edit vertically selected text
I am using dbForge Studio 2019 Express. I can select text vertically but I can not edit it. In other editors, when I edit text, all rows are updated.
I suggest to copy this feature of Notepad ++ or SQL Server Management Studio.
1 vote -
Improve keyboard support
I click "New Data Comparison" (or "New Schema Comparison"), then ALT-W to open the "Database Connection Properties" dialog, then TAB to get into the "Server" input box. Once there, I type a part of the name of the server and the list of available servers works nicely!
It seems that I must use down DOWN ARROW to select the server from the list and press ENTER before I can get out.
However, if I type the entire server name, I can't get out of that box! Pressing TAB or ENTER does nothing.
1 vote -
Cannot modify sql login associated with an active directory group
Sql logins associated with an active directory group (windows authentification) are shown in data explorer's security/users node, but not listed in the security manager.
Thus, if you double click on it in the explorer "object does not exits" pop up and the user cannot be edited.Enterprise Edition 5.7.31
1 vote -
Error when adding extended property in unicode
When I add an extended property (eg. description) in unicode, the generated script does not have N prefix for unicode value. As a result, my added property value gets unreadable after save.
1 vote -
Table along with its column becomes not visible once added
After a table is added, it's not visible with its columns in SQL Editor.
1 vote
- Don't see your idea?