/SQL/Sql developer connect to sql server

Sql developer connect to sql server

1. Download the jTDS 3rd party JDBC driver, version 1.2.8 from here https://sourceforge.net/projects/jtds/files/jtds/1.2.8/jtds-1.2.8-dist.zip/download 
2. Save and extract the contents of the jtds-1.2.8-dist.zip file somewhere safe (ex: “C:\oracle\sqldeveloper\add-ons\jtds-1.2.8-dist\”).
3. Start SQL Developer go to Tools > Preferences > Database > Third Party JDBC Drivers.
4. Click “Add Entry”, point to the ‘jtds-1.2.8.jar’ file location, then select it and click OK.
5. Create a new connection, and choose the “SQLServer” tab.
6. Enter the following details: Connection Name (required for database retrieval), Username, Password, Hostname, and Port.
7. Click “Retrieve database” and select the appropriate database, then Save/Test/Connect as you would do normally.

Source: snapdba.com

Similar codes

0 vote301 views1 answer
Heavy table in mysql
SQL
0 vote302 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote314 views1 answer
Convert .mdf to .bak
SQL
1 vote332 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote340 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote325 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
0 vote325 views1 answer
Postgresql delete limit
SQL
3 votes335 views1 answer
Postgresql today - 1 year
SQL
1 vote328 views1 answer
Convert epoch to date in sql server
SQL
0 vote311 views1 answer
Alter table name including schema
SQL