Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Asking for assistance with offline migration from Sybase 15.3 to oracle 11i using Sql Developer 4.0

knightmMar 13 2014 — edited Mar 24 2014

Hi All,

We are trying to migrate a relatively large Sybase 15.3 dtabase to Oracle 11i using Sqldeveloper 4.0.0

We are trying to use offline migration and have created the appropriate metadata files that are created from the CAPTURE .bat file. We are trying to find information on what to do next. We believe next steap are to convert the .dat files created into oracle. However trying to use the sdcli tools keep throwing errors. even on the help. Does there exist more fin grained instructions for offline migration, or can someone help point us in the right direction.

For example:

C:\tools\sqldeveloper\sqldeveloper\bin>sdcli64.exe migration -h=convert

line 0:1: unexpected token: connection

at org.antlr.stringtemplate.language.ActionParser.primaryExpr(Unknown Source)

at org.antlr.stringtemplate.language.ActionParser.expr(Unknown Source)

at org.antlr.stringtemplate.language.ActionParser.templatesExpr(Unknown Source)

at org.antlr.stringtemplate.language.ActionParser.action(Unknown Source)

at org.antlr.stringtemplate.StringTemplate.parseAction(Unknown Source)

at org.antlr.stringtemplate.language.TemplateParser.action(Unknown Source)

at org.antlr.stringtemplate.language.TemplateParser.template(Unknown Source)

at org.antlr.stringtemplate.StringTemplate.breakTemplateIntoChunks(Unknown Source)

at org.antlr.stringtemplate.StringTemplate.setTemplate(Unknown Source)

at org.antlr.stringtemplate.language.GroupParser.template(Unknown Source)

at org.antlr.stringtemplate.language.GroupParser.group(Unknown Source)

at org.antlr.stringtemplate.StringTemplateGroup.parseGroup(Unknown Source)

at org.antlr.stringtemplate.StringTemplateGroup.<init>(Unknown Source)

at org.antlr.stringtemplate.PathGroupLoader.loadGroup(Unknown Source)

at org.antlr.stringtemplate.StringTemplateGroup.loadGroup(Unknown Source)

at oracle.dbtools.migration.command_line.MigrationCmdHelp.getMigrCmdHelp(MigrationCmdHelp.java:4

at oracle.dbtools.migration.command_line.MigrationCmdHelp.usages(MigrationCmdHelp.java:23)

Also get :

line 0:1: unexpected token: output

This happens with any command inlcuding the help you see above.

Thanks for the help

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 21 2014

Added on Mar 13 2014

#database-and-application-migrations

4 comments

2,503 views