Database .NET 19.5.6114

Ver 15.7 (2015/06/01) Stable Version
- SQL Efficiency Analyzer ( SQL Profiler ):
Add: Support MySQL (5.6.7+) overall database analytical processing ( Global Mode ), the other an old version remains (Session Mode) (5630)
Upd: Instant update your browser to keep the last 10 000 pen record, when exceeded will automatically delete the oldest record, to avoid affecting the performance and take up too much memory (5630)
Upd: a lot of code optimization and improvement process in order to improve the overall efficiency and stability (5630)
- SQL Server Backup and Restore process ( Backup Manager and Restore Manager )::
Upd: 1. path location memory processing, 2. Restore the database can handle key actuation (5630)
- Search and Replace function ( Quick Find and Replace ):
Fix: Fixed When changing the size of the main window, you can not move with the issue (5630)
Fix: Fixed (5614) led to replace the function of the problem can not be opened (5630)
- Object Browser ( Object Navigator ):
Fix: When (DB2 / Informix) correction data table names are case differ, the problem can not obtain information on the table fields (including script generation) (5630)
Upd: built-in data type VarChar dBase correct length maximum (255> 254) (5630)
Upd: Improved use double-click on the click node problem caused when the original (5623) omission to update (5630)
- Main program update ( Main ):
Upd: Connection Settings Properties (Connection Properties): increase set attributes Description Display (Property Desctiption) (5630)
Upd: Question dialog box optimization process, leaving the windows did not shut down and then return, be sure to stay in the upper display (5630)
Upd: SQLite element version update to System.Data.SQLite.dll 1.0.97.0 (3.8.10.2) (2015/05/26) (5630)
Upd: Accumulated other contains minor updates, corrections and optimization (5630)
Upd: Update Database .NET Additional Files ( ) (2015/05/30)
Misc: Compatible with SQL Server 2016 CTP2 (2015/05/29)
Misc: Compatible with MySQL 5.6.25 (2015/05/29) / MySQL 5.5.44 (2015/05/29)

_http://fishcodelib.co...tabaseNet4.zip

Ver 15.8 (2015/06/09) Stable Version
- AutoComplete and perception ( AutoComplete and IntelliSense * ):
Upd: Improved and corrected when JOIN multiple data tables, allows you to specify the data sheet (or alias) field sensing process (5638)
- Auto braces complete ( Automatic Brace Completion ):
Upd: after the display at the auto-complete and has been selected projects to support first inserted automatically selected project completion process (5638)
- Servo Edition database connection settings ( Connection Profile ):
Add: increase exemplified Informix database functionality built (5638)
Fix: Fixed issue new name if the connection is set with a different database of the same name, the original settings will be overwritten (5638)
- SQL editor ( SQL Editor ):
Upd: SQL format plug-in command processing switch database link Edition ( SqlFormatterLibrary35 ), while addressing the needs of the environment problems in .NET 3.5 (2.0) in order to use the (5638)
- Search and Replace function ( Quick Find and Replace ):
Fix: Fixed in the main window closed under scaling moves not reopen the issue (5638)
- Main program update ( Main ):
Upd: (DB2 / Informix) increase DECIMAL (precision, scale) data type precision processing (including browsing the generated object code and instruction) (5638)
Upd: (DB2) updated LONG VARCHAR FOR BIT DATA data type handling (including browsing the generated object code and instruction) (5638)
Fix: (DB2) can not be made ​​to improve the built-in handle DECFLOAT data types of problems (including browsing the generated object code and instruction) (5638)
Upd: (DB2) rewrite data table field approach, while improving read speed (5638)
Upd: (SQLite) data type update Synonym (num-> numeric) (5638)
Upd: Update Browse [all] database mode ( Browsing All databases ), made ​​rootnode of treatment (5638)
Upd: Accumulated other contains minor updates, corrections and optimization (5638)
Upd: Update Database .NET Additional Files ( ) (2015/06/08)
Misc: Compatible with PostgreSQL 9.4.3 / 9.3.8 / 9.2.12 / 9.1.17 / 9.0.21 (2015/06/04)

