168 results found
-
4 votes
This feature is implemented in the new version 4.0 of dbForge Studio for SQL Server http://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 -
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 -
"Object has invalid source text" - Improve Error Information
For simple error situations, the editor will collect errors and display them in the error grid upon save attempts. However, for many errors, it will simply display "Object has invalid source text and cannot be saved".
If I take the entire editor contents and paste it into SSMS and attempt to execute it, helpful error text will be returned, such as "Must declare the scalar variable '@foo'", complete with a line reference.
3 votesThis issue is fixed in the new build 4.5.79 of dbForge Studio for SQL Server where the issue you reported is fixed http://www.devart.com/dbforge/sql/studio/download.html
-
Copy with column names doesn't paste correctly into Excel
Do any select, copy with column names. Paste into Excel. Data pastes properly, but column names do not.
3 votes -
Data Comparison and Sync: Add option to "ignore computed columns"
Some of my tables have computed columns. I try to go through the mappings and manually un-check those tables before I do a data sync, but I sometimes miss one, the sync blows up, and I have to start again from scratch.
Since it doesn't normally make sense to try to write to a computed column, I think there should be a (defaulted to on) checkbox that says "ignore computed columns".
3 votesThis feature is implemented in the new version 4.0 of dbForge Studio for SQL Server http://www.devart.com/dbforge/sql/studio/download.html
-
Zoom query window (like SSMS)
Please add the ability to zoom in/out in the query window to change the text size
3 votesWe would like to let you know that we have released dbForge Studio for SQL Server, v3.8 Beta where the feature you reported is implemented.
http://www.devart.com/dbforge/sql/studio/download.html
Thank you for your help in improving dbForge Studio for SQL Server. -
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 -
Option to align the text in the table comparison panel
It would be nice if there is an option to visually align the text on both sides in the table comparison panel.
This would mean to align all exact lines on both sides and when the are lines which exist only on the left or the right to put an empty line on the other side.
It makes the visual comparison easier and similar to how the Diff/Compare function works in Visual Studio.
3 votes -
Ignore index included column order
In the Schema comparison options, to have another option available to ignore the column order for the included columns in a nonclustered index, as this column order is not relevant.
3 votesWe would like to let you know that we have released dbForge Studio for SQL Server, v3.8 Beta where the feature you reported is implemented.
http://www.devart.com/dbforge/sql/studio/download.html
Thank you for your help in improving dbForge Studio for SQL Server. -
Create Guid
Add a new menu item "Set Value To" -> "New Guid" in context menu when clicking on a cell (if the cell is type of uniqueidentifier).
3 votes -
Hierarchical data viewer
Is it possible to add hierarchical data viewer? I mean, viewer where you can set parent and child field and it build a tree based on query.
3 votes -
Transaction log reader
A tool to read transaction logs similar to http://www.apexsql.com/sql_tools_log.aspx
3 votesPlease review the following tool https://www.devart.com/dbforge/sql/transaction-log/
-
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
-
3 votes
-
Adding an option to add "if exists..." to script generation
Can we have an option to choose that makes dbForge generate "if exists" statement when generating scripts for database objects?
Ie:
when clicking on a sproc, table, view or synonym and selecting: "Generate Script As" - "Drop and Create", it would be nice if the generated script checks if the entity exists before dropping it.Currently, I have to do this manually every time to have a decent deployment script.
3 votes -
Use SpaceBar to auto complete words and names
when auto complete drop-down appear, we need to use space-bar to complete the word like as visual studio or ssms.
3 votesThis can be setup as follows https://snipboard.io/uqb2m9.jpg
1. Select ‘Tools → Options…’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Text Editor → Code Completion → List Members’ branch.
3. Select the ‘Whitespace’ option in the ‘Commit Selection’ section.
4. Click ‘OK’. -
Make schema comparison in vertical windows rather than in horizontal ones
Currently, the screen is divided onto two horizontal parts where the top window contains objects and the bottom one has their text representation which is not quite convenient because there is a lot of spare place left not used.
Visually, it would be much more convenient to have the ability to place the windows vertically rather than horizontally unlike the current implementation.
For example, like in AdeptSQL Diff.
3 votesThe feature is implemented in of dbForge Studio for SQL Server, v4.5.
-
See query that filter automatically is generating
When I filter the results grid in DBForge Studio for SQL Server, it's great to quickly get the results i need! However, there are times I'd like to see the SQL of the filter (i.e. what it is putting in the WHERE clause) so I can use it in my own SQL query. Currently I do not see a way to view or export that. This would be a nice feature to have!
3 votes -
Intellisense for tables in tempdb
When joining, querying, or trying to expand table.* column names for a table in the tempdb database, Intellisense does not work even for tables that existed when starting dbForge.
It would be nice to be able to have that feature even if it meant manually adding the table to the Intellisense cache.
3 votes
- Don't see your idea?