Forum Discussion

sakura930's avatar
sakura930
Copper Contributor
Oct 13, 2020

Replication of Table?

Goal:
*Same database to have 2 similiar table named test1 an test2.
*Table test2 is only used for query (read only) and table test1 is only used for command (delete, create and update).

 

Background:
*Test2 is a replication of Test1 (any changes in test1 should update in table test2 in realtime).

 

Problem:
Is it possibly to make a replication of a table in the same database in SQL server?

Thank you!

1 Reply

  • olafhelper's avatar
    olafhelper
    Bronze Contributor

     

    No, you can not replicate a table within the same database.

    Why not frequently copy over the data?

     

Resources