253 results found
-
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 -
Clear google sheet before exporting
Would be great if before exporting data into from SQL Server to google sheets the sheet is cleared, that way if in a second export less rows are exported there are no risk in export duplicates records.
1 vote -
Executing a query across multiple servers
The only thing that prevents me from using DBForge is the inability to run a single sql query on 10 different SERVERS simultaneously and see the aggregated resultset. In SSMS you can simply create a folder and put all of your server connections into that folder and then when you right click on the folder it allows you to connect to all X servers in that folder simultaneously. If you run a top10 query and you have 10 servers configured in that folder you get back a single 100 record resultset. Without a feature like this I can't leave SSMS…
1 vote -
Data Pump pass through imported file name
When it comes to bulk Data Pump imports from multiple files (e.g. Excel, *.csv), I'd really appreciate the ability to pass through the source import file name (as text) to a dedicated column within the destination SQL Server data table against each imported record.
Personally, I use the DevOps PowerShell Automation import pathway and would find it a really handy addition for basic audits if it was accessible as a parameter on Invoke-DevartDataImport
Thanks!
1 vote -
Orderly Fashion Data Pump (From parent to children + referential integrity)
I am trying to do a data pump but once it is finished the data is almost useless because I don't need 1,000 records per-table, but as many as meaningful are, the children records derived from smaller amounts of records in its corresponding Mater or Parent tables
So If have for instance ... let's say Businesses (1) and Stores (2) so I'd like to pump data just for these entities not 1,000 business and 1,000 stores but 1,000 billing records, 10,000 stock count records, 8,000 items catalog for each store ... derived from previous node ... like a tree structure…
1 vote -
As a developer, I'd like to be able to check in custom data generator configurations...
As a developer, I'd like to be able to check in custom data generator configurations with the rest of my project's configuration into source control.
Currently, the xml configuration files are stored in a separate far-off location /Users/Public/... and this makes it not ideal if you want to version your generator configurations to share with the rest of the team through Git, as an example.
1 vote -
I'd like to be able to edit or delete user defined (custom) data generation configurations directly from the GUI
I'd like to be able to delete user defined (custom) data generation configurations directly from the GUI.
Currently, you can create (but not delete, nor edit) user defined custom data generator configurations easily.
Often it is necessary to delete these custom configs because you've created new ones...or saved it too many times...or for other reasons. However, there's no option to delete from the GUI. In order to delete them, you have to find their location and delete xml files found under C:\Users\Public\Public Documents\Devart\dbForge...\Data Generators... there you're presented with only timestamped files with no naming that indicates which user defined generation…
1 vote -
Duplicate query
I would like to see an option on tab context menu. Often I need to duplicate (clone) my query. So another useful option in context menu when clicking on Query Tab would be "Duplicate query" or something like that.
0 votes -
Schema/data comparison user interface
Hi. I'm currently evaluating studio for sql server. OK, i'm primarily interested in schema and data comparison but evaluating the whole studio product. Here's a couple of things which i think would be useful additions/modifications to the UI of the product(s) (schema and data comparison).
- The "recent files" section. I think it would be better if there was a "favorites" section above "recent files" and the user was able to choose whether he wishes to have the "recent files", "favorites" or both sections shown. Also, comparison projects could have an editable title so in the "favorites" section, one could see…
0 votes -
Open schema/data comparison files
Opening a saved or recent file (schema or data comparison) should not start comparing directly but instead open the "Edit comparison" dialog in the Mapping tab, just in case the user wishes to change the items being compared. When using slow connections between servers, this would be very helpful. If you feel may users would not like such a change, it could be made configurable in the application options (a "Don't start comparison immediately when opening a comparison file" checkbox).
0 votes -
Ability to create schema from Database Explorer
Move the functionality of Security Manager to Database Explorer in order to access it in a more intuitive way.
0 votes -
Ability to designate connection as Production and define rules
I should be able to designate a connection as 'Production' and define rules as to which statements are allowed/disallowed.
Production will not allow any DELETE statements. UPDATE statements will need confirmation before they execute.
0 votes -
0 votes
- Don't see your idea?