If you want to do it the real hard way, you can command-line query, or in a shell script of course to get the data from the tables, We have been doing that for some time now and very succeessfully.
What you have to do is write a shell script to output the table data into a delimited file for example.
This is a portable format that can insert into whatever you like.
I use dsplit as an example:
I'll give you a sample of the script:
/cms/toolsbin/cmsql -q < /export/home/cmssvc/dsplit.sql > /export/home/cmssvc/dsplit.txt
This would be the SQL statement it calls, put it in a file called dsplit.sql for example
select * from dsplit where row_date = DATE(CURRENT) - 1
Build a script around this, you can schedule with CRON, and you have a fully automated export. Then pick it up from the other server, and import it there.
Rob