Listed below are some of the settings required by the import tool. For delimited files, RazorSQL needs to collect more information before the import can run. For SQL insert statement files, there is little more information to enter.
Once the type and table are selected, the next screen differs based on the type of import. If launching the import tool from the database browser, the database table and schema information will be pre-selected. The first step in the import tool is selecting the type of import (xls, delimited file, etc.) and the database table to import the data into. The Database Import Tool allows users to import data from delmited files, Excel spreadsheets, fixed width files, or files of SQL insert statements into database tables.
The SQL Editor will also display custom sytnax highlighting for MySQL and PostgreSQL keywords. However, if connected to Oracle, SQL Server, Sybase, or DB2, the editor will set the highlighting type to that particular database's programming language, i.e., PL/SQL for Oracle, TSQL for SQL Server and Sybase, and SQL PL for DB2. Normally the default syntax highlighting type is the SQL type. xml, RazorSQL will display XML syntax highlighting unless the user changes the highlighting type manually. The editor tries to determine the syntax highlighting type based on the type of file and / or the type of database connection. The query results section includes many features such as one-click editing of data, data searching, filter and sort tools, and data import and export tools. The SQL editor displays query results in a tabular format. Users can also manually highlight queries they wish to execute. The SQL editor also allows users to execute multiple queries at a time using the execute all option, or to execute only queries based on the current cursor position assuming queries are separated by semi-colons. After typing a keyword such as from, the SQL editor will display a list of available tables to choose from. For example, when typing an SQL select query in the SQL editor, after typing a keyword such as where, the editor will perform on auto column lookup to display the list of available columns pertaining to the current query. The SQL editor also supports auto completion and auto lookup. RazorSQL contains a SQL editor that includes syntax highlighting and function lookup for many languages such as SQL, PL/SQL for Oracle, Transact-SQL for SQL Server and Sybase, SQL PL for DB2, and support for other popular programming languages like PHP, Java, JavaScript, HTML, CSS, XML, and many more. Listed below is a screen shot of the RazorSQL database browser:
COMPARE DB SCHEMA MYSQL RAZORSQL MAC OS
RazorSQL is available for several operating systems including Mac OS X, Windows, and Linux. For example, the browser provides the ability to generate select *, select, update, insert, and delete SQL statements. The database browser also includes menu options for easily creating SQL statements for tables. The database browser also has options for searching database tables, generating DDL for tables, views, and indexes, and much more.
COMPARE DB SCHEMA MYSQL RAZORSQL CODE
For stored procedures, the database browser gives users the option to view the code behind the stored procedure, or edit the stored procedure. For example, for tables, the database browser includes options for altering the table, such as renaming the table, renaming columns, adding and dropping keys, adding constraints, etc. In addition to the information displayed for each database structure, the database browser also includes a context menu for performing operations on the structure. For indexes, the browser displays the index name, uniqueness, the table referenced by the index, etc. For example, for database tables, the browser displays such information as column names, column data types, column lengths, column nullability, and primary and foreign key information.
The database browser displays varying levels of information depending on the object. For some databases, RazorSQL also provides security information such as users and roles. For most databases indexes, functions, constraints, and triggers are also included. The structures shown depend on the database, but for almost all databases, the minimum level of detail includes tables, views, and procedures. The database browser provided by RazorSQL gives users the ability to browse database structures. RazorSQL has been tested on over 40 databases, can connect to databases via either JDBC or ODBC. RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, macOS, Mac OS X, Linux, and Solaris. Query, Edit, Browse, and Manage Databases