Database administration Tools--squirrel Getting started with SQL client

Brief Introduction:

SQuirrel SQL Client is a database client written in Java, with the JDBC Unified Database access interface, you can use a unified user interface to operate MySQL PostgreSQL MSSQL Oracle and so on any database that supports JDBC access. Very convenient to use. Also, the SQuirrel SQL client is a typical swing program and a relatively successful application for swing.

If your job requires you to connect many different databases during the day (Oracle, DB2, MySQL, PostgreSQL, SQL Server, and so on), or you often need to import and export several different kinds of databases. Then the squirrel SQL client will be the ideal Database client link tool.

Download and win under installation:

: http://squirrel-sql.sourceforge.net/

Current Latest Version: Squirrel-sql-3.1-install.jar

Installation method: In the Command Window switch to the installation file directory run Java-jar Squirrel-sql-<version>-install.jar (of course, you can also directly click on the jar installation)

The procedure is very simple, you can choose to download different database drivers during the installation process, or you can copy the driver jar package to the installation directory \squirrel SQL client\lib\ directly after installation.

Run and configure links

After the installation is complete, run the program---SQuirrel SQL Client, then the cute little squirrel interface appears, enter the main interface, configure the link:

Select the left aliases, click on the + sign to create a new link alias,

Name: Simply type in the database alias you want. 、

Driver: Select the appropriate driver, the Red fork means that the driver does not exist, the checkmark indicates that the driver is available. If the driver does not exist, you can add it yourself, specifically add the steps to see the next section.

Look at the following figure, for example, MySQL driver, select Add external mysql driver package

After doing this, the Red Fork turns into a checkmark to indicate the added success

Once configured in driver, click Alias to create a new database connection

Then, after selecting the driver that was added successfully, the following is the configuration database connection parameter and user information.

Once configured, you can click Test. Ok. After the configuration is successful click OK, connect to the main page such as

See those two tabs are not objects and SQL, switch to SQL, write the query statement above, click on the villain button to indicate execution

Personal Use Experience:

Advantages: For different types of database tables, you can easily use copy, fast and convenient paste to other databases, and its records are also replicated in the past. This completely solves the inconvenience of database migration caused by differences in syntax and usage between different types of databases.

Cons: Not many good conversions for some special types, such as the CLOB type in Oracle, corresponds to the text type of PostgreSQL, although both databases are in the Utf-8 character set, However, after you copy the table with this field from Oracle to PostgreSQL, the text Type field characters are garbled (squares). It may not be the SQuirreL of the SQL client itself , but the difference between PostgreSQL and Oracle in storing the length of the Chinese Section code. There is no garbled behavior in the copy process of PostgreSQL and MySQL.

Database administration Tools--squirrel Getting started with SQL client