Skip to main content

Connect various databases using Oracle SQL Developer

Below steps are used to connect to various databases using Oracle SQL Developer.

  1. Install Oracle SQL Developer from the Oracle website here
  2. By default, it can be able to connect with Oracle database. So no explanation needed.
  3. Before connect to databases, need to configure the drivers for the databases into the Oracle SQL Developer.
  4. Go to Tools > Preferences > Third party JDBC drivers, configure all the drivers here.
  5. For Microsoft SQL Server, follow below steps to configure.
    1. Download jtds jar file from here
    2. In SQL Developer, Add entry in the above mentioned page Third party JDBC drivers.
    3. Give all credentials in the SQLServer tab and click the Retrieve database which is like in this image 
  6. For MySQL, follow below steps to configure.
    1. Download MySQL connector from here 
    2. In SQL Developer, Add entry in the above mentioned page Third party JDBC drivers.
    3. Give all credentials in the MySQL tab and click the Retrieve database which is like in this image 
  7. For PostgreSQL, follow below steps.
    1. Download PostgreSQL connector from here
    2. In SQL Developer, Add entry in the above mentioned page Third party JDBC drivers.
    3. For selecting the database, use host name as  like shown in this image, here test is a database name

Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

Identify the duplicates in MySQL

To identify the duplicate entries in MySQL, use below query.                      SELECT COUNT(*) as repetitions, group_concat(id, ' (', startTime, ', ', endTime, ') ' SEPARATOR ' | ') as row_data FROM GROUP BY startTime, endTime HAVING repetitions > 1 FYI, id, startTime and endTime columns should be changed based on your table schema. you can change the output format here like alias and the separator.
Post a Comment
Read more

T-SQL to set Max memory in MSSQL

 To set max memory for Microsoft SQL server, use the below Transact SQL. USE master EXEC sp_configure ''show advanced options'', 1 RECONFIGURE WITH OVERRIDE GO --To set a maximum memory limit, type the following, pressing Enter after each line: USE master EXEC sp_configure ''max server memory (MB)'', <MaxServerMemory> RECONFIGURE WITH OVERRIDE GO --MaxServerMemory is the value of the physical memory in megabytes (MB) that you want to allocate. --To hide the maximum memory setting, type the following, pressing Enter after each line: USE master EXEC sp_configure ''show advanced options'', 0 RECONFIGURE WITH OVERRIDE GO exit
Post a Comment
Read more