401 results found
-
If exists then add or create behaviour while generating sync script
Can you please add functionality for if not exists condition while generating sync script for tables and procedures.
for example : if db compare tools detects that a column needs to be added into other database in such a way that it will first check if that column does not exists in target table then only create that column.
and if exist procedure then drop and create procedure.8 votes -
1 vote
-
Ability to change font size on diagrams
So you can print more objects per page.
17 votes -
0 votes
-
Disable event objects support when disabled in database
My hosting provider has event support dissabled in database engine. dbForge tries to retrieve events on almost every action, which results in error (Cannot proceed because system tables used by Event Scheduler were found damaged at server start) Could events support be disabled in dbForge when event_support server variable is set do DISABLED?
1 vote -
Integrate MS SQL Server Diagrams
We store most of our database structure right in the database (field descriptions and FKs are pretty self-explanatory), so we don't have to make separate documents with diagrams. It would be nice to have an option to load existing MS SQL diagrams to your diagram editor. And save them back in the MS SQL diagrams format.
20 votes -
Align the equal signs in the SET block of UPDATE statements
It would be nice if SQL Formatting for UPDATE statements could align the equal signs in the SET block, this would make for a very readable and clean SQL statement.
1 vote -
Ability to specify FROM and JOIN clauses when building complicated UPDATE queries in Query Builder
When building an UPDATE query in Query Builder, make it possible to specify the FROM and JOIN clauses in order to define source tables.
7 votes -
1 vote
-
Ability to export data from all pages at once when Paginal mode is turned on
Implement an option in Data Export wizard to export data from all pages at once when Paginal mode is turned on.
3 votes -
Select All in right-click
I would appreciate a SelectAll (equiv of Ctrl-A) item to the right-click menu in the resulting datagrid...
3 votes -
0 votes
-
0 votes
-
Add option to specify display format for numeric values
Many large numbers are hard to read, and only Date / DateTime formats can be specified. I'd like to add thousand separators (either komma or dot) at least
9 votes -
Ability to select objects to print on Query Profiler Plan Diagram
Though I can selet objects in the plan, I cannot "Select all" by using Ctrl-A, to print just a part of the plan.
1 vote -
debug and unit test support with local variables
Within SQL Server Management Studio 2012, while debugging and stepping through a stored procedure source code many levels deep, one has access to the local variables pane. That pane shows variable name, value, and then type. That pane is so close to being helpful, yet it falls short by having the value and type in the wrong order.
It would be great to be able to copy the whole local panel and paste that as source to an editor as DECLARE @<variable name> <type>=<value> for each of the local variables.
That would greatly facilitate recreation of the cases that one…
1 vote -
Suggest optimizations when right-clicking a database object
Suggest optimizations when right-clicking a database object (indexes, primary keys, data types, NOT NULL, ...)
15 votes -
Loose snapshots
1) Create snapshots into just loose files (organised into folders by object type); no snapshot file, just the scripts in their folders. Also be able to compare to these loose snapshots. (May be include the option to zip the folder structure into a single file if the user wants single file snapshot). The loose files really enables any source control that the user chooses, and makes it far easier for doing diffs.
16 votes -
1 vote
-
Apply current grid filters to the query
You can change the filter and modify sort order. Would be nice if there was an option to flush these settings into a below query. For example, you have "SELECT * FROM table1", execute that, pick to sort by column1, column2, and also where column3 = "AAA", then you use that option - and get "SELECT * FROM table1 WHERE column3 = "AAA" ORDER BY column1, column2".
6 votes
- Don't see your idea?