Re: Oracle to SQL server

From: Xuening Sun <ba503_at_torfree.net>
Date: Fri, 27 Aug 1999 13:11:09 GMT
Message-ID: <FH4KMM.C94.0.bloor@torfree.net>

Hi,

You could port your Oracle database to SQL server. You might want to use DTS (data transformation Service) in SQL Server 7.0 to migrate objects and data from Oracle to SQL Server (watch out for the data type mappings). Using ODBC link for Oracle and OLE DB for SQL Server. You have to port your triggers and stored procedures manually. SQL Server does not support cascading delete on foreign keys. You have to write your own cascading-delete triggers. SQL Server doesn't have synonyms so you have to use something else, say views. Microsoft put some doc. about migrating from Oracle to SQL Server at http://www.microsoft.com/sql.

Xuening Sun
--
ksganesh_at_my-deja.com wrote:
: Can I port a Oracle database to SQL server. If it is possible, what is
: the procedure?

:
: Thanks

-- Received on Fri Aug 27 1999 - 08:11:09 CDT