381 results found
-
Add schema comparison option to ignore CLR objects
Add an option to the Schema Compare feature to ignore CLR objects(CLR Type, CLR Procedure, CLR Function, Aggregate Function).
Note that the option shouldn't affect usual objects (Function, Procedure, User data type, User table type).
0 votes -
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 -
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
-
Identical records visibility in data comparison
In data comparison options, there is an option (Display Options) to show / hide Identical records before starting the actual comparison.
My wish is to have another option to Display Identical Records only in the lower part of the results screen (where the data are shown) and not in the upper part (where the tables that are different are shown. In the upper part it's somewhat confusing to have the Identicals column while in the lower part is actually very useful.
0 votes -
Support scrolling and moving for Plan diagrams
Some scripts creates very large Plan diagrams. I can zoom with my mouse and scroll vertical. I can't move / pan the diagram or scroll horizontal. (Version 5.0)
0 votes -
0 votes
-
display relation lines aligned to table columns
For documenting purposes I need database diagrams to show relation lines precisely aligned to their corresponding columns.
When a foreign key relations is composed of two or more columns, I need two or more lines to be displayed on the diagram, one for each column. I'd prefer to have all lines of that same foreign key constraint being displayed using the same, distinct color, so they will be recognized as belonging to the same foreign key constraint.
0 votes -
0 votes
-
Add button to refresh database list
After restoring a new database this one is never available in the search tool. It takes a reboot off SQL server.
A button to refresh the database list would be helpful.0 votes -
Make Documenter include db diagram
Can documenter include the db diagram? or is it only text?
0 votes -
Ability to generate documentation for SQL Server Agent and SSIS packages
I'm getting ready to migration from MS SQL 2012 to MS SQL 2016 and really missing the ability to generate documentation for SQL Server Agent and SSIS packages (both on a server and file system) with the SQL Documenter feature.
There are situations when jobs and packages referring to obsolete servers are still existing on actual servers.
0 votes -
option to generate data for updateable views
No option to generate data for updateable views
0 votes -
Search or Navigation in Database Diagram
It would be convenient to be able to search or navigate through the database diagram, similar to class navigation in Visual Studio.
0 votes -
Command to better see table and its dependencies on Database Diagram
It would be nice to have a command in the popup menu allowing to see the table along with its dependencies. I.e., to zoom it out in order to fit on the page and make the other tables transparent or something like that.
0 votes -
option to calculate values based on other columns in data generator
(for example totalprice=unitprice+tax)
0 votes
- Don't see your idea?