b/freee 10 years ago by

Database .NET 16.8.5770.1 Multilinguage Portable

This post was published 10 years ago. Download links are most likely obsolete. If that's the case, try asking the uploader to re-upload.

Database .NET 16.7.5770.1 Multilinguage Portable

Database .NET 16.8.5770.1 Multilinguage Portable | 12 Mb

It's a freeware post. Database .NET is a simple and intuitive database management tool for multiple databases, making local and remote database administration easier. With it you can Create databases, Design tables, Edit data, Export data, Generate scripts and run SQL queries. Create, Shrink, Protect Database. Export to CSV/XML/TXT/XLS/SQL. Syntax Highlighting. Table Editor.

Database Editor:
Table Designer
Constraint Designer
Index Designer
Generate Scripts: Data Definition Language (DDL), SCRIPT AS, All objects

Browse and Edit Data:
Data Editor(TABLES/VIEWS): Auto Increment, Default Value, and Set Cell as NULL...etc.
Form Editor(*) and Viewer
XML Editor and Viewer
Cell Editor(*), DateTime Picker, PrimaryKey Selector, GUID Generator
Data Visualization
AutoFilter
Filter Expression
Multi-Line Text
Find In Grid
Batch Import
Data Export(CSV/XML/TXT/XLSX/XLS/SQL/HTM/JSON)
Print SQL statements and query results

SQL Editor:
Dynamic Syntax Highlighting: Automatically switch the syntax highlighting dependant on exclusive database system.
AutoComplete and IntelliSense(*): Speeds up and simplifies your typing experience
AutoComplete + Code Snippets
Cross-schema table access
Query Builder(*), Selected Text to Query Builder
Enable SQL Formatting plug-in: Download the Database .NET Additional Files or the command-line utility 'SqlFormatter.x.x.x.zip' and Put 'SqlFormatter.exe' in the same directory as 'Database4.exe'.
Transaction Mode: Starts a database transaction.
Execute an SQL script
Multiple Tabs and Results (Splitter and Tabbed mode)
Displaying the results of batch SQL statements
Displaying informational messages, DBMS_OUTPUT
Display Estimated Execution Plan
Drag and Drop support
Timer: Automatic Execution
Additional Commands:
(Defines scripting variables) :setvar <varname> "value" , (Using scripting variables) $(varname)
(Executes multiple SQL statements) GO [count] or / [count]

Object Navigator:
Browse Schemas: Quick Filter, Filter Settings
Search Database Objects
Search Table Data
Table and View List
Database Diagram(*)
DragDrop Database: *.mdb/*.mde/.accdb/*.accde/.xls/.xlsx/.xlsm/.xlsb/.gdb/.fdb/.sdf/.db/.db3/.sqlite/*.dsn/*.udl
Auto-Detect file format: Access/Firebird/Excel/SQLite/SQLCe(Any file extension *.*)
Integrates Referenced URL
Allow Multiple Instances
Dynamic Context Menu[?]

Database Tools:
SQL History
SQL Profiler(*)
Global Mode: SQL Server 2000/2005/2008/2012/2014, IBM DB2 and Firebird

Session Mode: MySQL
Log Mode: Other databases
Process List: MySQL/PostgreSQL/Oracle/SQL Server/SQLAzure/SQLCe/Sybase
Protect Database: Access 97~2003/Access 2007~2013/SQLCe/SQLite
Shrink Database: Access 97~2003/Access 2007~2013/Firebird/MySQL/SQL Server/SQLCe/SQLite/PostgreSQL/FoxPro
Backup/Restore Database: MySQL/PostgreSQL/SQL Server/Firebird/SQLite(?)
Service Manager: (Requires Administrator privileges(if UAC is enabled))

Code Manager:
Search with RegEx, (Focused+Shortcut key: Enter, Focused+Shortcut key: F5)
Code Snippets Manager
Script all database objects (DDL) and all table data (INSERTs)
Security Manager:
SQL Server: Logins/Server Roles/Application Roles/Database Roles/Users/Schemas
SQL Azure: Database Roles/Users/Schemas
Firebird: Database Roles/Users
MySQL: Users
PostgreSQL: Database Roles(Users)/Schemas
Oracle: Database Roles/Users(Schemas)
SybaseASE: Logins
IBM DB2: Database Roles/Users/Schemas
IBM Informix: Database Roles/Users(Schemas)
Connection Management: Connection Manager
Connection Profile: SQL Server/SQL Azure/Oracle/IBM DB2/Informix/MySQL/PostgreSQL/Sybase ASE
Browse for servers: SQL Server/Oracle/IBM DB2
Browse all databases: MySQL/SQL Server
Additional Connection Parameters

Support for Visual Studio IDE:
Supported File Formats: *.mdb/*.mde/.accdb/*.accde/.xls/.xlsx/.xlsm/.xlsb/.gdb/.fdb/.sdf/.db/.db3/.sqlite/*.dsn/*.udl/*.dbc
The easiest way to use the tool is to add it as an External Tool to Visual Studio IDE.
Then when you select the supported file formats in the Project Explorer.

- Main Program Update ( Main ):
Add: Support Synonym object management (Synonym Objects): contains SQLServer / SQLAzure / Oracle / DB2 / Informix (5770)
Fix: Problems (NuoDB) amended IDENTITY column can not be achieved (including editing and script generation processing) (5770)
Fix: (Oracle) modify field CHAR / VARCHAR2 / NCHAR / NVARCHAR2 way to obtain information such as the type length (5770)
Upd: Update Thai interface language Thai language (by Thammapat.c) (5765)
Upd: Improved ODBC Data Sheet and the correction field displays (including script generation) (5765)
Upd: Accumulated other contains minor updates, correction and optimization (5770)
- Data Table Editor ( Table Designer ):
Add: (Teradata) supports auto-increment field set processing (Auto Increment) (5770)
- Data definition language ( Data Definition Language (DDL) ):
Upd: (DB2 / NuoDB) distinguish GENERATED (ALWAYS / BY DEFAULT) generation processing (5770)
- AutoComplete and perception ( AutoComplete and IntelliSense * ):
Upd: Shift Key issues trigger exclude non-input, to reduce unnecessary display processing (5770)
- Connection set ( Connection Profile )
Fix: Fixed PostgreSQL Advanced Connection property is set to issue stalled (5765)
- Database migration ( Database Migration ) (Pro):
Add: command line processing ( Command-Line ):
Add: Support (Firebird / SQLite / Access / SQLCe / Excel) purpose database automatically establish processing (5770)
Add: When the source and destination repositories If no pre-established after the specified file type repository can be set to automatically establish a connection no longer pre-established (5770)
Add: increase the log file date convenient to distinguish each different execution record (5770)
Upd: When the specified parameters is invalid will appear in the output window or log file in the (5770)
Add: Added default confirmation options ( Default Confirmation Options (if the target table exists) ): -defopt: [rename / recreate / delete / append / Sync] (5765)
Add: Added recording mode without window options (Log mode and No window (Database5Pro.log)): -log (5765)
Add: Support handle success or failure return code (Exit Code: Success = 0, Failure = 1) (5765)
Add: Support multiple selection fields ( Selecting Multiple columns to Edit ) batch update data type handling (5770)
Upd: (Oracle) Update of Fields LONG / NUMBER information such as the type of automatic matching process (5770)
Fix: When (Oracle) Correction Connection is set to OCI, unable to deal with the issue of migration (5770)
Fix: Fixed (5765) results when the [Source] language as SQLCe when the migration problem can not be processed (5770)
Upd: join the structural integrity descriptive name (SCHEMA NAME) treatment (5770)
Upd: solve the conversion process and the end of the window can not be maintained in the upper display problems (dbP) (5770)
Fix: exceptions can cause problems when correcting for changes in part to the type of information (5765)
Upd: upgrade automatically identify the type of data matching process (5765)
Add: increase command line help window ( Command-Line ) (DbP) (5765)