I've been tasked with migrating a fairly complex legacy Sybase database into a MySQL database and I have no idea where to start. I can't use any off the shelf software, so I'm going to have to write some sort of script that takes all the info out of the Sybase database and puts it into MySQL. Does anyone have any resources or thoughts on how to do this quickly, as I have very little experience with Sybase or MySQL.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
closed as too broad by Mark Storey-Smith, Jon Seigel, Mat, dezso, Max Vernon Aug 7 '13 at 16:06
There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question.
Having no experience with Sybase, I suppose I would start by exporting the database schema into a text file, then go through and modify the
Next, dump the data from each sybase table into CSV format file and then in the MySQL database, use
Depending on your database size, this could be a painfully slow option, but it is 'easy'.
You can use the Sybase utility ddlgen to export the database structure, schema, objects, etc. from there you will have to go through the script files that are generated, and figure out what will run and what won't run.
Data can be exported by using the Sybase bcp utility, with whatever delimiters are necessary to import into your new database.
Both of these utilities are part of the Sybase installation, so they should be available for your use.
My answer here has more information on running ddlgen and bcp Sybase Databse Migration from 11.5 to 15