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:

Comments

Post a Comment

Popular posts from this blog

Execute queries from SQL files

To execute queries from a SQL file, use below query. MySQL: There are 2 options: If you are in MySQL command line, execute below query. source 'SQLfilePath'; If you are in command line/shell, execute below query. mysql -u userName -p password database < 'SQLfilePath' MSSQL: Use T-SQL, execute below query. sqlcmd -S databaseName -i "SQLfilePath" -o "outputFilePath"
Post a Comment
Read more

Backup and restore database in SQL Server

To backup the database, use below query. Backup database <databaseName> to disk ='<backupLocation>.bak' with init; To backup the logs, use below query. Backup log <databaseName> to disk =' <backupLocation> .trn' with init; To restore from the database backup, use below query. restore database <databaseName> from disk = <backupLocation>.bak ' with norecovery, replace, move 'testmirror' to 'DATA.mdf', move 'testmirror_log' to 'DATA_log.ldf'; To restore from the transaction log, use below query. restore log <databaseName> from disk =' <backupLocation> .trn ' with recovery, replace, move 'testmirror' to 'DATA.mdf', move 'testmirror_log' to 'DATA_log.ldf'
Post a Comment
Read more

Rename database name in MSSQL

To rename the database is MSSQL, use below queries. ALTER DATABASE srcDatabaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE; GO sp_rename ' srcDatabaseName' , ' dest DatabaseName ' ,'DATABASE'; GO ALTER DATABASE dest DatabaseName SET MULTI_USER;
Post a Comment
Read more