troubleshooting Question

Suggest approach to replication strategy for reporting database SQL2000.

Avatar of Austrian_Des
Austrian_DesFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft SQL Server
16 Comments1 Solution380 ViewsLast Modified:
Hi All,

I've struggled to think of a sensible, descriptive title for this question but hopefully the following explanation will help!

I am using SQLServer 2000.

I have 2 Databases.
The 1st database (I call it ‘Staging’) contains about 30 tables.
The 2nd database (I call it ‘Reporting’) contains about 200 tables.

The 30 tables in Staging are identical in structure to their counterparts in Reporting.

My objective, on a routine basis (hourly would be fine), is to make the 30 tables in Reporting contain the same rows of data as in Staging.

The constraints on this are as follows:

1.      The Reporting tables must always contain data. The data can be out of date but the tables must never be empty.
2.      The Staging tables must be allowed to be updated, inserted, deleted and truncated as often as required.

I would like to know the best way to approach this issue. I have tried many approaches but all failed for one reason or another. I intentionally won’t list the approaches I have tried as it could be that my approach was correct but the implementation was wrong. I’d like this question to start from a clean sheet.

Thanks

Des
ASKER CERTIFIED SOLUTION
Austrian_Des

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 16 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 16 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros