The most recent model of Oracle’s free SQL Developer contains new capabilities designed to make it simpler for customers emigrate knowledge from Microsoft and MySQL database administration programs (DBMSs) onto Oracle.
Unveiled this week, Oracle SQL Developer Launch 1.2’s new Migration Workbench device lets Oracle Database customers browse or transfer knowledge, database objects, tables and saved packages present in Microsoft SQL Server, Microsoft Entry and MySQL Database deployments, in line with Oracle.
Oracle says the chief objective of the Migration Workbench is to scale back the time, prices and dangers related to migrating knowledge from non-Oracle to Oracle DBMSs.
In line with Oracle, the brand new Migration Workbench allows customers emigrate a single desk or a number of databases without delay utilizing an included migration wizard. The device additionally options parsers that acknowledge T-SQL Syntax, in addition to single assertion translators that allow customers paste T-SQL code into an editor and alter it into PL/SQL code. T-SQL, or Transact-SQL, is a set of programming extensions from Sybase and Microsoft that add options to SQL, resembling transaction management, error dealing with or row processing capabilities.
SQL Developer, which was first launched in March 2006, lets database builders run SQL statements and SQL scripts, edit and debug PL/SQL code, view and replace knowledge, and conduct object looking and creation. Oracle unveiled the free device as a technique to get builders to standardize on Oracle know-how. Common for-a-fee merchandise within the house embrace Quest Software program Inc.’s Toad for Oracle, Allround Automations’ PL/SQL Developer, and Oracle’s personal SQL Plus.
Shelby Spradling, founding father of Spradling Consulting of Austin, Texas, mentioned he makes use of Oracle SQL Developer ceaselessly and has used Toad for Oracle extensively prior to now.
The marketing consultant mentioned that, total, he likes SQL Developer higher, primarily as a result of the product is free, and he cannot very nicely transfer round from shopper to shopper asking them to buy Toad software program.
“Having SQL Developer is superior for me, however the debugger is just a little bit [quirky] at occasions,” Spradling mentioned.
He’ll generally debug PL/SQL Code utilizing SQL Developer, and every thing will seemingly go advantageous. However when he checks the code, issues come up, and he would not discover out what the difficulty is till after he pastes the code into SQL Plus.
“You get what you pay for, however you are getting an terrible lot with SQL Developer,” he mentioned.
Spradling hasn’t seen the brand new Migration Workbench but, however he says it is one thing he can be serious about.
“I run into Entry and SQL Server fairly a bit,” he mentioned. “So sure, I believe the Migration Workbench can be useful.”
Oracle SQL Developer 1.2 is out there at no cost obtain from the