Description
Below is my discussion question. I need 1- 2 pages in total. Proper formatting and referencing is needed.
"Replication and SSIS"
- Imagine you are a DBA for a Regional Bank located in the South East. Your job is to ensure replication takes place between the branch offices and the main headquarters. Consider the use of snapshot, transactional, and merge replications, and provide an example of when each of these services could be used in the banking industry. Identify the service you would use and the reasons for your selection.
- Suppose your company has decided to use the MS SQL Server Integration Services. Using the Internet, research this service and determine the service that you would use. Provide a rationale for your response.
Explanation & Answer
Hello,kindly consult me if you need any editing, formatting, or clarification. Thank you
Running Head: REPLICATION AND SSIS
1
Replication And SSIS
Name
Institutional Affiliation
REPLICATION AND SSIS
2
Snapshot replication takes a picture of the published objects and applies it to a subscriber.
Every time the snapshot is applied, the snapshot replication overwrites the data. Snapshot
replication could work well for fairly static data if the data could be synced between the intervals
(Carter, 2015). In cases where the subscriber is not connected, any data meant for replication
would be a...
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
The Metamorphosis
by Franz Kafka
The Subtle Art of Not Giving a F*ck
by Mark Manson
Too Much and Never Enough
by Mary L. Trump
Big Little Lies
by Liane Moriarty
Fools Crow
by James Welch
How to Win at the Sport of Business
by Mark Cuban
The Two Towers
by J. R. R. Tolkien
The Magic Mountain
by Thomas Mann