?
Solved

Importing Oracle 8i schema into sql server 2000

Posted on 2009-04-02
10
Medium Priority
?
528 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:Maddy
[X]
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
  • 3
10 Comments
 
LVL 12

Accepted Solution

by:
udaya kumar laligondla earned 2000 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:Maddy
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 2000 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

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

719 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