Re: Sybase vs Oracle - which is better?

Hello,
  BCP does allow you to specify a first-rwo and last-row to BCP out. So, if needed, it would be possible to break very large table into parts. If I were moving databases from one server to another on the same platform and character set and sort order, I'd problably dump the database to tape and restore it that way. BTW: A database dump does have all the database structures attributes - a BCP is just the data of a single table. Sybase does provide a few utilities to create the structure scripts such as defncopy, ddlgen and defgen.

Someone earlier mentioned that they could take an Oracle export file from a Solaris or AIX system and import it directly into an NT system. Sybase does not have this support. How does Oracle handle the character set high order and low order byte tranlations between platforms? Also, How does Oracle export handle a 2 Gb. file size limitation?

Thanks, Robert

denny_vk_at_my-dejanews.com wrote:
>
> Try moving a few gig using BCP even across servers on the same patform. How
> are you going to handle file sizes greater than 2GIG ? ( On most 32 bit unix
> flavours ). Plus you need all the scripts for creating the tables. You cannot
> obtain it from the dump.
>
> --
> Denny Koovakattu
>
> In article <36543257.7782_at_ibm.net>,
> RobertSimmons <abpitg_at_ibm.net> wrote:
> > Yassir Khogaly wrote:
> > >
> > > Which Sybase Products runs under NT and will be able to restore from Unix
> > > Sybase dump...?
> >
> > Hello,
> > It is not possible to directly dump a database on UNIX and load it
> > directly into a NT database. This is do to the native character sets.
> > The usual method of moving data betwwen the two different platforms is
> > to use a sybase utility called BCP ( Bulk Copy Program) which allows you
> > to copy tables out in a specified character set and then BCPing the
> > output file into the target database on the other platform. You'll have
> > to create a duplicate copy of the table on the target before you put BCP
> > in the data.
> >
> > Versions 11.x to 11.9.2 run on NT. Sybase does allow you to down load an
> > evaluation copy from their web sight.
> >
> > Robert
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Dec 04 1998 - 00:00:00 CST