Importing data from Oracle to SQL Server 2000 -- sql server dts

Sue Hoegemeier
4/13/2004 10:14:24 AM

There is a chapter in the SQL Server 2000 resource kit on
migrating Oracle databases to SQL Server. It has a lot of
useful information to help with migrations. You can find it
online at:
Chapter 7 - Migrating Oracle Databases to SQL Server 2000
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0761.mspx

In terms of the error, something is not configured correctly
with the Oracle Net Configuration utility. The client can't
find the Oracle instance. You can run the utility to check
your configuration and make adjustments or take a look at
the tnsnames.ora file. Once you have reconfigured, you can
test the connectivity using the tnsping utility.

-Sue

On Tue, 13 Apr 2004 11:50:12 -0400, "AS"
[quoted text, click to view]

AS
4/13/2004 11:50:12 AM

Hi,
We have an Oracle database and the applications on top of it that're written
in Developer 2000. We want to migrate to sql server 2000. Any pointers on
how I should go about doing that.
Also, I installed Sql server 2000 on another PC and tried using the
Import/export wizard to be able to import all the data from Oracle..
Earlier I got the message :
"No Oracle instance running".
So I installed the Oracle client on the PC running Sql server 2000. Now I
when I repeat this process, I get a different error:

"TNS: No listener SQLSetConnectAttr failed ORA-12224 : Error during
initialization of the provider."

Now I've also checked Oracle server and under Control panel ->services, I do
have the listener service running..???
What else should I be looking at.. ??

Please advise..

Thanks,
Regards,
AS.

sanchans NO[at]SPAM online.microsoft.com
4/29/2004 7:49:01 PM

An excellent resource would be to understand the differences between the
two at:

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlorpro.mspx

This article is written for Oracle Professionals who would like to
jumpstart to SQL and you will find really good information here.

Also, the resources kit provides an excellent article:

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/p
art2/c0761.mspx

I would also like to point you to some third party independent articles
that are an excellent resource for doing the same:

http://www.sql-server-performance.com/np_migrating_from_oracle_to_sql_server
.asp
http://www.akadia.com/services/sqlsrv2ora.html

As always, these articles are third party and we cannot guarantee anything,
but they are written by folks who have actually done this.

sanchans@online.microsoft.com

This posting is provided "AS IS" with no warranties, and confers no rights.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : Importing data from Oracle to SQL Server 2000