Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    25

    Unanswered: Export database tables

    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!!!

  2. #2
    Join Date
    Dec 2004
    Location
    Italy
    Posts
    32
    What about a periodical backup of the operative database and a restore into a work database?

  3. #3
    Join Date
    Jul 2004
    Posts
    25
    The database will periodically clean! And the data in it will be removed, but we need to store all data (deleted) separate.

  4. #4
    Join Date
    Dec 2004
    Location
    Italy
    Posts
    32
    Yes, then. A periodical export is the simplest way.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •