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. For instance, if highlighted text is presented in the current scripts, the program will execute it with no exceptions. Since the application reads the content of the SQL editor section, it easily determines which queries you want to send to the database. However, if you want to send multiple queries or statements to the database, you can choose the other available options. In case you want to run only one SQL query, you can use the first option entitled ‘Execute SQL (One Statement)’. The ‘SQL’ menu enables you to choose which option suits your needs.
Comes with a helpful editor functionĬonsidering the main purpose for which Portable RazorSQL was designed, it provides several options useful for executing SQL scripts. Once it is created, it can be used to connect to whatever database you want. 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.īecause it stores connection information in ‘connection profiles’, you need to make a new profile. 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. Supports most types of SQL and other databases
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.