Posts: 3,621
Name: Thierry
Location: I'm the uber Spaminator !
|
You can't.
That for multiple reasons:
1) The data types are not the same on the 2 db's
3) The functions are not identical and aren't called with the same parameters
4) Depending the mysql backend you choose, foreign keys, triggers and stored procedures are not supported / don't have the same syntax
5) If you enforce integrity (IE, have foreign keys) then your db should not use an auto-increment property, neither in mysql nor in ms sql server.
99.999999% of chances that they do are using it, thus making synchronization impossible.
If you want to have synchronized db's, then:
1) use the same db on both end
2) set a master and join the other as a slave
Then the 2 will be perfect copies. But you will only be able to make changes in the master. Not in the slave.
The last options would be not to have 2 db's, but just one, and make it part of your local network with a VPN.
That way, the modification would all be made on the same db.
Duplication is almost never a good idea in computing, and even more in databases...
__________________
Only a biker knows why a dog sticks his head out the window.
|