Solved

Importing Oracle 8i schema into sql server 2000

Posted on 2009-04-02
10
522 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

813 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

15 Experts available now in Live!

Get 1:1 Help Now