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

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

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.

Alistair wrote:
>
> 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.

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

-am © 2003