• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 532
  • Last Modified:

Importing Oracle 8i schema into sql server 2000

hi experts!

I have ORACLE 8Ii database and  Newly installed MSSQL SERVER 2000 my task is export oracle schema and import into mssql server 2000 with all constrain ?  I don't have any idea abt mssql server?

1) i what to create new database in mssql server 2000?
AND
2) i what to import oracle schema in to mssql server 2000?

Pls give me steps to create Database into mssql server 2000 and give me steps
to import oracle schema in to mssql server 2000?

THANKS

siva.
0
Maddy
Asked:
Maddy
  • 3
2 Solutions
 
udaya kumar laligondlaTechnical LeadCommented:
you can use SSMA for oracle from Microsoft to migrate the database.
to download and other info http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx
this link for basic tutorial on DB creation in SQL
http://dba.fyicenter.com/faq/sql_server/Creating_and_Managing_Databases_and_Physical_Files.html
0
 
MaddyUNIXAuthor Commented:
Hi udayakumar.

Can u give me steps ,

1) In what format i what to export ( the schema) in oracle? or any other way is there?
2) after exporting ? how can i import the schema into mssql server 2000?

pls if u have any doc pls share with me..


thanks

siva.
0
 
udaya kumar laligondlaTechnical LeadCommented:
check this tool
http://www.swissql.com/products/oracle-to-sqlserver/oracle-to-sql-server.html
or
http://www.dbbest.com/oramigrator.php
you can use the migartion tool that i specified in the earlier comment.

I never tried manual migration if you are looking for it.
0
 
udaya kumar laligondlaTechnical LeadCommented:
can I know what is wrong with the solution that has been provided. the solution is a standard procedure.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now