5 Replies Latest reply on Jul 2, 2014 9:52 PM by Gary Graham-Oracle

    Migrate SQLServer2008 to Oracle11g


      I would like to migrate the SQLServer2008 Northwind to Oracle11g ( on Windows7 Prof), hopefully a precursor to more migrations.


      This is the first time and I followed the Oracle instructions here:

      Migrating a Microsoft SQL Server Database to Oracle Database 11g

      The migration seemed to be successful even though it was a a 2005.ocp.

      But towards the very end, step5 of the "Executing the Script to Create the Oracle Database Object", I cannot create a new connection for user dbo_Northwind as per instruction

      SQL Developer throws this error msg:

      Status: Failure -Test failed: ORA-01017:invalid username/password; logon denied.

      I think I have to create the new user first, then the connection?


      I would like to keep this thread alive for several more follow on questions because I really like to get up close and familiar with the database migration tool.