Re: migrating Oracle database to SQL Server 2000.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 06:22:45 +0100

DTS will not take across the RI. It can only do that between SQL Servers.

There are some articles about SQL Server for the Oracle DBA up on the MS
website.

I think you will have to manually do it or if you know the syntax on the SQL
Server you could write a converter that looked at Oracle and converted its
constrints into a sql server compatible script. 

-- 
-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know
"torontodba" <torontodba@discussions.microsoft.com> wrote in message
news:0152E590-F670-4B3C-9EB3-9777987CBB72@microsoft.com...
> I am an Oracle DBA and my client is interested in migrating Oracle
database to SQL Server 2000.
> **
> **
> What tool can I use for migrating tables referential integrity?
> **
> **
> I tried the using DTS supplied by Microsoft but I am not successful
migrating the referential integrity of the tables.
> Thanks for the help.
>

Relevant Pages

  • Re: Migrate FK and PK constraints from Oracle
    ... I don't think DTS is the right tool to do this. ... If you are migrating a ... Vyas, MVP (SQL Server) ... > I used DTS to import tables and views from Oracle, but I how do I migrate ...
    (microsoft.public.sqlserver.dts)
  • Re: Equivalent of Oracles export/import in sql server
    ... I would not say a blanket statement like "Oracle DBAs should learn SQL Server" or "SQL Server DBAs should learn DB2". ... When I got a job as an Oracle DBA, I spent time learning how Oracle works keeping in mind that theory. ...
    (comp.databases.oracle.server)
  • select for update
    ... I am a Oracle DBA new to SQL Server. ... database running here. ... In sql server I try to do the same thing but it does not lock them. ... am also selecting the records in a cursor. ...
    (microsoft.public.sqlserver.tools)
  • Re: Another oracle resource goes down the drain
    ... "An attempt to emulate the SQL Server behavior is not only a sign of ... "Oracle is not a SQL server and one should never make it behave ... That is how suboptimal applications are created." ... Eugene Pokopac (Oracle DBA - GSFA - Tucker, ...
    (comp.databases.oracle.server)
  • GK - Persmission on each database ( objects )
    ... As an Oracle DBA I'm not that familiar with scripting on SQL server 2000 so l need your help on this one. ... The netherlands. ...
    (microsoft.public.sqlserver.security)