134 results found
-
Add ability to define object file name format in Source Control and Schema Compare
Currently dbForge Source Control generates files using <schema>_<objectname>.sql naming convention.
dbForge Schema Compare does the same if you script objects to a folder.Such naming convention does not match our naming conventions.
Can you please add ability to define object file name format in Source Control and Schema Compare? At least define separator between schema and object name and file extension.
6 votes -
Ability to include Text Compare results in SQL Schema Compare Report
In dbForge Schema Compare for SQL Server you can see actual code difference in UI in Text Compare section. But when it produces a report there is no option to include Text Compare details. Report only has object level details.
It would be useful to to have option of including actual Text Compare for automated notifications about schema changes.
39 votes -
Control-N in an SQL window
When I press control-N in an SQL window, why does the new window not inherit the server and database of the current window?
3 votes -
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 -
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
-
Ability to set edition for trial mode.
During the 30 day trial, the application runs in enterprise mode. It would be ideal to have the option to change the edition that it runs as so that we can easily see what features we gain/lose with each edition. For example: My company is looking at standard edition. I have to keep going to the website to see if the feature I am currently playing with comes with that edition. It is making my evaluation much more difficult.
3 votes -
How to create column of type nvarchar(max)?
The "column properties" dialog does not list that data type.
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 -
Profiling mode should use parameter
I can set parameter for my query. But if I use profiling mode, DBForge 5.0.337 ignore the parameters.
0 votesThe Final Release of dbForge Studio for SQL Server, v5.1, where this issue is fixed, is available for downloading https://www.devart.com/dbforge/sql/studio/download.html
Thank you for your help in improving dbForge Studio for SQL Server.
-
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 -
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
-
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.
-
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 -
Invalid scripting for FK deleting using "IF OBJECT_ID('FK_...', 'F') IS NOT NULL" check.
Invalid scripting for FK deleting using "IF OBJECTID('FK...', 'F') IS NOT NULL" check.
There is need to use schema as part of FK name. Reason: "OBJECT_ID() function returns NULL for "non-dbo schema" FK.Bad script:
IF OBJECTID('FKFDlalala', 'F') IS NOT NULL
ALTER TABLE EE.FDlalala
DROP CONSTRAINT FKFDlalala
GOUber script:
IF OBJECTID('EE.FKFDlalala', 'F') IS NOT NULL
ALTER TABLE EE.FDlalala
DROP CONSTRAINT FKFDlalala
GO3 votesThis issue is fixed in dbForge Studio for SQL Server, v5.1 https://www.devart.com/dbforge/sql/studio/download.html
-
Script generating with table rename and reinsert data
Here is some table need to recreate and refill data after if. Recreation reason- identity increment has been changed.
This script was generated:
IF OBJECTID(N'dbo.EDDevicesSHADOW', 'U') IS NOT NULL
AND OBJECTID(N'dbo.tmpdevartEDDevicesSHADOW', 'U') IS NULL
EXEC sprename N'dbo.EDDevicesSHADOW', N'tmpdevartEDDevices_SHADOW', 'OBJECT'
GOIF NOT EXISTS (
SELECT 1 FROM sys.indexes
WHERE name = N'PKEDDevicesSHADOW' AND objectid = OBJECTID(N'dbo.EDDevicesSHADOW'))
AND EXISTS (
SELECT 1 FROM sys.indexes
WHERE name = N'PKEDDevicesSHADOW' AND objectid = OBJECTID(N'dbo.EDDevicesSHADOW'))
EXEC…3 votes -
Showing the connection color in the status bar
Apologies, not sure if this is a bug or needs to be a feature. I love the identification of tabs using the shape and color of a connection. I would LOVE it if that color would also transfer to the status bar, which on my setup is always blue. Due to the status bar's visibility, I get super confused when I'm on a connection colored, say, red (production) but the status bar is blue (test).
2 votes -
Open new tabs next to current one
Opening up a new tab all the way at the end is so Internet Explorer (not in a good way). 99.999% of the time if I'm opening up a new tab it's intended to supplement my work in the tab I'm in, so visually it is most useful if it just starts up next to the current tab.
2 votes -
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 -
Source support for the online (www.visualstudio.com) version of TFS.
The visualstudio.com online version of TFS will not authenticate with Source Control. I have tried alternate credentials and using the tool from http://nakedalm.com/tools/vso-service-credential-viewer/.
3 votes -
All Azure database server databases displayig
When connecting to Azure database server with checked flag "Show all databases" - in the list present only "master" database under "System Databases" directory and database that was selected in "Edit connection" window. In case there was not selected any database(Filed "Database:" was empty) - program connection to some not specified nowhere default database and show "Tables", "Views", "Synonyms", "Programmability" and "Security" items under established connection name at "Database Explorer"
15 votesThere are all databases displayed in the tree of version 6.0.
- Don't see your idea?