Interbase, Paradox conversion to Sybase

[Alistair]

Hi,

I am trying to convert an interbase and Paradox database to Sybase...
Does anyone know how to do this? Are there any tools on doing this?

Regards
Alistair

[Anthony Mandic]

Alistair wrote:

> I am trying to convert an interbase and Paradox database to Sybase...
> Does anyone know how to do this? Are there any tools on doing this?

I don't know if there are any tools available. First you would
need to determine how compatible the schema design is between
these two. I'd suggest starting by doing some searching at
Sybase's web site. There is an Oracle migration document there
(and I believe one for MS SQL Server). Even if there isn't one
for your particular database you might get some ideas. You would
use bcp or DirectConnect (assuming there's a plugin for your
database) and CIS to copy data over. Massaging the schema
design and the related data would be the biggest headache.

-am © 2003

[Alistair]

Thanks Anthony...
I did find a way. I converted the Paradox DB to SQL Server, then
converted it to Sybase... Was very easy.

[Anthony Mandic]

Alistair wrote:
>
> I did find a way. I converted the Paradox DB to SQL Server, then
> converted it to Sybase... Was very easy.

Mind if I ask what you used?

-am © 2003

[Alistair]

I had a Paradox DB. I then created a new database in SQL server2000.
Then I imported the DB files from Paradox into my new DB. Worked very
well.
Then, in SQL Server, there is an option to export data. I then created
a new blank database in Sysbase (Sybase Central), then in SQL server,
I exported the data to that database... Had some issues where Sybase
was trying to convert date fields to Binary fields!, but got it all
done in the end.

[Anthony Mandic]

OK, I thought you might have either used PowerDesigner or SQL Server's
data migrator.

-am © 2003