Database .NET Review

• Platforms: Windows Vista-Win11 and Windows Server (Available in 32 or 64bit; FoxPro access requires 32bit version)
• Portable & lightweight (35mb)
• Free tier (can "try" all features up to 100 times; better than a short time period or limiting features)
• Supports many different databases (including CSV files)
• UI is very well designed
• Easy to export/import data
• "Lifetime free upgrades" price ranging from free to $99 US.

Features

• Browsing and Editing Data

  • Database/object favorite filter
  • Display of table physical size & record count
  • Quick column header filter, sort, filter. Tooltips to identify table/column.
  • One-click export table or query results to CSV/TSV, SQL INSERT, XLS/X, JSON, HTML & Markdown
  • When viewing query result, ability to supress display of columns
  • Queries results outputs execution & total time of each query
  • Synchronized scrolling (when viewing SQL results) image
  • Quick calculation of selected cells (when viewing SQL results) image
  • Select multiple cells to filter results image
  • Browse column data image
  • Expand/condense JSON/XML when editing. Edit compressed strings. image
  • PrimaryKey Selector (inline lookup) image
  • column hints are displayed throughout as tool tips. image
  • Results find in grid and replace in grid
  • Form Viewer & Editor image
  • Cell Editor / Viewer image
  • Updateable query results image
  • Split & floay modes for query results comparison image

• SQL Editor

  • Editing - dynamic syntax highlighting image
  • Autocomplete and IntelliSense IntelliSense table schemas automatic brace completion foreign keys snippets
  • Listing and filtering Code Snippets: image manager (default placeholders: $DATE$, $DBNAME$, etc)

• Object Explorer

  • Ability to search table data using string or regex image
  • Ability to bookmark/favorite database and tables image
  • Perform multiple selections at once image

• Object Designer

  • Table designer image DateTime default value Selector object comment hints
  • Contstraint designer image
  • Index designer image
  • Database diagrams image

• Database Tools

  • SQL History: log of all SQL queries performed image
  • Built-in database migration tool image

• Data Import and Export

  • Import is mucher easier than SQL Server Management Studio (SSMS). Import from Clipboard/CSV/TSV/PSV/SSV/TXT/XML/XLSX. image mode specific fields empty/null record separator
  • Export is mucher easier than SQL Server Management Studio (SSMS). Export to CSV/TSV/PSV/SSV/XLSX/XLS/XML/JSON/HTM/MD/SQL) image sql statements different database types specific fields all results or selected rows export to XLS/XLSX

• Generating Scripts

  • Generate SQL from existing data: INSERT, UPDATE, DELETE, DELETE+INSERT, REPLACE & MERGE
  • Query Reverse Engineering (to edit using query builder) image

• Execution Mode

  • Ablity to open databases in read-only mode image

• Additional Features

  • Drag and drop support text tabs database
  • Hotkeys similar to MSSMS
  • Displays actual version of SQL Server (Displayed near top-right corner of Window)

• NoSQL database Support? (HBase, MongoDB, MapR, HDFS, etc)

  • Requires Apache Drill + MapR Drill ODBC Driver

Supported databases: Microsoft SQL Server, SQL Azure, LocalDB, MySQL, Oracle, IBM DB2, Informix, PostgreSQL, HP Vertica, NuoDB, Teradata, Sybase ASE, Firebird, SQLite, SQLCe, Access, Excel, VistaDB, dBase, FoxPro, OleDB, ODBC, OData, Text, NoSQL (and any database that provides an ODBC driver)

NOTE: A separate, dedicated dbMigration .NET app is available to migrate & sync data (free - $99) (this is built-into Database .NET)

• https://fishcodelib.com/DBMigration.htm
• https://fishcodelib.com/DBMigration_Features.htm

Virus free

https://www.download3k.com/Antivirus-Report-Database-.NET-v3.html

Other reviews

• https://alternativeto.net/software/database-net/about/
• https://www.slant.co/options/29844/~database-net-review

Database .NET Feature Comparison

• https://fishcodelib.com/Compare.htm

How To Download/Install

• 32bit Free and Plus Edition: https://fishcodelib.com/files/DatabaseNet4.zip
• 64bit Standard and Profession Edition: https://fishcodelib.com/files/DatabaseNet5Pro.zip
• Chocolatey
  • https://chocolatey.org/packages/databasenet
  • https://chocolatey.org/packages/databasenetpro
  • https://chocolatey.org/packages/dbmigration

Licensing

• Free version: https://fishcodelib.com/EULA.htm
• Plus/Standard/Pro: https://fishcodelib.com/Purchase2.htm

How to Uninstall

• Just migrate (or delete) the folder \Database_Files.
  • Portable Mode: %app%\Database_Files
  • Vista or later: x:\Users\[UserName]\AppData\Roaming\Database

Personal Takeaway

PROS: Using this program has made me more productive. Compared to SMSS, Database .NET is portable, faster, smaller, easier to use and has more user-friendly features. The developer is very responsive to feedback & bug reports. I really like that the developer posts a change log that contains both versions & release dates.

CONS: The website looks chaotic and gives a bad first impression of an otherwise awesome software product. Google Translate is required to read most documentation, but at least all screenshots with text are in English.