Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2002
    Posts
    36

    Unanswered: migration from sqlserver to oracle

    plz provide me steps to migrate the sqlserver 2000 schema to oracle schema on windows NT along with constraints,triggers,procedures and data.

    thank u

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189

    AlligatorDBC for tables and views

    Hello,

    the easiest way to migrate table and views from MSSQL 2000 to Oracle is to use Alligator DBC. Just use CREATE table oratab AS SELECT *
    FROM mstab. That´s it.


    Hope that helps ?

    Manfred Peter
    (Alligator Company GmbH)
    http://www.alligatorsql.com

  3. #3
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: AlligatorDBC for tables and views

    Originally posted by alligatorsql.com
    Hello,

    the easiest way to migrate table and views from MSSQL 2000 to Oracle is to use Alligator DBC. Just use CREATE table oratab AS SELECT *
    FROM mstab. That´s it.


    Hope that helps ?

    Manfred Peter
    (Alligator Company GmbH)
    http://www.alligatorsql.com
    Does that copy the constraints, triggers and procedures too as the original question asked?

  4. #4
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189

    Only tables and datas

    Hello,

    AlligatorDBC gives you direct access from Oracle to MSSQL. You can write you own PL/SQL procedures to migrate the constraints, triggers and stored units ... but it will not convert T-SQL to PL/SQL automatically.

    You have to do it on your own.

    Hope that helps ?

    Manfred Peter
    (Alligator Company GmbH)
    http://www.alligatorsql.com

  5. #5
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Cool

    Alternative could be the Oracle Migration Workbench . Check the matrix of supported databases and their features.


    Hope that helps,

    clio_usa
    OCP - DBA

Posting Permissions

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