The first step toward data interpretation is getting the right tool for the job. When it comes to database information, you can turn to SQL Notebook Portable, a lightweight, attractive and easy-to-use application that promises to read data straight from Microsoft SQL Server, PostgreSQL and MySQL databases.
Import data from SQL Server, PostgreSQL and MySQL
Aside from .NET Framework, there are no other requirements involved in the setup operation. Reaching the main app window comes down to clicking the .exe file from the downloaded package. The tool acts like an SQLlite database, giving you the possibility to add new data and queries to the notebook.
Existing databases can be imported straight from SQL Server, MySQL and PostgreSQL after configuring the necessary settings (server address, database name, username, password). Advanced users may also set up more options related to the packet size, transaction binding, connection retry count, connection string, and others.
View and edit CSV, XLS, JSON and TXT
In addition to importing data from existing databases, it's also possible to open files with the CSV, TXT, XLS, XLS or JSON format. You can control the number of initial lines to skip, pick the text encoding mode, ask the tool to append or delete new rows or drop the table and recreate it if it exists, preview the original file, and so on.
After adding new notes, consoles and scripts, you can keep all of them opened at once and easily navigate, thanks to the fact that multiple tabs are supported. Notebooks can be saved to file and later opened to pick up where you left off, as well as exported to CSV format with the help of SQL Notebook Portable.
Intuitive and practical SQL reader
We faced no errors on Windows 10 in our tests while running this program. It's easy to use, fast and has insignificant impact on system performance.
Taking everything into account, SQL Notebook Portable comes in handy for users looking for a simple and straightforward solution to read SQL databases without resorting to complicated software.