Re: Importing sql server 7/2000 database into Oracle

From: E Sullivan <ellie999nospam_at_nospamptd.net>
Date: Tue, 24 Feb 2004 12:03:16 -0500
Message-ID: <f6idnU1-Zr1SHqbdUSdV9g@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:03:16 CST