_http://fishcodelib.co...tabaseNet4.zip

_http://fishcodelib.co...tabaseNet4.zip

Ver 16.0 (2015/06/29) Stable Version
- Object Browser ( Object Navigator ):
Add: to solve the data type SQL Decimal precision than when SYS Decimal itself length (> 29), lead to the normal display problems and edited (5658)
Support contains SQL Server / SQLAzure / SQLCe / MySQL / PostgreSQL / Oracle / DB2 / Informix / Teradata / HP Vertica database system, etc.
Upd: (HP Vertica) increase DECIMAL (precision, scale) data type precision processing (including browsing the generated object code and instruction) (5658)
Fix: (Informix) amended DECIMAL (precision, scale) data type precision processing (including browsing the generated object code and instruction) (5658)
Add: Advanced Browse / Edit option ([ADV] Advanced Browsing / Edit Options): increase Oracle Virtual Columns (ORA_ROWSCN) display (5658)
- Batch script generation ( Generating Batch Scripts ):
Upd: automatic sorting sequence associated data sheet (Auto Order by referenced tables), the resulting data sheet can be sequentially build (5658)
Fix: (SQL Server / SQLAzure / SybaseASE) index instruction code generation: Fixed an index file name contains characters, and settings for the front when the structure described name (5658).
- Information column editing ( Data Editor ):
Upd: When (Oracle) without a primary key (PK) update and delete process, ROWID as conditions changed to search processing (5658)
Upd: after time (Oracle) edit field contains ROWID, new rows of data automatically updates the field contents (5658)
- Browse [all] database mode ( Browsing All databases )
Fix: Fixed expand and collapse this mode the master node [Click the button] process ( Single-Click button ) invalid Issues (5658)
Upd: Updated rootnode this mode is selected correlation processing (5658)
- Main program update ( Main ):
Upd: (Oracle) item processing establishment and when updated to support more detailed error and warning message is displayed (5658)
Fix: (Oracle) Correction (5646) led to the end of SQL command END; when character; automatically remove the problem (5658)
Fix: (Oracle) all synonym V $ obj object into an actual object name SYS.V_ $ obj, resolved if the structure described below: Question (Schema SYS) not normally accessible (5658)
Upd: Firebird element version update to FirebirdSql.Data.FirebirdClient.dll 4.6.4.0 (2015/06/27) (5658)
Upd: Oracle component version update to Oracle.ManagedDataAccess.dll 12.1.22 (2015/06/23) (5658)
Upd: HP Vertica element version of the update to Vertica.Data.dll 7.1.2 (2015/05/29) (5658)
Upd: Accumulated other contains minor updates, corrections and optimization (5658)
Misc: Compatible with SQL Server 2016 CTP 2.1 (2015/06/25)

_http://fishcodelib.co...tabaseNet4.zip

_http://fishcodelib.co...tabaseNet4.zip

Ver 16.0.5667 (2015/07/08) Stable Version
- Connection Settings ( Connection Profile )
Upd: After wiring the specified code function ( Execute scripts When connected ): change in non-transactional mode processing (5667)
- SQL editor ( SQL Editor ):
Upd: Optimization of heavy brush via SQL scripts browse object processing, significantly increasing processing speed batch script (5667)
- Column editing and browsing data ( Data Editor and Browser ):
Fix: Fixed (5658) data type SQL Decimal processing problems may affect different types of databases with system (SYS Money / Currency) display (5667)
- Main program update ( Main ):
Fix: Fixed Form Editor ( Form Editor * ) editorial content included dealing with exceptional character of the (5667)
Upd: Improved change the default font size is displayed after the relevant update (5667)
Upd: Accumulated other contains minor updates, corrections and optimization (5667)
Upd: NuoDB element version update to NuoDb.Data.Client.dll 2.3.0.3 (2015/07/03) (5667)
Misc: Compatible with SQL Azure 12 (2015/06)

_http://fishcodelib.co...tabaseNet4.zip

- AutoComplete and perception ( AutoComplete and IntelliSense * ):
Upd: optimization of the CROSS JOIN, CROSS APPLY, NATURAL INNER JOIN, JOIN and other fields aware processing (5679)
Fix: Fixed objects can not perceive the problem length of the field at the same time when a band Alias ​​(5679)
- Form editor and browser ( Form Editor and Viewer * ):
Add: Form Editor (Form Editor): increase of the field data type is XML editing and import processing (5679)
Upd: Auto Arrange support zoom window display processing time field (5679)
Fix: Fixed form editor to edit the contents included dealing with exceptional character of the (5667)
- Column editing and browsing data ( Data Editor and Browser ):
Upd: Information under column editing allows direct editing field data type is XML data format (5679)
Upd: New additional field data type is XML and when NOT NULL, support the use of grid data editing process ( Cell Editor * ) (5679)
Fix: Fixed (5658) data type SQL Decimal processing problems may affect different types of databases with system (SYS Money / Currency) display (5667)
- Data Definition Language ( Data Definition Language (DDL) ):
Upd: When (Oracle) while generating data table and index definitions, index definitions to avoid problems UNIQUE iterative process (5679)
- Connection Settings ( Connection Profile )
Upd: After wiring the specified code function ( Execute scripts When connected ): change in non-transactional mode processing (5667)
- SQL editor ( SQL Editor ):
Upd: Optimization of heavy brush via SQL scripts browse object processing, significantly increasing processing speed batch script (5667)
- Main program update ( Main ):
Upd: Improved change the default font size is displayed after the relevant update (5667)
Upd: NuoDB element version update to NuoDb.Data.Client.dll 2.3.0.3 (2015/07/03) (5667)
Upd: Accumulated other contains minor updates, corrections and optimization (5679)
Misc: Compatible with SQL Azure 12 (2015/06)

_http://fishcodelib.co...tabaseNet4.zip

- Main Program Update ( Main ):
Add: Integration dbMigration .NET - A universal database migration tool [!] Universal Database migration tool (5713)
ps. DBMigration.exe must be in the same directory as Database4.exe
Add: Progress window minimize the main window to increase the function keys ( Minimize Main Window ): easy to be handled in the context of the (5713)
Fix: Fixed When [schedule] window display minimize [main] window, when the reduction will lead to progress window not properly closed issues (5713)
Fix: Fixed avoid the repository object failed to load, the program can not continue to cause problems processing (5713)
Upd: Open VIEW object contains multiple data tables when editing, post during browsing, click Cancel process will not continue to turn the rest of the data table (5713)
Fix: (Access) correction can not browse the [field contains the data table name] VIEW object processing (including other similar process) (5713)
Fix: (Firebird) Correction (55xx) lead to data table properties page message display (Statistics) issue stalled (5713)
Upd: (Firebird 3.x) to update user-defined data type object display (User-Defined Data Types) (Domains) (5713)
Upd: SQLite element updated to System.Data.SQLite.dll 1.0.98.0 (3.8.11.1) (2015/08/19) (5713)
Upd: IBM DB2 / Informix element updated to IBM.Data.DB2.dll 9.7.4.4 (10.5.6.4) (2015/08/17) (5713)
Misc: (IBM DB2 / Informix) IBM Data Server Client Packages Version 10.5 Fix Pack 6 (2015/08/17)
Upd: NuoDB element updated to NuoDb.Data.Client.dll 2.3.0.4 (2015/08/17) (5713)
Upd: MySQL element is updated to version 6.9.7 MySql.Data.dll (2015/08/05) (5713)
Upd: Accumulated other contains minor updates, correction and optimization (5713)
- Data definition language ( Data Definition Language (DDL) ):
Upd: (Firebird) when the text type of field coding is different from the preset library will display its encoded form (CHARACTER SET xxxx) (5713)
Upd: (PostgreSQL) subdivision Serial (automatically generated) and integer (custom build) sequence object (nextval'xxxx ') processing (5713)
- Batch script generation ( Generating Batch Scripts ):
Upd: Update Sequence objects (SEQUENCES) display order to facilitate priority when checking (5713)
- AutoComplete and perception ( AutoComplete and IntelliSense * ):
Upd: Improved User Experience: Data tables and fields automatically sense the process, are the recommended mode (Suggestion mode) display Regardless of the setting (5713)
Fix: Fixed (569x) cause problems AutoComplete text mode settings can not be displayed properly on the (5713)
- The tying SQL statement variables ( Binding SQL variables ):
Fix: Problems omissions supported under (SQLCe) Correction trading patterns (5713)
- Information column editing ( Data Editor ):
Upd: edit or import the field is numeric type (Numeric), but data show Brin type (Boolean) when the automatic conversion process (5713)
Fix: (Informix) to solve new problems and update content material if containing newline (CRLF) characters, can not be successfully treated (5713)
Upd: Data Grid Editor ( Cell Editor * ): joining save failed exception message display processing (5713)
- Data Import ( Data Import ):
Fix: Right menu directly into the data table processing: 1. Support the specified field in the first column or not processed, 2. Data content analysis processing with Preview Import Processing (5713)
Fix: (HP Vertica) [temporarily] batch import can not solve the problem of (5713)

_http://fishcodelib.co...tabaseNet4.zip

- SQL editor ( SQL Editor ):
Upd: significantly improve the speed of processing text search to solve a serious impact performance when searching the contents of a larger issue (5725)
- Data Import ( Data Import ):
Upd: Support Import failed retry processing (5725)
- Column editing and browsing data ( Data Editor and Browser ):
Show Exclusions wrong question correction Microsoft.SqlServer.Types field data is NULL (5725): Fix
- Data definition language ( Data Definition Language (DDL) ):
Upd: Updated data sheets Notes (Table comments) generation problems (5725)
Fix: Fixed (5695) omit GO processing exclude (SybaseASE / DB2 / Informix / Teradata) and other repositories, because of their built-in batch processing is not complete with the rules (5725)
- Main Program Update ( Main ):
Upd: Improved servo version repository after [New] Connection failure handling (5725)
Upd: Improved User Experience: The original part of the function to the Edit menu to move to the next file menu (Edit: Open / Save / SaveAs -> File) (5725)
Upd: middle mouse button to close the tab (Middle-Click to Close Tabs): changed to directly close the mouse is pointing tab (5725)
Show the improved tab handling sequential Close (5725): Upd
Fix: issues related to the multi-screen (Multiple Monitors) when the main display is set in [R] when the amendment (5725)
Upd: (IBM DB2 / Informix) Update PROCEDURE / FUNCTION open design (Design) generated UPDATE syntax (5725)
Upd: (Excel) When you create a blank database, first as a field name no longer need to ask (5725)
Fix: (Excel) Correction (5393) results can not add a blank database issues (5725)
Upd: PostgreSQL components updated to Npgsql.dll 2.2.6 (2015/08/27) (5725)
Upd: Accumulated other contains minor updates, correction and optimization (5725)
Misc: Compatible with SQL Server 2016 CTP 2.3 (2015/09/02)

_http://fishcodelib.co...tabaseNet4.zip

