Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news.moat.net!border1.nntp.sjc.giganews.com!nntp.giganews.com!local1.nntp.sjc.giganews.com!nntp.nildram.net!news.nildram.net.POSTED!not-for-mail NNTP-Posting-Date: Wed, 03 Mar 2004 15:03:11 -0600 Message-ID: Date: Wed, 3 Mar 2004 17:35:41 +0000 From: Jim Smith Newsgroups: comp.databases.oracle.server Subject: Re: Importing sql server 7/2000 database into Oracle References: <2LGdnUSaYJzJ66bdUSdV9g@ptd.net> Organization: At Home MIME-Version: 1.0 Content-Type: text/plain;charset=us-ascii;format=flowed User-Agent: Turnpike/6.02-U () Lines: 25 NNTP-Posting-Host: 81.6.247.105 X-Trace: sv3-TEkwY5WcyTptVRYFPunqwRdvIIajO1uQYM5kdX8B7IJlc9aSMHeSuf/DnUwkmp5nckDY0Hry7MNaqRu!j8HQvkoiApft+0KadwGITWpJfUD5OP4obbJhcrPEXzrm93sALoENDKCG5ycWD+VKTTP4avern+nM!4w== X-Complaints-To: abuse@nildram.net X-DMCA-Complaints-To: abuse@nildram.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.1 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:256228 In message <2LGdnUSaYJzJ66bdUSdV9g@ptd.net>, E Sullivan writes >Hi, > >Is it possible to import a MS sql server 7 or 2000 database into Oracle? >Also, if this is possible, would it be better to just import tables and no >stored procedures? > >thanks, > >Ellie > > You can't import directly. The best approach is probably to use Oracle's Migration Workbench. It will convert all the data types, create the tables in oracle and copy the data from sql server to oracle. You won't be able to transfer or use the stored procedures as oracle and sqlserver use completely different languages. -- Jim Smith Because of their persistent net abuse, I ignore mail from these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw For an explanation see