301 results found
-
In schema synchronization script add new columns before dropping old ones
When generating schema synchronization script, add new columns (which are existing in the Source object and are missing in the Target object) before dropping old ones (which are existing only in the Target object).
This will preserve data integrity.
1 vote -
Export and import all server definitions, in case we need to change machines
We need a way to export all or a subset, of our servers and be able to reimport them at another box, like our laptop. I need to travel for a month and I have too many servers to do it manually
1 vote -
1 vote
-
Select all rows in a result windows by clicking on a top left corner
Select all rows in a result windows by clicking on a top left corner. Right now clicking on the square does not do anything. It would be a very convenient way to copy all rows into clipboard.
1 vote -
Support replace in data editor
So far I have never been able to reaplace a value with Search&Replace.
And yes, the tables are editable.
I can only Search (and find) but reaplace button NEVER works.1 vote -
Pivot Table Generate (DDL/Scheme) to export SQL.
Example:
http://www.codeproject.com/Articles/363339/Cross-Tabulation-Pivot-
Tables-with-MySQL1 vote -
Restore scrollbar position after refresh `object update`
Needs to Restore scrollbar position after refresh
object updatepressed.
Point: open data view on table with many rows and columns, then list it to some position for viewing certain data. Then this data changes by outside query and I need to view changes for that. After I pressupdate databutton, then data table position skipped to begining even the number of rows still same and only cell values had been changed.1 vote -
Convert a LINQ query to Stored Proc/View
A great feature would be a LINQ to SQL tool for SP/Views.
I write complex queries in LINQ with linqPad, grab the generated SQL and then create a SP/View from this code.
It's an error prone process with complex queries creating parameters
1 vote -
when debugging stored procedures, pass data to the procedure by string instead of a table input
It seems that data passed to a procedure can only be done via table input instead of by string as would be carried out by callableStatement in java. Otherwise awesome work.
1 vote -
It would be more reasonable if wizard has also a direct sql optimizer
It would be more reasonable if wizard has also a direct sql optimizer
1 vote -
select as default when i right-click on a table
the context-menu should on top always display - "select data" (not retrieve?? - no other product shows this option)
currently, if i right click on a table - on top is "new table" which is ok when i select "tables" but here it is senseless.
1 vote -
Allow per column, per table grid display configuration
We work with tables that need to display the data in a format that is meaningful to us. Default display in grids doesn't cut it these days.
Allow us to add custom display formats for any field including binary. This could be done by maintaining a small embedded database per table and column. Then allowing a dialogue to select or enter new formats.An extension to the configuration dialogue for date time display could be a starting point.
Once done, this configuration can be applied to any column and any table.
Doing this would instantly cure all the feature requests…
1 vote -
1 vote
-
data comparisons, use foreign keys, save script
In Data comparison wizard there is the oppotunity to filter a table.
1. I want to create a Dump for only one Person-Dataset with all datasets of other tables that have a relationship to this person using foreign keys.
2. I want to save this script to reuse for other Person-IDs1 vote -
Option SkipSchemaName for Schema Comparison
When running Schema Comparison it would be handy having an option for skipping schema name. Currently, the same procedure in two different databases comes up as different if refereed tables (and other) are qualified with schema name.
1 vote -
top n by column
when i use a table,
i will open this table to issue something whatever,
if we have this
"top n by column" features
i can open it fastly.1 vote -
Create T4 Templates for WebAPI.
It would be great if there were T4 templates for generating Microsoft WebApi endpoints reather than MVC controllers. MVC is ok but amI, as I a im sure more and more developers are, creating client apps which access data via web apis or similar. Of course the advantage of this it that these webapis dont care what the client is and the client dosent care what is behind the webapi.
1 vote -
Make the restore database have the option to ignore errors
Make the restore database have the option to ignore errors, so easy can fix minor mistakes without having to redo the backup
1 vote -
Allow resize of "Recent Files" panel on start page
I'd like to be able to resize this panel without the need to hover over the item. Very, very minor item. Thank you.
1 vote -
Skip column when using the 'Fill mapping' feature during data import
During import of CSV data (and possibly other formats), one can use the 'Fill mapping' feature to automatically assign columns.
This also works if the source columns are unnamed, however, the columns are filled in order starting from the first. There is no option to skip a specific column (e.g. identity column).Now, I have a large table with lots of columns. When importing, I wish to skip the first (ID) column and assign the source columns starting at the second target column, as the CSV file does not include an ID column.
1 vote
- Don't see your idea?