Hi everyone,

I hope someone can advise me on a slight issue I am having

I have a central database (MySQL) and my Linux system syncs no problem at all (about 5mins to sync over 13,400 records) but the windows version of my application crashes if to much record data is sent to the local database (firebird 2.5 and 3.0) so to work around this issues we have to sync the data I. Batches (so far we hit 63 batches of 250 records at a time and this can take upto 14mins to sync)

So does anyone know a better way to sync data from a MySQL database into a firebird database via a vb.net 2008 program

The system works locally so once then has done all it has to do is to keep any changes synced (and they are seconds on both systems)

I can post example code if needed

Thanks

Andy