Eclipse SQL Explorer

Link: Eclipse SQL Explorer

她的功能與 Microsoft SQL Server Management Studio (SSMS) 相仿，不過安裝 SSMS 並不容易，常常有意想不到的狀況讓你裝不進去，超奇怪的。

Eclipse SQL Explorer 有兩種安裝版本：Standalone client 及 Eclipse Plugin。如果抓 standalone client 版本，下載完解壓縮後，就可直接執行 sqlexplorer.exe.

常見問題：How to connect to Microsoft SQL Server 2008?

1. Download Microsoft SQL Server JDBC Driver 3.0.
   
2. Create a new connection: Connections > Click Create New Connection Profiles button.
   
   
3. Add Microsoft SQL Server JDBC Driver: Add/Edit Drivers > In Preferences (Filtered), click Add.
   
   
   Fill Microsoft MSSQL Server JDBC Driver in Name field > Click Extra Class Path > Add JARs... > Add sqljdbc4.jar we just downloaded before (not sqljdbc.jar) > Click List Drivers to check if com.microsoft.sqlserver.jdbc.SQLServerDriver is in Driver Class Name field. If so, it's OK.
4. Back to Preferences (Filtered), remove old Microsoft MSSQL Server JDBC Driver. Back to Create New Connection Profiles, add our created driver.
5. URL: Please refer to Microsoft description. For example, jdbc:sqlserver://SERVER_NAME;databaseName=DATABASE_NAME;
6. Now everything is OK. To connect our database, double click our created connection.

Enjoy!