A practical and comprehensive application that comes in handy for users who need to manage multiple database connections and create, edit or alter tables.
- Portable RazorSQL
- Version : 7.3.1
- License :Trial
- OS :Windows All
- Publisher :Richardson Software
Portable RazorSQL Description
Designed mostly for database administrators, Portable RazorSQL is a reliable and straightforward application worth having when you need to manage and organize multiple DBA connections within a single interface.
Supports most types of SQL and other databases
Portable RazorSQL provides you with an intuitive environment for browsing database objects such as schemas, tables, columns, primary and foreign keys, indexes and procedures, to name a few.
Since it comes with support for various databases, the application allows you to connect to Oracle, MySQL, SQL Server, PostgreSQL, SQLite, SQL Azure, Sybase, Firebird, Derby, DB2 or simply create a new connection in case the database you use is not available in the displayed list.
Because it stores connection information in ‘connection profiles’, you need to make a new profile. Once it is created, it can be used to connect to whatever database you want.
Comes with a helpful editor function
Considering the main purpose for which Portable RazorSQL was designed, it provides several options useful for executing SQL scripts. The ‘SQL’ menu enables you to choose which option suits your needs. In case you want to run only one SQL query, you can use the first option entitled ‘Execute SQL (One Statement)’. However, if you want to send multiple queries or statements to the database, you can choose the other available options.
Since the application reads the content of the SQL editor section, it easily determines which queries you want to send to the database. For instance, if highlighted text is presented in the current scripts, the program will execute it with no exceptions.
It could use an auto-completion feature
What’s more, you can even compare data from multiple tables, views or queries, whether they are from the same database or from different ones. The ‘Compare Tool’ option allows you to specify the connections, choose the tables or the views then compare them.
Still, a drawback of this option is that you need to write manually the table’s name, otherwise it won’t work. Since it does not come with auto-completion features nor displays a drop-down list with all the available tables, you need to pay attention when writing the names.
Considering that it is a portable utility, you can carry it with you wherever you go on a removable drive and use it on any computer. Hence, it does not create registry entries and you can remove it simply by deleting its containing folder.
A useful utility for adding and managing SQL statements
To wrap it up, Portable RazorSQL provides both visual tools and useful features that allow you to insert, update and delete SQL statements, manage multiple database connections and run execute various SQL scripts.