Saroj13
asked on
How to r[b]eplace Sql Server replication with SSIS Package using on Production Databases[/b]?
How to replace Sql Server replication with SSIS Package using on Production Databases?
I have two production Databases StagingDB and ProductionDB. Sync StagingDB data to Production DB data nightly by Sql Server Agent Job.
Please let me know what's the best approach in SSIS Package to Sync Production Staging Database data to Production Target data.
Restriction:
---- Not having ability to create the backup of production database.
---- Should not delete the complete database or complete data.
Requirement is to merge the only the New, updated data, and deleted data from Staging Database to Production Database. Please proving the working SSIS package sample.
Thanks
I have two production Databases StagingDB and ProductionDB. Sync StagingDB data to Production DB data nightly by Sql Server Agent Job.
Please let me know what's the best approach in SSIS Package to Sync Production Staging Database data to Production Target data.
Restriction:
---- Not having ability to create the backup of production database.
---- Should not delete the complete database or complete data.
Requirement is to merge the only the New, updated data, and deleted data from Staging Database to Production Database. Please proving the working SSIS package sample.
Thanks
Since you said Replication is not feasible, how about change data capture?
Kindly share more details on what kind of data you change from Staging to Production database either last few days data or across how much data range so that we can guide you better.
Kindly share more details on what kind of data you change from Staging to Production database either last few days data or across how much data range so that we can guide you better.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
My only advice would be to not ever touch such database where backups cannot be created - honestly I never yet heard such a thing that you can't "create the backup of production database".