How to synchronize two databases

  • hi..

    Any tsql code for synchronize two databases.

    Thanks
    Dastagiri.D

  • I guess there are tools. (not sure about ss2k5 itself) checkout readgate's sqlcompare, that one should be useful.

    ---------------------------------------------------------------------------------

  • Based on your vague question, here are some vague answeers:

    Not T-SQL, but ....

    Replication

    Log Shipping

    Mirroring

    Backup/Restore

    T-SQL

    Truncate table ....

    Insert into ....

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply