Sync. two SQL server 7.0 (Production and testing)

Discussion in 'MySQL' started by sqldba, Feb 13, 2008.

  1. #1
    Hi,

    I have two servers, one is a production server and other is a testing server. Both theses server must be in sync.

    Please can anyone let me know how to synchronize these two servers(automatically) without replication.

    In particular i want databases, tables, views, users and stored procedures to be same in both the servers. If a table gets added/deleted/update on the production , the same must be done on testing server.

    Please help on doing this. Can i implement logshipping, will that help me.


    Please give a best solution.

    Thanks in advance
     
    sqldba, Feb 13, 2008 IP