267 results found
-
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 -
Copy Columns in the table designer the same way you can in MS SSMS
In MS SSMS I can select multiple rows in a table definition and then do a Control-C to copy those definitions. I can then go to a different table (or even the same table) and paste the definitions in.
I typically have 4 columns that are always on my tables (DateCreated, CreatedByID, UpdatedByID, and UtcTimestamp) and it's easier to just copy them from another table then to enter them in by hand every time I create a table.
1 vote -
Multi-Select rows in the Table Editor
I want to be able to multi select rows in the table editor so that I can delete them all at one time.
1 vote -
More details on Warnings
I added new fields and moved them up, it gave me a warning of "The object requires rebuilding, this may result in the loss of some properties.". Is there a way to tell what properties those are or is it just an warning that might not even exist?
This feels like a CYA warning message. If I'm going to lose something, it would be nice for me to know what it thinks I'm going to lose.
1 vote -
Add Spell Check to Column Names, Table Names, etc...
If I have column names or table names like
MyTabel, it should be able to split it apart at the capitalizations and tell me that Tabel is spelled incorrectly and offer suggestions on how to fix it.
Same goes for Table Names, Stored Procedure Names, etc...
1 vote -
DISTINCT and TOP formatting
EDIT: Apparently this editor doesn't support any formatting?
I want DISTINCT and TOP to line up with the first column not with SELECT.
So this:
SELECT
DISTINCT
TOP 100
t.[TraineeName]would be
SELECT
DISTINCT
TOP 100
t.[TraineeName]1 vote -
create schema
From the Database Explorer > DatabaseName > Security > Schema, be able to right-click and Create New Schema
1 vote -
SQL Editor - add word wrap option
I would suggest that the possibility of having in the editor the features of "Word Wrap" and "Show visual glyphs for word wrap" as they exist in the editor of Visual Studio be added.
1 vote -
Existence logic needed for triggers
When a new trigger is created, the script tests for existence first. So if the trigger does not exist, it will not create it. It should not test for existence as it will never create the trigger. It's unnecessary to check the object's existence if the product is using CREATE OR ALTER trigger.
1 vote
- Don't see your idea?