Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!c28g2000cwb.googlegroups.com!not-for-mail
From: "kunal" <kunal.jethwa@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Migration from sql server to oracle
Date: 9 Oct 2006 23:26:36 -0700
Organization: http://groups.google.com
Lines: 23
Message-ID: <1160461595.978214.179380@c28g2000cwb.googlegroups.com>
NNTP-Posting-Host: 202.67.4.3
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1160461599 32532 127.0.0.1 (10 Oct 2006 06:26:39 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 10 Oct 2006 06:26:39 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 chandgate4.mahindrabt.com:3128 (squid/2.5.STABLE6)
Complaints-To: groups-abuse@google.com
Injection-Info: c28g2000cwb.googlegroups.com; posting-host=202.67.4.3;
   posting-account=iRy07w0AAACPNSJM5V7C8Vxj-RJL6ltR
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:276887

Hi,

I need to migrate from sql server to oracle..

access to sql server is restricted...only select and few more grants
are given to us..

we need to take that data into oracle.. flat file is one option but we
dont need that one as solution as it needs manual intervention..

we have used hs services of oracle.. which is working fine except ntext
column in sql server..
which is creating lots of problem...


can anyone suggest how to create an exact replica of the table at
source end with ntext column in oracle..replica means data only..

we r able to fetch the data using dblink to sqlserver but unable to
create mlog in oracle...

please help it s urgent