134 results found
-
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 -
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 -
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 -
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 -
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 -
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
-
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 -
"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
-
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).
-
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 -
1 vote
-
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.
-
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 -
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 -
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
-
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 -
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’.
- Don't see your idea?