Databases

Below steps are used to connect to various databases using Oracle SQL Developer. Install Oracle SQL Developer from the Oracle website here By default, it can be able to connect with Oracle database. So no explanation needed. Before connect to databases, need to configure the drivers for the databases into the Oracle SQL Developer. Go to Tools > Preferences > Third party JDBC drivers , configure all the drivers here. For Microsoft SQL Server, follow below steps to configure. Download jtds jar file from here In SQL Developer, Add entry in the above mentioned page Third party JDBC drivers. Give all credentials in the SQLServer tab and click the Retrieve database which is like in this image  For MySQL, follow below steps to configure. Download MySQL connector from  here   In SQL Developer, Add entry in the above mentioned page Third party JDBC drivers. Give all credentials in the MySQL tab and click the Retrieve database which is like in this image...

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'

To view the unique constraints in MySQL database, use below queries select * from information_schema.TABLE_CONSTRAINTS where CONSTRAINT_SCHEMA = '<dbName>' and constraint_type = 'UNIQUE';

To find the created date time of the SQL server, execute the below query. SELECT create_date FROM sys.databases WHERE name = '<dbName>';