253 results found
-
Python Generator to accept other table's columns
I have to generator a column based on another tables column value . Currently python generator can work with same table columns only. It will be great if we can access other table column also.
1 vote -
1 vote
-
hotkeys
Please implement. Support of simple shortcuts for work with lines (that not implemented as well) like in notepad++ or Visual Studio or MSSMS. I mean such shortcuts and features as : Ctrl+D - duplicate line, Ctrl+L - remove line, Ctrl+J - join lines etc.
1 vote -
trigger order, we need a handy way to set or change trigger order
It is sometimes important to set triggers order when there are several triggers for a single table, UPDATE event, for example.
There is a command which performs this:
EXEC spsettriggerorder @triggername=N'[dbo].[tskTask_Validate]', @order=N'First', @stmttype=N'UPDATE'But I wish I had a visualized tool for this task and more control than a simple 'First' / 'Last' option.
Thank you
1 vote -
Add a link to microsoft help viewer to the help menu
To be able to get the MSD help file / SQL documentation
1 vote -
Default Filter for Database Connection
I have couple of websites and I manage the databases for my website using dbForge Studio by connecting to hosting SQL server. You know that web hostings has hundreds of databases on SQL instance so expanding the connection in database explorer takes time. I wish I was able to embed filters when creating a connection so it will show the selected databases only.
1 vote -
Merge compare script
Can be userfull can have a option in the compare script to can marge the modify of the table structure (add Columns or Modify Columns) in the same query instead have more query. If I have a table with many records if I make more alter very slow instead to make the modify of the structure in 1 single script.
1 vote -
"Find invalid objects" ... "Select all"
In the "Find invalid objects", I really miss an option to "Select all". There's a "Clear all", but not a "Select all".
1 vote -
Automatically change Collation
I want to automatically change the Collation. If you just change the Collation in the database, then the new Collation applies only to new tables. And old tables need to be changed through a script. The views do not change either.
1 vote -
Return same data as SSMS Messages tab
In SSMS the number of rows affected by a tsql statement is printed to the Messages tab. In dbForge Studio only the number of rows returned to the application is sent to the Output->General window.
The details in SSMS are extremely useful, especially for UPDATE and DELETE statements or other code that returns no data to the application (e.g. selecting rows into a new table).1 vote -
the user should be provided the ability to download the results into an excel.
In the "dbForge Search for SQL Server" product, the user should be provided the ability to download the results into excel.
1 vote -
Clean Field Names on Data Import
Most spreadsheets I get have unsupported characters in column headers - like slashes, line breaks and spaces. It would be great to have the import wizard allow a regex or other way to clean up the columns in a batch. e.g. "sales rep" could become "SalesRep", or "district / group" could become "DistrictGroup"
1 vote -
Ignore File Locks on Excel Files During Import
The Excel file should be copied to a temp file to ignore file locks caused by the file being opened in Excel. The import should allow a refresh at the end of the wizard right before the import begins.
1 vote -
remove one condition from filter list
To be able to remove only one filter condition from the grid (list). Not having to clear the filter and start all over again.
1 vote -
Add progress when executing script
Show somewhere (the status line at least or perhaps in a new status window) the percentage of commands of a script that has been executed.
1 vote -
auto rename tab with regular expression
would it be possible to add a RegEx search in the script to automatically rename the tabs
"^(\s)(CREATE|ALTER|CREATE\sOR\sALTER)(\s\w\s)((([|)..(]|))|)(([|).(]|))\s*$"
1 vote -
Add related tables
The "Add related tables"-function (same as in SSMS) is very useful when creating a database diagram from an old database.
1 vote -
Include a System Procedure folder in a Database Explorer
Database Explorer doesn't include System Procedure folder which would be great to have.
Thanks.1 vote -
helper for json script
Hi, we use a lot of json caluses in our db procedures e.g.:
select
*
into
#parcel_data
from
openjson(@parcelData, '$')
with
(
"ParcelId" int '$.ParcelId',
"ParcelTypeId" int '$.ParcelTypeId',
"ShipmentId" int '$.ShipmentId',
"BarCode" nvarchar(100) '$.BarCode'
);
Why don't You prepare such a helper in dbForge Studio ? It could be located on the level of "Generate script as" menu for each table for instance. To have the possibility to prepare our own plugins would be also a good idea.1 vote -
Implementation of Registered Server Groups
In SSMS, there is a feature called Registered servers, which allows for creation of groups of servers eg. Development, which contains sql server instances for all development servers.
With this option, a user can execute the same script against all the servers in the group.
This can be useful in a scenario such as if you need to execute a query against your database in each of your retail locations.
I would like to see this feature implemented in dbForge Studio IDE.1 vote
- Don't see your idea?