Solved

Importing Oracle 8i schema into sql server 2000

Posted on 2009-04-02
10
521 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:
udayakumarlm 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:udayakumarlm
udayakumarlm 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:udayakumarlm
ID: 24138947
can I know what is wrong with the solution that has been provided. the solution is a standard procedure.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to take different types of Oracle backups using RMAN.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

910 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

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now