Re: oracle 7.3 conversion to sql server 6.5

From: <xsun1913_at_my-deja.com>
Date: Tue, 28 Sep 1999 02:52:41 GMT
Message-ID: <7spahm$bda$1@nnrp1.deja.com>

Hi,

There are many commercial tools for data migration from Oracle to MSSQL Server 6.5. Do a search on "data migration" at www.yahoo.com. Commercial packages cost you money, but save you a lot of time. If your company has VB programmers, ask them to code a small VB program to migrate database objects (need proper data type mapping) and data from Oracle to MSSQL Server via ODBC links. The program will migrate only tables, indexes, foreign key constraints, and data. But you have to manually migrate stored procedures and triggers. MSSQL Server doesn't support the following: sequence, synonym, and cascading delete.

Xuening Sun
--
In article <7shobh$bva$1_at_nnrp1.deja.com>, anmohan_at_my-deja.com wrote:
> Can anyone help me by telling me the tools/procedures of converting
> oracle database to sql server 6.5? On microsoft web site I could find
> oracle to sql server 7 conversion document. I will be thankful for the
> answer.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 27 1999 - 21:52:41 CDT