RE: [Q] How to migrate from ORACLE to MS SQL Server?

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Wed, 17 Jan 2001 08:32:21 -0400
Message-Id: <10744.126876@fatcity.com>

I haven't done this, but I think you can use MS-DTS wizard = (import/export).

Test first of course.

It goes through ODBC, it's slow.

: )

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique=20
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20

	-----Original Message-----
	From:	Bunyamin K.Karadeniz [SMTP:bunyamink_at_havelsan.com.tr]
	Sent:	Tuesday, January 16, 2001 4:15 AM
	To:	Multiple recipients of list ORACLE-L
	Subject:	Re: [Q] How to migrate from ORACLE to MS SQL Server?

	Has anyone replied this question?=20

	I wonder the solution too.=20

	----- Original Message -----=20
	To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
	Sent: Friday, January 05, 2001 12:20 AM




	> We plan to migrate from ORACLE 8.1.6 on SUN to MS SQL Server 2000

on Win


	> 2000.  Can anyone has experience can tell me how to do it?

	>=20


	> My questions are:

	>=20


	> 1. our ORACLE DB have:

	>=20


	>    Tables

	>    indexs

	>    Foreign key

	>    constraint (Primary key, not null, unique)

	>    sequences

	>    views

	>    synonyms

	>=20


	> Our ORACLE DB does NOT have:

	>    trigger

	>    procedure

	>    function

	>    package

	>    db link

	>=20


	> 2. Does MS Sql Server has tool can migrate ORACLE DB?

	>=20


	> 3. Does tool also handle index, foreign key, constraint, sequence,

views


	> and synonyms?

	>=20


	> 4. how to migrate user id to SQL Server?

	>=20


	> 5. Anythings I need manual implement?

	>=20
	>=20


	> Thanks to help.

	>=20


	> --=20

	> Please see the official ORACLE-L FAQ: http://www.orafaq.com

	> --=20

	> Author: L

	>   INET: leed_at_chele.cais.net

	>=20


	> Fat City Network Services    -- (858) 538-5051  FAX: (858)

538-5051


	> San Diego, California        -- Public Internet access / Mailing

Lists
	>
--------------------------------------------------------------------


	> To REMOVE yourself from this mailing list, send an E-Mail message

	> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and

in


	> the message BODY, include a line containing: UNSUB ORACLE-L

	> (or the name of mailing list you want to be removed from).  You

may


	> also send the HELP command for other information (like

subscribing).

	--=20
	Please see the official ORACLE-L FAQ: http://www.orafaq.com
	--=20
	Author: Bunyamin K.Karadeniz
	  INET: bunyamink_at_havelsan.com.tr

	Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
	San Diego, California        -- Public Internet access / Mailing
Lists
	--------------------------------------------------------------------
	To REMOVE yourself from this mailing list, send an E-Mail message
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
	the message BODY, include a line containing: UNSUB ORACLE-L
	(or the name of mailing list you want to be removed from).  You may

Received on Wed Jan 17 2001 - 06:32:21 CST