168 results found
-
Redesign stored routine editor
Suggestion to redesign the visual stored procedure editor of dbForge.
Uh... there are a number of major misses here in 4.0.
I login to a database, expand the Programmability section, then right-click a procedure and select 'Edit Procedure.' The script that is generated is a CREATE PROCEDURE method, which out of the box won't work because the procedure already exists.
Okay, so I change it to ALTER PROCEDURE and press F5 to rebuild the procedure. I get a dialog box prompting me for parameters! Oh, I guess F5 means RUN the procedure? No, that's not what I want. It looks…
1 vote -
Import data - enable BACK button
If import data failed (eg duplicity in key, cannot save importlog to C:\ etc), then BACK button is disabled. Therefore after fixing the problem, we have to start import wizard from scratch
It would be perfect simply click BACK button and try again1 voteIf data import failed, you can leave the wizard open, fix the problem and click ‘Import More’ on the last page of the wizard. All import settings will be restored.
-
1 vote
-
Display records quantity and add ability to skip current table during export
When selecting a data source, it would be nice to see the quantity of the records in the table.
Also, when performing export, add the ability to skip the current table.
1 vote -
Spread connection categories marking to single objects
Extend the connection categories marking feature so the objects (tables, views, procedures, etc) belonging to the connection also have the same marking as the corresponding connection.
1 vote -
DBForge Studio is not handling DATETIME2 in MSSQL Server
CREATE TABLE #Table1 ( c1 int, c2 DATETIME2)
;SELECT * FROM #Table1;
INSERT INTO #Table1 (c1,c2) VALUES (1, SYSUTCDATETIME ());
--dbforge returns: 7/29/2015 8:58:48 AM
--sqlstudio returns: 2015-07-29 09:00:32.5318459-- we are missing the nanoseconds
1 voteThis can be setup as follows:
1. Select ‘Tools → Options’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Data Editor → Formatting’ branch.
3. Select ‘DateTime’ from the ‘Data type’ dropdown menu.
4. In the ‘Predefined Formats’ list, select ‘General date/time (longtime with microseconds)’.
5. Click ‘OK’. -
Refresh option in Data Import wizard
When I use the import wizard it would be handy to have a refresh option. If I'm partway through the wizard and decide I'd like to create a table manually, I can't then specify that table to import to without closing the wizard, force a refresh and start all over again
1 vote -
Hi. I suggest to add the feature for select only a database, on Connection Properties.
Include the option for to open only the connection with database specified.
1 vote -
Ao tentar executar consulta na primeira vez
Quando executo uma consulta pela primeira vez, após a carga da aplicação, nada é exibido. Somente após fechar uma das janelas é que consigo voltar a visualizar a saída dos resultados.
1 vote -
password change on expiry
My dba set a security policy to reset the users sql password once a month.
When i log in using MS-SSMS, when the change password is due, the application tells me that the password is expired already and then offers me to change my sql password immediately.
DbForge just tells me that i cannot use my old password.
Can you add this change password on expiry feature please?1 voteNow, the updated view editor contains the text of the view as well as the visual representation of the query on the diagram.
-
Autosize
Last beta version does not autosize the result set (regression). You have to retrieve multiple times to get the results aligned properly.
1 voteThis issue is fixed. Please upgrade to the latest version https://www.devart.com/dbforge/sql/studio/download.html
-
In Database Explorerer it should be possible to see the data type and NULL/NOT NULL settings of fields like in SSMS
In Database Explorer it should be possible to see the data type and NULL/NOT NULL settings of fields like in SSMS.
1 vote -
Bring back the single-DB Connection
The Single DB feature was removed in V5, and I would like to see it brought back
1 vote -
How to create column of type nvarchar(max)?
The "column properties" dialog does not list that data type.
1 vote -
Invalid error line for "Display Estimated Execution Plan"
use this script for test:
DECLARE @FILENAME AS NVARCHAR(500),
@FILENAMEPRE AS NVARCHAR(500),
@FILENAMESUF AS NVARCHAR(500),
@SQLSTMT AS NVARCHAR(MAX)SET @SQL_STMT = 'SELECT t1.*, CASE WHEN c1 IS NULL THEN ''Y'' ELSE ''N'' END AS [COLUMN1], t2.c3 FROM t1 LEFT JOIN (SELECT * FROM (VALUES (''v1'',''v1'',''v1''), (''v2','v2','v2''), (''v3'',''v3'',''v3'')) RET (c1, c2, c3)) t2 ON t1.c1 = t2.c2 '
if you press "Display Estimated Execution Plan", then the first line will be highlighted with an error: Incorrect syntax near ','.
But if you press "Execute" then correct one will be highlighted1 voteThis issue is fixed in the latest product version 5.4 https://www.devart.com/dbforge/sql/studio/download.html
-
Skin styled images not showing in menu
If you set "Use styled images" in options, all the icons/images use this setting except for the cell edit cascade menu... as shown here:
1 vote -
F3 button not working properly
Normally, if I do an incremental search (CTRL+I) or a normal search (CTRL+F), pressing F3 takes you to the next location of your search text in the current file. With DBForge it seems to jump all over the place. The only place it doesn't take you to is the next location in the current file, which basically makes it impossible to use.
1 votePlease try the latest version 5.4 https://www.devart.com/dbforge/sql/studio/download.htmlhttps://www.devart.com/dbforge/sql/studio/download.html
-
Execute current statement : CTRL+ENTER
CTRL+ENTER to execute the current statement, or be able to set the key combination(s) in Options.
1 voteThis can be achieved as follows:
1. Select ‘Tools → Options…’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Environment → Keyboard’ branch.
3. Type ‘Sql.ExecuteCurrent’ in the ‘Show Commands Containing’ field.
4. Select the found ‘Sql.ExecuteCurrent’ command in the list below.
5. In the ‘Use new shortcut in’ field, select ‘Text Editor’.
6. Set the focus in the ‘Press shortcut keys’ field and press the required key combination.
7. Click the ‘Assign’ button.
8. Click ‘OK’. -
Autocomplete doesn't work if table belongs to schema and no alias or schema name used in join.
Example:
select *
from Schema1.Table1 join Schema1.Table2 on Table1.[AutoComplete doesn't show table fields]select *
from Schema1.Table1 T1 join Schema1.Table2 T2 on T1. [AutoComplete works properly]1 voteThis feature is implemented in dbForge SQL Complete, v5.6 https://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
Allow connection to SQL Server running on Ubuntu
I was able to connect to SQL Server running on Ubuntu with SQL Server Management Studio. Be nice to do it with dbForge. Got the error message that the version of SQL Server wasn't supported when I tried.
1 vote
- Don't see your idea?