April 3, 2009 at 2:40 am
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.
April 3, 2009 at 2:59 am
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.
April 3, 2009 at 3:11 am
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.
April 3, 2009 at 9:14 am
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