How to Load Database "Offline" Capture Script Output
511874Jun 17 2008 — edited Sep 7 2009I've already posted this thread under the Migration forum.... but perhaps it's useful to post it here.
----------------------------------------------
I'm using SQL Developer 1.5.1 Build MAIN-5440 and I need to migrate a MySQL database to Oracle. I've used Migration->Third Party Database Offline Capture->Create Database Capture Scripts.
I executed the scripts on the MySQL server.
From the HELP..
"To perform an offline capture of a MySQL, Microsoft SQL Server, or Sybase Adaptive Server database, you create a set of offline capture scripts, run these scripts outside SQL Developer to create the script output (a dump of the third party metadata tables), and load the script output (the .ocp file containing the converted model) using SQL Developer.
To create the script file (a Windows .bat file or a Linux or UNIX .sh file) and related files, click Migration, then MySQL, SQL Server, and Sybase Offline Capture, then Create Database Capture Scripts.
When this operation completes, you are notified that several files (.bat, .sql, .ocp) have been created, one of which is the controlling script. You must run the controlling script (outside SQL Developer) to populate the object capture properties (.ocp) file with information about the converted model.
To load the converted model from the object capture properties (.ocp) file generated by the offline capture controlling script, click Migration, then MySQL, SQL Server, and Sybase Offline Capture, then Load Database Capture Script Output."
Why cannot I select Migration->Third Party Database Offline Capture->Load Database Capture Script Output ?
Should I configure somethings else ?
The menu item "Load Database Capture Script Output" is always grey.