Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    Regular Coder
    Join Date
    Dec 2008
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Synchonizing database

    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

  • #2
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,634
    Thanks
    4
    Thanked 148 Times in 139 Posts
    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.

  • #3
    Supreme Master coder! abduraooft's Avatar
    Join Date
    Mar 2007
    Location
    N/A
    Posts
    14,853
    Thanks
    160
    Thanked 2,223 Times in 2,210 Posts
    Blog Entries
    1
    i want to synchornize data between mysql and my sql server 2005
    Did you mean "my" SQL server-2005?
    The Dream is not what you see in sleep; Dream is the thing which doesn't let you sleep. --(Dr. APJ. Abdul Kalam)

  • #4
    Regular Coder
    Join Date
    Dec 2008
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by guelphdad View Post
    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

  • #5
    Regular Coder
    Join Date
    Apr 2009
    Posts
    244
    Thanks
    1
    Thanked 20 Times in 20 Posts
    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


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •