Hi db042190,
Question 1:
First, let me introduce you to a concept.
Articles are the basic units to be replicated, such as tables, procedures, functions and views(not the entire source db). Articles can be scaled vertically or horizontally by using filters. Multiple articles can be created for the same object.
Question 2:
No. For detailed reason, you can learn about the logic of replication.
For example: Snapshot replication does not track any data changes after the snapshot is generated, so to synchronize data changes you need to apply a new snapshot to the subscription server each time, completely overwriting the existing data. Transactional replication tracks changes through SQL Server's transaction log, and replication sends changes to the subscription server on a transaction-by-transaction basis. Merge replication, on the other hand, tracks data and architectural changes through triggers and system tables.
You can start from this: https://learn.microsoft.com/en-us/sql/relational-databases/replication/types-of-replication?view=sql-server-ver16
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".