Change Log (Release)

5.4.2, released 2011-12-16
- chart in table context menu
- data compare function
- new user interface for data synchronization
- compare and synchronize data for one table
- fixed bugs

5.4.1, released 2011-12-04
- code completion for UPDATE, DELETE and INSERT queries
- duplicate table command
- edit column in context menu
- timeline charts
- loading and saving charts, charts folder
- various usability improvements
- persistent window position
- close tab with Ctrl+W
- fixed docking problem under Win7 - 64 bit

5.4.0, released 2011-11-20
- added support for charts
- better paging of data
- some smaller improvements and bug fixes

5.2.7, released 2011-10-23
- BLOB exporter
- improved code completion
- fixed bugs in data synchronization
- fixed rename views and stored procedure for MS SQL
- usability improvements

5.2.6, released 2011-06-14
- code completion in SQL editor
- insert join feature (SQL editor)
- export selected rows and columns in data grid
- some bugs fixes

5.2.5, released 2011-05-31
- refresh operation in connection tree now refreshes all children
- fixed bug in reconnecting
- "revert row changes" command in table data editor now supports reverting more rows
- fixed more bugs

5.2.4, released 2011-05-16
- improved support of views, browsing view columns, use views in query designer, export data, drag & drop data
- fixed serious problems with caching table and view structure
- support of MS Access workgroup databases
- fixed bug - DatAdmin didn't see objects created with new-style schema (in MS SQL 2005 and higher)
- fixed some bugs in data synchronization

5.2.3, released 2011-05-04
- export table data into new table
- create table from file (CSV, XML, DBF)
- fixed remembering exported file name
- fixed bugs in versioning
- ability to override data and app data directory 

5.2.2, released 2011-04-27
- French localization
- new user interface for structure synchronization
- commit and rollback buttons in query editor
- compare database versions in database versioning

5.2.1.1, released 2011-04-16
- fixed bug in importing MySQL data
- fixed bug in analysing SQLite, Postgres and Generic database

5.2.1, released 2011-04-14
- fixed bug in saving table data
- fixed bug in deleting MS SQL database (database could not be deleted from 5.2.0)

5.2.0, released 2011-04-13
- optimalized loading structure, mainly for MySQL, MS SQL, Oracle
- optimalized displaying dashboards
- DBF export and import
- some fixes in Oracle support; correct work witbh datetime and interval values
- added error codes for easier referencing in support requests
- many smaller enhancements and bug fixes

5.0.7, released 2011-03-27
- added support to MySQL 5.5
- MySQL - formatting views when modifying or showing in dashboard
- MS SQL - support for inserting values into identity columns (applies in data editor, synchronizing, versioned database)
- some minor bugfixes 

5.0.6, released 2011-03-20
- added support for Oracle 9g, 10g, 11g database
- fixed some bugs

5.0.5, released 2011-03-13
- fixed bugs in bulk copy wizard (copy data between different tables)
- added browse folder popup menu command
- improved connection using generic providers, like ODBC and OLE DB. 
- better handling of data types, which cannot be recognized by DatAdmin
- fixed some internal errors 
- improved usability, when connecting to file based databases (SQLite, MS Access, EffiProz)

5.0.4, released 2011-03-08
- fixed bug - extremely slow rendering of tables with some NVIDIA drivers
- optimalizations, bugs fixes

5.0.3, released 2011-03-01
- improved work with database diagrams. Images have better quality. Each table can have own color style. Multiple selection in diagram editor.
- online help system. This help is context-sensitive referenced from DatAdmin
- fixed bug in work with EffiProz triggers
- fixed some minor bugs in SQL generators 
- master/detail views and database models moved from Personal to Professional edition

5.0.2, released 2011-02-20
- new icons, new modern face
- removed drag & drop panel, added object clipboard instead
- fixed bug, import data into table with time column on MS SQL 2008 failed
- improved data search, new option exact match. Fixed problems, when search text contains special characters
- removed obsolete HTML help files, replaced by online help 

5.0.0, released 2011-02-14
- new dashboards for servers, databases, tables and views. Dockable layout.
- Powerful SQL generating dialog
- (PRO) Dashboard designer, added widget concepts
- (PRO) Table perspectives can hold information about layout of master/detail frames, perspectives are shown in connection tree 
- reorganized context menus, grouping of similar features
- SQL window - new status bar

4.4.6, released 2011-01-05
- EffiProz upgraded to 1.5
- improved importing EffiProz SQL dump, recognizing \ command separator
- fixed bugs in table perspectives
- minor bug fixes 

4.4.1, released 2010-11-28
- PHP tunnel was renamed to HTTP tunnel. A logic has a bit changed, properties of tunnel can be set in MySQL connection
- Improved SQL dump generating and loading, especially for MySQL and MS SQL
- Ability to hide Samples folder
- Many bugs fixed
- Ability to use SQL dump backups

4.4.0, released 2010-11-22
- New concept in browsing data - table perspectives, restricting columns
- Better error handling in data browser
- Many smaller bugs fixed
- Added Chinook sample database

4.2.2, released 2010-11-03
- Job Manager window, allowing executing more jobs or commands, comfortable managing jobs, exporting shell scripts
- Favorites toolbar and menu
- Added reporting capability to jobs
- E-mail support (files and job reports can be sent as attachments)
- Parametrized file names in exports (you can parametrize file name eg. using current date or generated GUID)

4.2.1, released 2010-10-24
- professional edition: added query history
- database versioning: added new wizards, added posibility to have diagramsx for last version

4.2.0, released 2010-10-23
- added support for EffiProz embeded database engine
- new query builder, condition builder, quickly add referenced tables
- improved PHP tunnel connection engine, it's now quit good working also on unreliable webservers
- improved data synchronization, added posibility to export script instead of do real synchronization
- new tabs in summary - info about selected objects, eg. table sizes for MS SQL 
- fixed many smaller bugs    

4.0.0, released 2010-09-19
- added quick exports, defining custom export
- improved export, import target/source
- Ultimate edition splitted into products Data synchronization and Database versioning

3.8.2, released 2010-06-27
- many improvements of query designer, design is now saved
- improved PostgreSQL support: bulk insert (better performace), sequences, arrays and PostGIS types support
- many small usability improvements, fixed some serious bugs in UI

3.8.1, released 2010-06-13
- fixed bug in showing data in MS Access
- fixed bug in startup in new installations

3.8.0, released 2010-06-06
- SQL scripts manager, saving script context (connection + current database)
- parametrized queries (using syntax ###PARNAME###), when executing, DatAdmin asks for parameter values
- show primary && foreign keys, not null/null columns when browsing data
- advanced data synchronization (only Ultimate and Trial edition)
- better scheduling using DatAdmin service, history of executed jobs (only Ultimate and Trial edition)

3.6.2, released 2010-04-07
- configurable order of table copying
- added capturing of MS SQL output, better reporting of errors in query (in case if error is in trigger or stored procedure)
- duplicating row in data editor
- row numbers in data editor

3.6.1, released 2010-03-10
- dependency browser (only Proffesional and Ultimate editions)
- fixed problems with recovery views from backup on MySQL, when views are dependend
- windows list
- view and change collation of database (MySQL, MS SQL)
- copy & paste more cells in table data
- fixed problems with strange behaviour of keyboard focus, when editing data
- fixed bug in editing foreign keys
- next small bugs and improvements 

3.6.0, released 2010-02-21
- changed design of main window, using dockable documents and tool windows
- reference windows now uses dockable documents => sorting, filtering, editing and lookups are available for references
- cascade and multiple reference views
- MS SQL native backups, restore, Backup explorer (from Proffesional edition)
- connection using named ODBC connnection
- better restore db dialog
- phantom databases (data on disk are available also when database is dropped)
- added database model find & replace feature
- fixed bugs in synchronization
- added scripts before/after change without FK folder in database versioning model
- fixed bug in importing MySQL dumps
- fixed some problems with broken connections

3.4.8
- connection using named ODBC connnection

3.4.7, 2010-01-13
- fixed bug - MS SQL, when updating unicode string
- fixed bug - MS SQL, when using uniqueidentifier type
- fixed bug - MySQL - lost decimals of float and real type
- other small bugs fixed

3.4.6, 2009-12-21
- added Italian translation
- added specific syntax hightlighter for SQLite and MS Access
- applying specific syntax highlight 
- added send feedback window
- when migrating logical type to MySQL, tinyint is used (former bit was used)
- fixed some problems with processing bitfields on MySQL
- fixed problem with long view definitions on MS SQL
- some GUI bug fixes and small improvements
 
3.4.5, 2009-12-07
- fixed bugs in synchronization
- DatAdmin now can directly import SQL dump from mysqldump or phpMyAdmin
- fixed bugs in working with indexes and keys under MySQL
- removed Generic SQL dump, SQL dump should be used instead (with appropriate dialect)
- MySQL native dumper now allways calls mysqldump.exe (removed property Use Client Tools),
  for dumps created by DatAdmin SQL dump target can be used
- ability to load query as SQL dump (from query editor)
    
3.4.4, released 2009-11-30
- added support for run in 32-bit mode under 64-bit windows
- small improvements for running on linux
- fixed bug in loading MySQL comments