Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

importing Oracle8i schema into mssql server 2000 Expand / Collapse
Author
Message
Posted Friday, April 03, 2009 2:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Friday, April 03, 2009 2:59 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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
Posted Friday, April 03, 2009 3:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Friday, April 03, 2009 9:14 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued 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 »

Add to briefcase

Permissions Expand / Collapse