Hi -
You didn't mention which version of Sybase you are migrating from. I
just migrated our db from Sybase SQLAnywhere to MySQL v4.1 and there
were a couple things I found that didn't I had to change:
1) SQLAnywhere allows some words as column names that MySQL doesn't: I
had some a couple tables with a column called 'interval'- I had to
change it to d_interval to get my table to create in MySQL (got syntax
errors)
2) Same thing for 'order'... I had to change my 'order' columns to
'd_order'
3) For Autoincrement columns, the syntax is a little different:
SQLAnywhere:
CREATE TABLE my_test (
note_id integer NOT NULL DEFAULT autoincrement);
MySQL:
CREATE TABLE my_test (
note_id integer NOT NULL AUTO_INCREMENT);
Everything else came over ok in my case.
Good luck!
-Holly
-----Original Message-----
From: Nitin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 2:20 AM
To: Prasad Budim Ram; [EMAIL PROTECTED]
Subject: Re: Migration tools for sybase to MySQL
if you can export the same from sybase, then undoubtedly you can import
those iinto mysql
Nitin
----- Original Message -----
From: "Prasad Budim Ram" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 14, 2003 1:57 PM
Subject: Migration tools for sybase to MySQL
> Hi,
>
> Are there any tools to migrate db schema as well as data from sybase
> to mysql?
>
> Thanks,
> Prasad
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
