Results 1 to 1 of 1
Jan 21, 2006, 04:05 #1
- Join Date
- Feb 2004
- Huldenberg (Belgium)
- 0 Post(s)
- 0 Thread(s)
Synchronize MSSQL server with MySQL?
has someone done this yet?
I have a main server with a MSSQL db.
I have several people with laptops having an Apache and MySQL server installed.
the people can change things to the db on local. now what I want is that the db synchronize upon network/internet connection.
I have a timestamp for each row. so I someone changes something the timestamp is changed automatically. The idea is to compare the timestamp from each row. Oldest will be overwritten by the newest.
Is this a good way to go? Or is there any of the shelf function I don't know about? I'm wondering: what if the db becomes quiet large? won't it be taking ages to do al this?
2nd: Can I make the 2 SQL-servers communicate directly with each other? Or should I make the connection in php-script both ways, store evertyhing in variables and then do the update queries myself?
The users with the laptops are not good in working with a PC. So it has to be fully automatic (maybe a synchro forced by clicking a button, but that's the maximum I can ask )
KoenThe Path of excess leeds to the tower of wisdom (W. Blake)