Linux MSSQLServer client SQuirrelSQLClient

To connect to the mssql database in Ubuntu, I found SQuirreLSQLClient for a long time.

To connect to the mssql database in Ubuntu, I found SQuirreL SQL Client for a long time.

To connect to the mssql database in Ubuntu, I found SQuirreL SQL Client for a long time.

SQuirreL SQL Client Official Website: the latest version is 20100402_2427.

SQuirreL SQL Client has the following charm:

Based on Java, it has good features of platforms and can be used well in Windows;

As long as you have the corresponding database class library, you can connect to the corresponding database, such as SQL Server, MySQL, Oracle, Sybase, DB2, and so on.

Installation method, in the console run java-jar/path/squirrel-sql-Snapshot-20100402_2427-install.jar, and then select the installation path as prompted, subsequent installation steps, plug-in I selected Data import/DBCopy/DBDiff/Microsoft SQL Server/MySQL/Oracle/, and the Language Pack chose Simplified Chinese (Chinese)

Linux mssql Client SQuirrelSQL Client

After the installation is complete, copy the jtds-1.2.5.jar, ojdbc14.jar, mysql-connector-java-5.1.5-bin.jar to the lib directory under SQuirrel SQL installation directory, So SQuirrel SQL has the ability to connect to SQL Server, Oracle, MySQL.

Now, start the software and check the startup screen:

SQuirrel SQL Client startup Screen

After the above installation steps, the supported database connection (driver) is as follows. If other connection methods are required, copy the class library to the lib directory of the software installation directory and then restart the software:

SQuirrel SQL Client driver

Download the database connection Class Library:

SQL Server (jtds ):

Mysql (MySQL Connector ):

Oracle (JDBC ):