Hello good people of Tek-Tips!
I'm planning a project to create a snapshot of data from our CRM database and place it into an MSDE database for reporting purposes. Here's the basic concept:
Pull specific fields from Problem Report, Change Request, and Service Order records that are currently open or have been closed within the past 18 months. Also pull specific fields from supporting relational tables such as notes and actions. Process data each night after close of business.
I'd like to be able to just do a "change" type update so that only the changed or new records are updated or inserted each night. I also want to put the majority of the workload on the MSDE server if possible. What's the most efficient method to accomplish this task?
1. Data Replication (as a subscriber)
2. DTS Package (SQLServer to SQLServer)
3. Scheduled Stored Procedure
4. Other
Thanks in advance for any insight you can provide.
Glen
VB.Net student.
I'm planning a project to create a snapshot of data from our CRM database and place it into an MSDE database for reporting purposes. Here's the basic concept:
Pull specific fields from Problem Report, Change Request, and Service Order records that are currently open or have been closed within the past 18 months. Also pull specific fields from supporting relational tables such as notes and actions. Process data each night after close of business.
I'd like to be able to just do a "change" type update so that only the changed or new records are updated or inserted each night. I also want to put the majority of the workload on the MSDE server if possible. What's the most efficient method to accomplish this task?
1. Data Replication (as a subscriber)
2. DTS Package (SQLServer to SQLServer)
3. Scheduled Stored Procedure
4. Other
Thanks in advance for any insight you can provide.
Glen
VB.Net student.