973436 wrote:Never heard of phpmyadmin, so I googled it. Seems it is just a web-based admin tool for mySQL. If so then your statement "workplace is looking to migrate all our data onto a database platform" is already flawed. You are on a database platform. You are simply going to migrate to a much more robust database platform. Regardless of which database platform you are on (mySQL , Oracle, SQL Server, DB2, etc) the first thing you must do is burn into your brain the difference between the database and the front-end tool you happen to be using. It appears that your current database is mySQL and the tool you just happen to be useing (one of many available) is phpmyadmin. All database products have a variety of vendor supplied and third party tools available, in addition to programming interfaces through languages such as c, c++, java, cobol, VisualBasic, etc, etc. In fact the front-end tools (phpmyadmin, SQL Developer, etc) are actually just applications written in some programming language. As far as the database itself is concerned, they are all just client apps. To the Oracle database, there is not difference between SQL Developer and some in-house written banking application running an ATM machine. to the database, they are all 'just another client application'.
EdStevens, thanks for the brief explanation. To be fair I am more an avid user of phpmyadmin and hence thought the Oracle SQL Developer was similar to that hence the misunderstanding. My workplace is looking to migrate all our data onto a database platform and I have been told that we will most likely be using Oracle SQL Developer so I thought I would get a headstart to understand the software and what I can and cant do.
Thanks btw for taking your time to help, really appreciate it.