Hi everybody!

I have a task:

We have application database. We have procedures to clean it (tables). It's application-side procedures. We must clean our database to keep our application workable. But we need to store full information from our database for future reporting purposes. How can I achieve this? Export database tables periodically into files? Can I import all this files into one big database for reporting (i.e. Crystal Reports)? What will be your's advice? Thank's!!!

What about a periodical backup of the operative database and a restore into a work database?

The database will periodically clean! And the data in it will be removed, but we need to store all data (deleted) separate.

Yes, then. A periodical export is the simplest way.