Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.freenet.de!news.germany.com!postnews.google.com!k70g2000cwa.googlegroups.com!not-for-mail From: "sybrandb" Newsgroups: comp.databases.oracle.server Subject: Re: Migration from sql server to oracle Date: 10 Oct 2006 01:37:36 -0700 Organization: http://groups.google.com Lines: 40 Message-ID: <1160469456.333573.47130@k70g2000cwa.googlegroups.com> References: <1160461595.978214.179380@c28g2000cwb.googlegroups.com> NNTP-Posting-Host: 192.33.238.6 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1160469461 25907 127.0.0.1 (10 Oct 2006 08:37:41 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 10 Oct 2006 08:37:41 +0000 (UTC) In-Reply-To: <1160461595.978214.179380@c28g2000cwb.googlegroups.com> User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1),gzip(gfe),gzip(gfe) X-HTTP-Via: 1.1 PXYBEBR003 Complaints-To: groups-abuse@google.com Injection-Info: k70g2000cwa.googlegroups.com; posting-host=192.33.238.6; posting-account=d8kqXg0AAADvDUR8IdYEU7pAZnZ1O2PC Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:276900 On Oct 10, 8:26 am, "kunal" wrote: > 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 There is no such thing as urgent in a free volunteer support forum. If it is really urgent get paid support. Also Oracle has a free product called Migration Workbench on http://otn.oracle.com which allows you to migrate from Sqlserver to Oracle. As the datatype ntext doesn't exist in Oracle, your table can be probably converted by OMWB, but it will never be an exact replica. Sqlserver and Oracle are not compatible. I would start reading the Oracle documentation (at the same site) NOW. -- Sybrand Bakker Senior Oracle DBA