what is replication?
where do u use Go Keyword?
Answer / jijo
Synchronizing data and object between systems .
For example i have 50gb data in Delhi server(Publisher or
source ) i need to replicate into tow locations one into
mumbai server 10gb data (subscriber ) and another one into
kerala server 20gb data.
Publisher ---Source
Subscriber ---destination
Distributor--- Receive from publisher and forward to sub
Type of replications
1)Snapshot (one way)
Data refresh of the subscriber every time you synchronize.
2)Merge Replication (Two way)
Both publisher and subscriber can make change to the data.
Conflict :- When two participant chenge the same row at same
time
3)Transactional replication
As change made at the publisher its send to the distributor
and distributor into subscriber
Is This Answer Correct ? | 5 Yes | 0 No |
What are types of scd? : sql server analysis services, ssas
How do I save a stored procedure in sql server?
How to select some specific columns from a table in a query in ms sql server?
Do you know what is similarity and difference between truncate and delete in sql?
What is in place upgrade in sql server?
Explain some stored procedure creating best practices or guidelines?
What is SQL Server?
Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?
How exceptions can be handled in sql server programming?
What is side by side migration in sql server?
Explain what is lock escalation and what is its purpose?
Can you please explain the difference between primary keys and foreign keys?