Advise needed on a sync issues between MySQL and a Firebird database.

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

Quote:

---

Originally Posted by AndyGable

does anyone know a better way

---

A better way than what? We don't know what you're doing so we can't know what you might be doing wrong. Also, a crash is an unhandled exception so it's important that we know what that exception is and where it's thrown.

Quote:

---

Originally Posted by jmcilhinney

A better way than what? We don't know what you're doing so we can't know what you might be doing wrong. Also, a crash is an unhandled exception so it's important that we know what that exception is and where it's thrown.

---

All I get as in an error message is the ide shows a message and says "the stream has refused the information" and that is on the firebird connection.

What I'm bascilly doing is copying from MySQL database all my product information that is needed for the PoS application to run if the server is offline.

With Linux I can just do a loop though the entire record set and it works fine but the vb version shows that error message every so often (maybe I'm over doing the insert volume or something)