Replication and SSIS

User Generated

qe.zvyyre

Business Finance

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.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
Just what I needed. Studypool is a lifesaver!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags