Teradata, SQL Server, SQLite, MySQL, Oracle, Excel, Access and dBase are databases you may use on a regular basis. If you do you probably have 3-6 Database tools to help manage them all. Each of these has their own user interface and capabilities. Database .NET from Fish Code Library is the one tool to help you manage all these databases and many more. Database .NET (DBN) is a single EXE file and can be installed as a portable product on a thumb drive or a shared product on Dropbox.
Database .NET is not the best name Fish Code Library could have picked as it makes it difficult to locate it on the web without having to look at a 100 posts about Microsoft’s .NET foundation.
DBN has so many features that DBA’s and DB Developers would like.
- Can be run on Corporate computers that don’t have install rights, you folks know who I mean
- Can be run from a USB Thumb drive
- Can be run from Dropbox and one instance shared across multiple computers
|Free & Premium
- Free version does 80% of what many users need
- Premium version is $30…. Really!!
That’s less than the cost of a monthly cup of coffee (Cheap coffee at that)
- Very small footprint
- No Windows installation required
- No extra DLL’s that might cause conflicts on your system
- Updates are simple, just replace the EXE file
- Overhead is very low, open multiple copies of DBN to work between different servers and database types
- Fast processing
|.NET Data Providers
- DBN has all the latest .NET drivers embedded in the tool
- No ODBC Data Source Names to maintain outside the tool
- Configuration for DB connections maintained by DBN
- Teradata supported with Full capabilities of .NET 15.x.x
- 21 databases servers supported
- Legacy support for dBase and Paradox, anyone remember those?
- Comma Separated Values (CSV) very common format
- Tab Separated Values (TSV) gotta love Unix support
- XML data exchange with bloated tags
- Excel (XLS) Because if it isn’t a database it’s a spreadsheet
- Insert SQL portable between different database formats
- HTML ok the web isn’t a fad and is probably going to be here a while
- Java Script Object Notation (JSON) NoSQL document format
|DOS Command mode
- DBN be called in a Windows Batch file
- Inexpensive and casual ETL tool and data transfer tool
(GeekMustHave will have an example of Teradata to SQLite Windows Batch file soon.)
- Database to Excel refresh tool with Windows shortcuts
- Basic SQL to JSON convertor for relational databases
- Version tracking on selected SQL scripts
- Simple code library for each database/project in Windows directories and files
- SQL code can be quickly saved in Windows files in a structured directory
- Copy all your SQL scripts for all you projects by copy and pasting a single directory
- Install DBN on Dropbox or other Cloud services and have you DB tool and script everywhere you go.
- Most Excellent
- Fish Code Library also has a number of other productivity tools
- Forum available to post improvements and vote on them
- Many of the improvement requests show up in the frequent updates
- Have I mentioned Teradata support
To be a fair reviewer of database tools you do have to mention some areas where the tool could be improved
- Allows for the number of rows returned in the result to be automatically limited without changing the SQL. Good for large database queries and data warehouses usage.
- DBM is a Windows tool, get over it or get a copy of VM Fusion and run it there
- That being said, a native MAC version would be nice