134 results found
-
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’. -
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 -
Export Data to JSON
Please add support for new FOR JSON
8 votes -
DataCompare: Add option to turn ON\OFF Generation of "IF NOT EXISTS" on inserting
I have to script data so it won't produce an error when running the sql statement.. 80% of the time I have to manually update the data synch scripts like this:
IF NOT EXISTS (SELECT * FROM dbo.DescriptionReference WHERE DescriptionId = '0243b2d2-58b2-4aaf-8cfd-0011f036f0e3')
INSERT dbo.DescriptionReference(DescriptionId, CultureCode, IsDefault, Description, LongDescription, SourceTable, IsActive, Created, CreatedBy, Updated, UpdatedBy)
VALUES ('0243b2d2-58b2-4aaf-8cfd-0011f036f0e3', N'en-US', 1, N'2300 REF F8 - P', NULL, N'FormatRuleValue', 0, '2015-06-01', 'TESTA', '2015-06-01', 'TEST')
If I don't and the data exists it throws an error and stops our DB Upgrade process..
IT WOULD BE GREAT if you could have an option to turn on…6 votes -
Problems with schema refresh
I use version 4.5.60 and do the following: I edit a table (remote connect to SQL2012Express) and add two new columns (one bit, one int) with NOT NULL and Default Value. I click "Script change" and I execute only the two ADD COLUMN statements. It works, I check it with "Retrieve data". I close all tabs and go to again to "Edit table". I get the old schema (without the new two columns). I close your application and start it again: all works fine!
0 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
-
User-Defined Function Editing Removes Existing Permissions
if you edit a user-defined functions, any pre-existing permissions are removed. They should not be.
2 votes -
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 -
Generate CRUD Matrix from a SQL Server database.
Generate a matrix showing tables vs. procs/functions that Create, Read, Update or Delete data in that table.
Perhaps this could be achieved by expanding the detail available in the "Used By" section of each table.
4 votesIn version 6.0, the new command ‘Generate Script As → CRUD’ is available in the popup menu of a table in Database Explorer.
This feature can be setup in the ‘Generate Scripts → CRUD’ section of the ‘Options window’ (select ‘Tools → Options…’ from the popup menu).
-
1 vote
-
Add database documentation tool
It would be perfect to add database documentation feature.
Generate documentation as CHM or/and as documentation project which could be used by third party tools like Help&Manual.38 votesYou can download the new product dbForge Documenter for SQL Server at https://www.devart.com/dbforge/sql/documenter/download.html
-
Allow Backing up to UNC or Mapped network drive
When creating a backup, I'd like the ability to store the .BAK file in a folder on another PC, either via a UNC file share (\servername\sharename\mybackup.bak) or a mapped drive (g:\backups\mybackup.bak). Right now dbForge Studio only lets you back up to the local hard drive of the server.
2 votesYou can amend the existing path and specify a mapped network drive right in the ‘Backup to disk’ list on the ‘General’ page of the Backup wizard.
-
structural highlighting
It would be very nice if dbForge could have an option to jump to/from Begin/End statements. This allows us to clearly see where a structure begins/ends (in large scripts).
Also faint lines connecting begin/end, ( and ), like DevExpress's CodeRush or Notepad++ would be very nice.
Currently you have faint lines around select statements and so forth. That is very useful, but the suggestion above will enhance the usefulness of the current structural highlighting.2 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 -
Add table triggers as an option to the Generate Scripts database scripting function
The Generate Scripts function under Tasks is missing the option to include database triggers in the list of available objects to include in the output. Triggers are a fundamental component for replicating database schemas and should be included in the scripted output.
4 votesTriggers are turned on by selecting the option ‘Script DML Triggers’ on the ‘Options’ page of the Generate Scripts Wizard https://snipboard.io/GJTyaf.jpg
-
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.
-
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 -
View extended properties of objects easily
Like MS_Description property for example on Table, Column, etc. Would be very useful on hover of object in browser or TSQL editor
1 voteThe full object information is available in the Standard and Professional editions of the product.
-
Show Column Description
Add ability show|hide Field description in the Table entity additionally to the Field Name and Type
9 votesThis can be setup as follows:
1. Right-click in the diagram and select ‘Options…’ from the popup menu. The ‘Options’ window opens.
2. Switch to the ‘Notation’ tab.
3. Select the appropriate option from the ‘Field Details Level:’ drop-down menu.
4. Click ‘OK’. -
Status-bar PER tab
It is often quite hard to know that an update or insert statement, or DDL statement has actually happened. Data from a previous SELECT statement remains steadily there, and the only hint is to watch the right-hand corner and actually see this change from Ready to Executing to Ready - but if you miss that, even the Output window is not definitive. A status bar PER TAB - like Management Studio - including the last number of rows affected, the last execution duration IN THAT TAB, etc. would be immensely helpful.
1 voteThis feature is implemented in the new version 4.0 of dbForge Studio for SQL Server http://www.devart.com/dbforge/sql/studio/download.html
- Don't see your idea?