Database administration Tools--squirrel Getting started with SQL client

Source: Internet
Author: User
Tags sql client postgresql

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.