To sum things up, RazorSQL comes bundled with visual tools and useful features that help you to manage multiple databases, execute SQL statements and export data to XML, HTML and Excel spreadsheets. However, a downside of this option is that you are required to manually write each table’s name and since it does not come with auto-completion features, nor displays a drop-down list from where you can choose the available tables, you need to pay attention when writing their names.īy accessing the Results menu you are able to filter and sort all the query results the way you want, edit the selected cells, as well as generate INSERT, SELECT, UPDATE and DELETE statements with ease. By accessing the ‘Compare Tool’ option from the File menu you are able to set up the connection parameters, select all the data you are interested in, then compare it. In case you want to run one SQL query at a time, you can choose the ‘Execute SQL (One Statement)’ option, otherwise you can access the other features such as ‘Execute SQL - Fetch All Rows’ or ‘Execute SQL (All Statements)’.Īnother important feature of RazorSQL is that you can compare data from multiple tables, views or queries, whether they belong to the same database or they are from different ones. The main window enables you to execute as many SQL scripts as you want, while the Console section retrieves all the necessary data.īesides, if you want to import data from delimited files, Excel spreadsheets, fixed width files into the current database, you can use the proper option from the main toolbar. Once the connection is established, the left panel displays all of the identified data, thus allowing you to edit it the way you want. Once it is created, it can be used to connect to whatever database you want. Irrespective of the database you choose to work with, be it Oracle, MS SQL Server, MySQL, PostgreSQL, Firebird, Interbase, Apache Derby, Salesforce, SQL Azure, SQLite, MongoDB, Frontbase or JavaDB, the application helps you to edit SQL scripts, gather information from multiple tables, create indexes and views.īecause it stores connection information in ‘connection profiles’, you need to make a new profile. Pricing of RazorSQL starts at $99.95 USD for a single user, and tiered discounts are offered for multiple license purchases.Working with different databases and executing SQL scripts ranging from simple SELECT statements to complex procedures, RazorSQL proves to be an intuitive and steady solution especially designed for database administrators who need to create, alter, describe, execute and drop database objects such as tables, views, indexes, stored procedures and functions. This comprehensive database manager is specifically for people who. It also features a programming editor, and boasts compatible with most commonly use languages. It supports tabs, and allows you to open multiple database connections simultaneously. RazorSQL 6.0 is available for immediate download at. RazorSQL is a powerful SQL query tool, database browser, SQL editor, and database admin tool. Versions of RazorSQL are available for Windows, Mac OS X, Linux, and Solaris. Also included are conversion tools to easily copy tables and query results from remote databases to RazorSQL's local database engine for local development. New features in version 6.0 include database conversion support for MySQL, PostgreSQL, Oracle, MS Access, MS SQL Server, SQLite, and HSQLDB. Some of the main features contained in RazorSQL are visual tools for creating, editing, describing, altering, dropping, and viewing database objects such as tables, views, indexes, procedures, functions, and triggers tools for importing and exporting data in various formats such as MS Excel, delimited files, SQL insert statements, HTML, XML, and text a database browser for the viewing of database objects and structures search tools for searching for database objects and database data, tools for building SQL queries and generating SQL and DDL, a SQL formatting tool, SQL history tracking and and SQL favorites tool for storing frequently used SQL statements, and a robust programming editor and query tool with support for SQL, PL/SQL, TransactSQL, SQL PL, PHP, Java, XML, HTML, and many other programming languages that features tools for searching and replacing data, programmable macros, coding sidekicks for various programming languages, a file system browser, function and method browsers, and much more. Users can also use the built in relational database engine for their database needs. Connect to other databases via JDBC or ODBC (Windows only). RazorSQL supports over 30 databases, examples of which include the following: Amazon SimpleDB, Apache Derby, DB2, Firebird, FrontBase, H2, HSQLDB, Informix, Intersystems Cache, JavaDB, MS Access, MySQL, OpenBase, Oracle, Pervasive, PostgreSQL, SQLite, SQL Azure, SQL Server, Sybase, Sybase SQL Anywhere and Teradata. Using RazorSQL, users can query, edit, browse, and manage all major databases from one tool. RazorSQL 6.0, an SQL editor, database query tool, database browser, and database administration tool, is now available.
0 Comments
Leave a Reply. |