Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sybase vs Oracle - which is better?
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:Received on Fri Dec 04 1998 - 00:00:00 CST
> 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