Re: Importing sql server 7/2000 database into Oracle

Other may have another take on this - but

Some of the answer will be dependance on database types used and the data volumes we are talking about. If fairly standard types are used and the database is no 'too' large I wuold create import scripts from the the source database.

i.e. use transact sql to create output files which themselves are import scropts in standard ansi or Oracle sql.

Like all things I wuold test each one first. both for functionality and timings

Regards Kevin

"E Sullivan" <ellie999nospam_at_nospamptd.net> wrote in message news:f6idnU1-Zr1SHqbdUSdV9g_at_ptd.net...
> The stored procedures probably won't be needed so that's ok. I think the
> difference may be because mssql server uses "transact sql" which is their
> version of sql statements. Did we really expect MS to play nicely!
>
> Can the database be attached/imported or would I have to create a
delimited
> text file?
>
> Thanks again.
>
>
> "Kevin A Lewis" <Kevin_A_Lewis_at_Hotmail.com> wrote in message
> news:UjL_b.22$mj7.1_at_newreader.ukcore.bt.net...
> > Tables and indexes only surely - have you compared the stored procedures
> in
> > SqlServer and Oracle! Every one I have ever seen have been quite
> different.
> >
> > Regards Kevin
> >
> > "E Sullivan" <ellie999nospam_at_nospamptd.net> wrote in message
> > news:2LGdnUSaYJzJ66bdUSdV9g_at_ptd.net...
> > > 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
> > >
> > >
> >
> >
>
>
Received on Tue Feb 24 2004 - 11:12:14 CST