I can think of another reason. Changing user requirements. The way you have described it, your reporting database will lag production by a day. Suppose you invest the time and get this up and running and the users decide they don't want to wait a day? It depends on your users and your industry. For financial data, they would probably be okay with the day lag. But manufacturing users would not tolerate that. Dennis Williams