Replication Problem Oracle to SQL Server -- sql server replication

Mike Hunt
8/4/2006 7:22:35 AM

Hi I am having a big problem I am contracing on a public sector project
that is importing Oracle data to SQL server however we do not have a
direct connection to the source data but we do have an old copy of the
database on a local oracle server we have a target schema defined
however we are not having an accourate data mapping document.

My question to perhaps how do I solve this problem given that we must
map, import ,translate (clean) and repicate the data from Oracle to SQL
server.

Is DTS the way to go and what about the limit in sql server of row size
being 8060 and oracle much much larger

What about implied relationships with the Client of the Oracle database.

Worred can an MVP be helping.

Hilary Cotter
8/4/2006 11:47:15 AM

DTS is the way to go for this. Replication is good for continuous.

For the problem with the data lengths, use the text datatype on the SQL
Server side, or use varchar(max) in SQL 2005.

I am not sure what you mean by this - "Worred can an MVP be helping." If it
worries you that an MVP is helping, I will refrain from comment, if it does
not worry you I am:)

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

sql server replication : Replication Problem Oracle to SQL Server