Softpedia >Windows >Portable Software >Database Utils >Portable DbViewSharp >  Changelog

Portable DbViewSharp Changelog

What's new in Portable DbViewSharp 1.4

Dec 14, 2012
  • Add Export and Import of data:
  • This upgrade allows you to export data from a table to a CSV file and import data into a table from a CSV file. It was designed to facilitate transfer from a SQL Server database to a SQL CE database, but of course has many more applications. The functions are accessible from the table right-click context menu and are fully documented in the User Guide.
  • Create a Portable DbViewSharp on a Penstick:
  • Scenario. You are on the move. So you put DbViewSharp on a USB stick. But this means creating new database connections each time as it looks in the account application folder of the machine you insert the penstick into. This feature automatically creates a copy of DbViewSharp on a penstick together with a copy of the configuration file.
  • Adding an XML field to text search does not work:
  • Previously adding a column of SQL Datatype XML to the text filter list of a view was permitted but caused the SQL to fail. This upgrade fixes the problem by casting the XML type to NVARCHAR(MAX) so that you can search for elements, attribute names and data in XML fields.
  • Rewrite of back and history module to act more like a browser:
  • Cleared a few errors in way navigation back to previous grids worked. Added a check to the back button drop-down menu item to illustrate the position of the current grid in the history. Improved the history grid presentation.
  • Bugs fixed:
  • Field descriptions do not work with schemas. Now fixed.
  • Script table fails if a table belongs to a schema and has a default constraint. Now fixed.
  • Removing a column from a table breaks a view that uses it forever. When a saved data view is broken by the removal of a field from its table this can be fixed now by running Data, Fix Bad Views.
  • Quickdiff will fail if insufficient permissions. It displays a warning now and does not attempt the operation.
  • All source search will now find items enclosed in single-quotes.
  • Untrapped exception during edit. The error is now trapped and explained.
  • Driver change not recognized on subsequent launch of DbViewSharp. The bug happened only where you have a SQL Server connection and a SQL CE connection with the same name. Now fixed.

New in Portable DbViewSharp 1.3 (Sep 21, 2012)

  • Developer Mode:
  • This upgrade relaxes some previous self-imposed restrictions that kept the app safe for browsing non-development databases. Now by explicitly setting a "Development database" flag on a connection a user can activate all the unsafe schema changing options and a smoother data-edit functionality on a carefully selected subset of connections. In developer mode it is possible to add or remove tables, columns and schemas. Data in tables is editable by default instead of requiring a keypress or menu function to activate editing.
  • Issue 63 - Extend the table report to be more like explorer:
  • The table list has additional fields showing table creation and last update dates. Furthermore the number of rows in a table is now displayed when connected to databases with read-only permission.
  • Issue 43 - Ad-hoc window move to the application main window:
  • The adhoc query window has been moved into the application from being free-floating window. This improves the management of the display. The adhoc window can now be opened from a toolbar icon and possesses its own toolbar. The keyboard interface also has been improved. Right-click copying has been implemented for the result grid.
  • Issue 40 - Add support for ORM use:
  • There is now a facility for generating C# code for Entity Framework and LINQ2SQL from a table definition.
  • Issue 65 - Documentation upgraded:
  • Before this upgrade the documentation was patchy and extremely out of date. This upgrade includes a new DbViewSharp User guide that covers general operation in depth, all toolbar and main menu options and nearly all of the context menu items. In preparing the guide a dozen or so minor problems or inconsistencies were logged and these are fixed in the upgrade. Access documentation from the Windows program menu.
  • Sundry smaller issues fixed:
  • 82 Quick diff for foreign keys was badly broken.
  • 79 Jobs grid sql fails in case-sensitive database
  • 74 Toolbar back button duplicates entries
  • 72 Bug: Field list selector does not prefix correctly
  • 60 Fields report doubles "length" of NChar and NVarchar fields
  • 57 Add escaping to table data SQL
  • 56 Cannot filter the results of a view source search
  • 53 Remove trailing comma from comma-list built in the Copy to comma-list tools option.
  • 54 Upgrade versioning and about box.
  • 59 Add functions to view and create schemas
  • 52 Sort out the naming of the app. All displays and documentation refers to DbViewSharp now.
  • 51 Filter text search not working in Dependencies report
  • 49 Right clicking in the empty row when the grid is in edit mode causes an exception
  • 41 Preserve original font setting when pasting SQL into the Ad-hoc window
  • 31 Add web config format right click to connection menu
  • Tidied positioning of some message boxes and dialgs
  • Improved support for wierd table names (eg SQL reserved words or with spaces),
  • Added tooltip help to the connection dialog and extra help to context menu options.
  • fixed a bug in table scripting where a non null field was scripted as allowing nulls.
  • changed procedures code to reveal more system stored procedures in the master database.