1 Reply Latest reply on Jan 2, 2013 10:40 AM by Mkirtley-Oracle

    Migrating a Microsoft SQL Server Database to Oracle Database 11g

      hi i have been following above mentioned documentation from this link:

      i followed it as it is with northwind data. so far it works perfect.
      but when under "Capturing the Microsoft SQL Server Exported Files" when i want to create the Microsoft SQL Server database script of my own SQL server 2008 data
      i got stuck at one point.In the command prompt "#OMWB_OFFLINE_CAPTURE.bat sa mtg2000 northwind localhost" is bit confusing,
      can anyone explain it? what is mtg2000?
      i shall be very thankful to you i need solution urgently.....
      thanks again
        • 1. Re: Migrating a Microsoft SQL Server Database to Oracle Database 11g
          The parameters for the command are -

          OMWB_OFFLINE_CAPTURE.bat login_id password database_name server_name


          - login_id is a login id with db_datareader rights (for example sa)
          - password is the password for the login id
          - database_name is the name of the database you wish to capture
          - server_name is the name of the server on which the database resides

          So, in the example you have given -

          "#OMWB_OFFLINE_CAPTURE.bat sa mtg2000 northwind localhost"

          sa - is the SQL*Server user connecting to the database and running the script
          mtg2000 - is the password for sa
          northwind - is the database to which the connection is being made and which is to be migrated
          localhost - is the name of the actual machine on which SQL*Server is running

          I hope this helps.