importing Oracle8i schema into mssql server 2000

  • Hi experts ,

    I m oracle DBA! in oracle we have 'ora' schema that 'ora' schema i what to export it and i what to import into newly installed MS SQL SERVER 2000 (for test per), experts i don't have any idea abt sql server 2000. this is one of our client requirement.

    Experts give me what format i what to export the schema and how to import into the MS SQL SERVER 2000. or any other way is there for same?

    Thanks Adv

    siva.

  • 1. Create a new database (as schema in oracle is like database in sql, database in oracle is like server instance in sql )

    2. You can use DTS Import Export Wizard (Start > All Programs > Microsoft Sql server > Import Export Data) to import all objects

    As your are new to sql server, please read some articles related to using dts import export wizard.

  • Thanks lots sir,

    Sir if i use DTS Import/export utility what happen with constrains (like pk,fk) and can i import Proc also.

    siva.

  • it will copy all objects (including constraints, PS, function etc, whatever valid for SQL server), at least its true for SQL server to SQL server. I dont know how it will behave with oracle.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply