Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

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
Avatar of Austrian_Des
Austrian_DesFlag of United Kingdom of Great Britain and Northern Ireland image

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

Commented:
This problem has been solved!
Unlock 1 Answer and 16 Comments.
See Answers