SQL Developer

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!

Error migrating SQL Server 2000 database to Oracle.

979422Dec 12 2012 — edited Dec 18 2012

Hi,

I am new in SQL Developer.

I read most of the help manuals available on the net.

I am able to create connections to both SQL Server and Oracle database.

I am also able to create the migration repository on the Oracle database.

SQL server connection - TestSQL
Oracle database connection - TestOracle
Migration Repository - Migration_Repository.

Here is the problem am facing:
When I start Migrate to Oracle wizard, by right clicking the TestSQL database, I followed all the required steps and enter the necessary information. -

It starts creating the project - say, TEST but after that it gave the following error:

Migration actions have failed. Check the migration report for more details. : ORA-01400: cannot insert null into ("MIGRATIONS"."MD_PROJECT_ID").

Please help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 15 2013

Added on Dec 12 2012

#migration, #sql-developer

2 comments

320 views