- SQL editor ( SQL Editor ):
Add: When adding file changes when the outside environment detection (Detect when file is changed outside the environment) (5742)
Upd: unified process newline characters (carriage return (CR) and line feed (LF)), to avoid the parsing error (5742)
Fix: Fixed (5725) led to replace all word processing (Replace All) produces the wrong question (5735)
- Database migration ( Database Migration ) (Pro):
Upd: Information row migration (merger) process (Appending rows):
Add: allows the [same] source and destination connection, [different] columns data sheet consolidation process (5742)
Fix: (SQLCe / SQLAzure / SQLServer / Sybase) correction data column can not be merged when the problem data sheet containing the auto-increment fields (IDENTITY) of (5742)
Upd: source and destination data table the same as the auto-increment field (AUTO_INCREMENT), will retain the source increment value (5742) non-merger
Fix: Fixed some source repository status bar is not displayed correctly (NOT NULL) of (5742)
Upd: Improved Decimal data type Maximum processing, when the source of the field length exceeds the purpose of field, automatically takes the maximum value for the purpose of data fields (along with other data types) (5735)
- Display informational message ( Displaying informational messages ):
Upd: avoid problems repeating the same message is displayed (5735)
- Main Program Update ( Main ):
Fix: (Teradata) to solve the problem can not be processed CREATE / REPLACE PROCEDURE statement of the (5742)
Fix: Fixed Teradata script generated content, if unable to complete more than one row contains a problem is displayed (5735)
Upd: Improved Teradata database provide a more complete error message is displayed (5735)
Upd: PostgreSQL components updated to Npgsql.dll 2.2.7 (2015/09/18) (5742)
Upd: NuoDB element updated to NuoDb.Data.Client.dll 2.3.0.6 (2015/09/15) (5742)
Upd: Firebird components updated to FirebirdSql.Data.FirebirdClient.dll 4.8.0.0 (2015/09/14) (5742)
Upd: Teradata components updated to Teradata.Client.Provider.dll 15.11.0.0 (2015/09/08) (5735)
Upd: Update Database .NET Additional Files ( 32bit / 64bit ) (2015/07/31)
Upd: Accumulated other contains minor updates, correction and optimization (5742)
Misc: Compatible with NuoDB 2.3.1 (2015/09)
Misc: (Pro) New Database .NET Professional (64bit) ( Native 64bit and Built-in Database Migration )

_http://fishcodelib.co...tabaseNet4.zip

- The main program update ( the Main ):
Add new Firebird database-specific connection settings ( New Firebird Connection Profile ) (6109) Add: Support Windows login authentication mode (Windows authentication (Win_Sspi)) ( 6109)
Add: Support for individual library to a different user account login process (6109)
Add: Support Custom Port Settings (6109)
Add: Support Connection test process (6109)
Upd: additional connection property is set far more intuitive (6109)
Upd: Merge Local and Remote settings to simplify the processing (6109)
Upd (Firebird) database coding automatic setting processing (Automatically set charset): supports remote database (Remote database) detection process (6109)
Upd: (Oracle) update DBMS_OUTPUT outgoing messages and displays the number of columns limit from 16-1024 (6109)
Upd: Oracle component version update to Oracle.ManagedDataAccess.dll 12.1.24160719 (2016/09/17) (6109)
Upd: SQLite element updated to System.Data.SQLite.dll 1.0.103.0 (3.14.2) (2016/09/15) (6109)
Upd: Firebird element updated to FirebirdSql.Data.FirebirdClient.dll 5.1.1.0 (2016/09/13) (6109)
Upd: SQLCe v4 elements updated to the SQL Server Compact 4.0 SP1 Hotfix (4.0.8902.1) (2014/06/10) (6109)
Upd: Cumulative contain other minor updates, fixes and optimization (6109)
- Automatically and perception ( the AutoComplete and IntelliSense * ):
Upd: Optimization table analysis processing to enhance the field perception (6109)
- Database Migration ( Database Migration ) (Pro):
Upd: Updated with all dbMigration .NET Software (6109)

_http://fishcodelib.co...tabaseNet4.zip

fishcodelib.com/Compare.htm