Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
Synchonizing database
Old 06-16-2009, 07:28 AM Synchonizing database
Skilled Talker

Posts: 97
Trades: 0
i have mysql server 2005, and my databases are in phpmyadmin i want to:
1) Synchronizing the table in mysql server 2005 to the database that exists phpmyadmin with all its data (and vise versa)
2) When changing any data in mysql server 2005 it changes in the database that exists phpmyadmin with all its data (and vise versa)

i want to synchornize data between mysql and my sql server 2005
john_zakaria is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 06-16-2009, 08:48 AM Re: Synchonizing database
tripy's Avatar
Do not try this at home!

Posts: 3,621
Name: Thierry
Location: I'm the uber Spaminator !
Trades: 0
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.
tripy is offline
Reply With Quote
View Public Profile Visit tripy's homepage!
 
Reply     « Reply to Synchonizing database
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.16720 seconds with 12 queries