Synchonizing database

[john_zakaria]

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

[guelphdad]

There is no such thing as: "mysql server 2005", either you are running MySQL which is one database application or you are running SQL Server 2005 which is another. If the latter then your thread needs to be moved into the general database area.

[abduraooft]

i want to synchornize data between mysql and my sql server 2005 Did you mean "my" SQL server-2005? :)

[john_zakaria]

There is no such thing as: "mysql server 2005", either you are running MySQL which is one database application or you are running SQL Server 2005 which is another. If the latter then your thread needs to be moved into the general database area.

i mean sql server 2005, sorry i'm a beginner in qsl server 2005..
and till now i cant make a database because i cant connect to the server (windows --> iis) can anyone help me

[Mike_O]

Hey john_zakaria,

Not sure exactly what you mean there, but if I understand correctly, you have the same tables/views/etc in multiple locations(servers/databases) that you want to synchronize at real time. In this case, research about Transactional Replication.

Mike