Re: Sybase vs Oracle - which is better?

Theres one problem with your analogy here. BCP will not export triggers, or stored procedures, permissions etc... held on the tables.
Oracle's export does.
BCP is a joke.

RobertSimmons 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
Received on Fri Nov 20 1998 - 00:00:00 CST