question

Sherwin avatar image
Sherwin asked

Table replicate using SSIS

Hi, I'm trying to replicate few tables from a Source DB to destination DB. Both Databases are sql server databases. The only issue is that the source DB gets refreshed from production DB backup every night which breaks its replication to the destination DB. Is there a way I can achieve this table replication without it disconnecting due to the daily restore?

sql-server-2008ssisreplicationsql server 2012table
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.