i have an old application with sybase ASE 12 as the database on solaris 2.7 on sun sparc workstation . I am trying to build an application on a windows pc with windows 2000 as the OS. the application will repliacte the sybase db and carry out some analysis. I am using mysql 5 as the db as it is free. but there is no restrication. i can go for any db like sybase , oracle . but before deciding on that i am looking for database replication solution between the sybase on the workstation and the database on the pc . by replication i do not something like migration which is one time . i looking for something which is continous and writes only the updates to the target database , not all unchanged data.
please suggest a solution.
does any such solution exist between sybase and mysql.
I would recommend you use sybase warm standby as it is very easy to set up. Would I be correct in assuming that you do not have much experience with sybase replication server. If that is the case then, it can be a bit tricky, but do not lose heart.
First, I would say use Sybase ASE all throuhg, this will keep things simple.
then install Sybase Repserver (you would need a licence for this). I would say go for 12.6 verison of Rep server. (downloadable from sybase.com)
read the online installation instructions for rep server.
the replicate database would be an identical copy of the primary and any DML /DDL changes made to the primary will be applied to the replicate if you decide to set up warm standby.
setting up warm standby is straight forward, just one stored proc sp_reptostandby and it will be good to go. but you will need to set everything right for this to work fine.