Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Sybase vs Oracle - which is better?

Re: Sybase vs Oracle - which is better?

From: <denny_vk_at_my-dejanews.com>
Date: 1998/12/04
Message-ID: <747hsi$4hv$1@nnrp1.dejanews.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US