Is there a way to dump a live database? or setup replication from Sybase to mysql?

[a***@gmail.com]

Hello;

I am facing a challenge here.

I need to dump a live database while the database is live so that I can
migrate it over to another db, in my case to mysql. I can not have any
downtime.

Is there a way to dump all the tables while the database is still up
and running, port it over to mysql.

and for a database with over a 1000 tables (all pure text) what is the
rough estimate on time?

Or better yet, can i setup replication between sybase ASE 15 and mysql?
Thanks

[Mark A. Parsons]

From a similar Sybase TS case:

Q: Is there a direct connect available for MySql? or, can we replicate directly to MySql directly without a direct connect?

A: You can try using Enterprise Conenct Data Accesss 12.6 and get an odbc driver for MSysl (preferably from data direct). Treat all replication as if you are replicating to ms/sql server, scripts etc. We have not certified this here so you are on the leading edge so to speak. It all depends on how good the driver is and wheter it is acceptabed by ecda.

Post by a***@gmail.com
Hello;
I am facing a challenge here.
I need to dump a live database while the database is live so that I can
migrate it over to another db, in my case to mysql. I can not have any
downtime.
Is there a way to dump all the tables while the database is still up
and running, port it over to mysql.
and for a database with over a 1000 tables (all pure text) what is the
rough estimate on time?
Or better yet, can i setup replication between sybase ASE 15 and mysql?
Thanks

[Jason L. Froebe [TeamSybase]]

Post by Mark A. Parsons
Q: Is there a direct connect available for MySql? or, can we replicate
directly to MySql directly without a direct connect?
A: You can try using Enterprise Conenct Data Accesss 12.6 and get an
odbc driver for MSysl (preferably from data direct). Treat all
replication as if you are replicating to ms/sql server, scripts etc. We
have not certified this here so you are on the leading edge so to speak.
It all depends on how good the driver is and wheter it is acceptabed by
ecda.

Hi Mark,

What you've proposed has been in use at several companies that I know of
for a couple years.

Another option would be to use the perl module Sybase::RepAgent
http://search.cpan.org/~bdulfer/Sybase-RepAgent-0.03/RepAgent.pm to
replicate *from* MySQL. I'm the new maintainer for this perl module :)
--
Jason L. Froebe

Help find a cure for breast cancer! Net proceeds benefit the Susan G.
Komen Breast Cancer Foundation and the National Philanthropic Trust.
Help by donating at http://tinyurl.com/ylbghm - I'm walking 60 miles in
3 days in August 2007. (The day I return from TechWave is the first day
of the Walk)

WebBlog http://jfroebe.livejournal.com
Tech log http://www.froebe.net/blog

[none]

As Mark said you could try to use the repserver method. This will be the
only way to ensure that the MySQL database is current at the time of the
switchover to MySQL from ASE.

There would be a couple of options to do what you'd want, but in every
case the copy of the ASE database will not be current.

For example, you could BCP out every table in character mode - and load
the char data into MySQL - I'm sure MySQL has an import data type of
functionality.

As for how long it would take, how long is a piece of string? What
hardware are you running the database(s) on? How big is your database?
Rows per table? The only way you'll know how long this will take, is to
do it and time it.

Good luck

TS

Post by a***@gmail.com
Hello;
I am facing a challenge here.
I need to dump a live database while the database is live so that I can
migrate it over to another db, in my case to mysql. I can not have any
downtime.
Is there a way to dump all the tables while the database is still up
and running, port it over to mysql.
and for a database with over a 1000 tables (all pure text) what is the
rough estimate on time?
Or better yet, can i setup replication between sybase ASE 15 and mysql?
Thanks