April 7, 2016 at 6:25 am
Hello guys,
We are planning to enable CDC for one of our databases.
Can we restore a copy on a different server (WITH KEEP_CDC option) and run the initial/incremental load from the back up copy?
Since we already have an instance for reporting, we are trying to reduce/avoid the load on the production OLTP server to for the SSIS ETL loads.
Please share your thoughts. Many thanks!
April 7, 2016 at 6:38 am
SQL!$@w$0ME (4/7/2016)
Hello guys,We are planning to enable CDC for one of our databases.
Can we restore a copy on a different server (WITH KEEP_CDC option) and run the initial/incremental load from the back up copy?
Since we already have an instance for reporting, we are trying to reduce/avoid the load on the production OLTP server to for the SSIS ETL loads.
Please share your thoughts. Many thanks!
Just checking that you've assessed this: have you ruled out using Change Tracking in favour of CDC?
April 7, 2016 at 8:22 am
Is there any advantages of CT over CDC in this scenario for incremental data load to warehouse.
Can the incremental load using SSIS be run if the db is restored on another environment (daily refresh), not from production OLTP. Is the CT data preserved when restored to another environment?
There are 25-30 tables that needs to be enabled for incremental load.
Thanks!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply