Working with Oracle SQL Developer 4.1.1 in Windows 10 - Part 1

In the previous post the details of downloading the free Oracle SQL Developer 4.1.1 and the Java SDK8 were described for a Windows 10 on a x32bit machine. As to requirements please refer to
this link. Although Windows 10 is not in the list of OSs, it seems to work without a problem, at least so far.

You do not need to install the Oracle SQL Developer tool as the executable (sqldeveloper.exe) is in the download.  Java8 SDK was downloaded and installed with the x64 bit SQL Developer on Window 10 on x32 bit laptop. However Oracle SQL Developer Tool 4.1.1  already had JDK8 and there was no need to install JDK8 separately.

Launch the SQL Developer by double clicking the executable. It starts off with the following:

 
SQL Developer411.png

There may be a message to restore previous connections and this was ignored.
The Oracle SQL Developer start page is displayed as shown.

SQLDevGui.png

At the top is the main menu and the toolbar is below the main menu. In the pane on the right you have a number of useful links including videos, featured tutorials and featured online demonstrations. You should make it a point to visit these links.

In the pane on the left at the top is the Connections pane where you establish connections. There are three links as shown.

Connections.png

Right click Connections to open the following:

Connections2.png

From here click New Connection... to open the following:

SelectDBConnection.png

It likes like as it stands you can only connect to an Oracle database. You may have bring in connection information for third part databases. Click Cancel.

Right click Oracle NoSQL Connection to open the following:

ConnectNoSQL.png

Click Cancel.

Right click Cloud Connections and click New Cloud Connection... to open the following interface:

ConnectionCloud.png

This is obviously to the Oracle Cloud. You must have some kind of authentication to get to the service.

The Reports pane at the bottom of the Connections pane has all diffrent reports that you can generate.

ReportsDetails.png
Video: Some major features

Bridging the computing clouds with SSMA2008

Well, for various reasons you may be willing (wanting) to place a part of your stuff on Microsoft Azure and part on the Amazon Cloud. In fact it is a repetition of the same story of the bygone era, some data on Microsoft platform, some on Oracle etc. Sooner or later you want to move data from one to the other. Of course there are the integration tools that can handle this. But there are others who specialize in migration of data.

Microsoft went relational with its flagship SQL Server 2008 ported out to the clouds with SQL Azure. Soon Amazon followed with its relational offering based on MySQL.

Now Microsoft has released SQL Server Migration Assistant 2008 for MySQL v1.0 in CTP1. This is a toolkit that you may use to migrate your MySQL data to SQL Server 2008 and SQL Azure. This is a nice one way bridge to SQL Azure from Amazon's MySQL.

Every database vendor has his own migration tool to take away data from a rival. There is the Oracle SQL Developer, there are migration wizards in Sybase's SQL Anywhere not counting the similar tools for the Big Blue. Of course there are other third party vendors using their skills to migrate from anywhere to anywhere.

All told it has never been easier to move data along the internet highway, nor the cloud jet way.

You may download SSMA 2008 and give it a spin. Well there is another toolkit if you want to migrate to SQL Server 2005 at the same site.

Note: SSMA 2008 for MySQL v1.0 CTP1 is designed to work with MySQL 4.1, 5.0 and 5.1 and all editions of SQL Server 2008 or SQL Azure.

If you are interested in migrating data, read all of my migration related articles for free on my blog here.

All so, if you are interested in Business Intelligence, read my no brainer SQL Server Business intelligence books here and here.

Articles on earlier versions of Oracle SQL Developer

If you are interested in reading about earlier versions of Oracle SQL Developer you may want to review these articles

http://www.devshed.com/c/a/Oracle/How-to-Use-the-Oracle-SQL-Developer-Tool/3/

MS Access Queries with Oracle SQL Developer 1.2 Tool

Migrating MS Access 2003 Data using the Oracle SQL Developer 1.2