importing Oracle8i schema into mssql server 2000

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » importing Oracle8i schema into mssql server...

importing Oracle8i schema into mssql server 2000

Rate Topic

Display Mode

Topic Options

Author

Message

sivavella.kumar

Posted Friday, April 03, 2009 2:40 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 04, 2009 6:09 AM
Points: 2, Visits: 10

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.

Post #689652

Boolean_z

Posted Friday, April 03, 2009 2:59 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, February 15, 2012 8:42 PM
Points: 63, Visits: 121

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.

Post #689661

sivavella.kumar

Posted Friday, April 03, 2009 3:11 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 04, 2009 6:09 AM
Points: 2, Visits: 10

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.

Post #689667

Boolean_z

Posted Friday, April 03, 2009 9:14 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, February 15, 2012 8:42 PM
Points: 63, Visits: 121

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.

Post #690007

« Prev Topic | Next Topic »

Permissions