Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004

    Unanswered: Steps to convert SQL server database to Oracle

    We run Oracle Migration Workbench converted SQL Server database to Oracle, now we want to create SQL scripts based on what we got from OMW so our end users can just run scripts in SQL*Plus WorkSheet to create database, tables, stored procedures etc. The below is the steps we will fellow, can anyone tell us if we are in the right direction, if not, what the correct steps we shall fellow:

    1. Create TABLESPACE
    2. Create USER
    3. Create tables
    4. Load tables
    5. Create packages

    Thanks in advance for help.

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >what the correct steps we shall follow?
    Follow the procedure which generates acceptable results on your test system.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts