Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Importing Oracle 8i schema into sql server 2000

Posted on 2009-04-02
10
524 Views
Last Modified: 2013-11-16
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
Comment
Question by:sivakumar_experts
  • 3
10 Comments
 
LVL 12

Accepted Solution

by:
udaya kumar laligondla earned 500 total points
ID: 24057092
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
 

Author Comment

by:sivakumar_experts
ID: 24057336
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
 
LVL 12

Assisted Solution

by:udaya kumar laligondla
udaya kumar laligondla earned 500 total points
ID: 24057493
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
 
LVL 12

Expert Comment

by:udaya kumar laligondla
ID: 24138947
can I know what is wrong with the solution that has been provided. the solution is a standard procedure.
0

Featured Post

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question