1 Reply Latest reply: Aug 31, 2012 1:43 AM by Kgronau-Oracle RSS

    How to get .ocp file when converting sql database to oracle database?

    955649
      Hi all,

      Hope doing well,

      sir i am using sql developer tool for migration from sql server to oracle
      i am using this offline but i don't know how to create .ocp file
      please help me.

      it's urgent

      waiting for reply.
      thanks in advance.
        • 1. Re: How to get .ocp file when converting sql database to oracle database?
          Kgronau-Oracle
          The OCP files are created during OFFLINE Migration. In SQl Developer click on Tools -> Migration -> Create Database Capture Scripts. Choose an output directory, make sure to select the correct platform (Windows) and select MS SQl Server from the drop down list.
          You'll get in the directory specified earlier the batch and OCP files required to create the source model using the offline method.

          Have a look at this web site: http://www.oracle.com/technetwork/products/migration/sqlserver-095136.html
          It contains more info including a link to a video demonstrating the offline capture method.