Replication of Table?

%3CLINGO-SUB%20id%3D%22lingo-sub-1773797%22%20slang%3D%22en-US%22%3EReplication%20of%20Table%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1773797%22%20slang%3D%22en-US%22%3E%3CP%3EGoal%3A%3CBR%20%2F%3E*Same%20database%20to%20have%202%20similiar%20table%20named%20test1%20an%20test2.%3CBR%20%2F%3E*Table%20test2%20is%20only%20used%20for%20query%20(read%20only)%20and%20table%20test1%20is%20only%20used%20for%20command%20(delete%2C%20create%20and%20update).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBackground%3A%3CBR%20%2F%3E*Test2%20is%20a%20replication%20of%20Test1%20(any%20changes%20in%20test1%20should%20update%20in%20table%20test2%20in%20realtime).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EProblem%3A%3CBR%20%2F%3EIs%20it%20possibly%20to%20make%20a%20replication%20of%20a%20table%20in%20the%20same%20database%20in%20SQL%20server%3F%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

 

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

Why not frequently copy over the data?