View Single Post

   
  #4 (permalink)  
Old 04-08-2008, 04:17 PM
Dave Allen
 
Posts: n/a
Default Re: Migrating sybase from W2K to Unix solaris

If there are no binary fields you could use bcp in character mode this is
supported on both platforms

"Brian Ceccarelli" <spam@talusmusic.com> wrote in message
news:V0V_b.30179$%d3.2823041@twister.southeast.rr. com...
>
> "Luc Van der Veurst" <lucv@nospam.be> wrote in message
> news:403afe6d$0$562$e4fe514c@news.xs4all.nl...
> > Maria <evoradba@yahoo.ca> wrote:
> > >
> > > I have a sybase dump version 11.9.2.5 ON NT and I have created a
> > > database on solaris 5.8. sybase 12.0.0.8. when I loaded I get the
> > > following error message
> > >
> > > Unexpected end of file while reading beginning of dump. Please
> > > confirm that dum
> > > p media contains a valid SQL Server dump. The SQL Server error log may
> > > contain m
> > > ore information on the problem.
> > >
> > > I even tried different version of sybases, and still get this error,
> > > Is sybase not compatible for across platform migration?

> >
> > No, only if platforms are binary compatible. This is not the case
> > for windows and solaris 5.8.
> >
> > Luc.
> >

>
> You can do this with DBPowerSuite. http://www.dbpowersuite.com The
> program to use in DBPowerSuite is called "psCopySchema". It will copy
> both the schema and data.
>
>
> Brian
>
>
>
>
>
>
>
>
>



Reply With Quote