How to save all tables in the database as Qvd files.

    This Article demonstrates how to save all tables in the database as QVD files.

    1. Download and install Advanced ETL Processor Ent
    2. Create new directory to store QVD files
    3. Create database connection to pull data from
    4. Create new package
    5. Add “File operation” to the package and configure it
    6. Add Export to the package and configure it
    7. Execute package
    8. Job is one


    Notes

    Data is exported into specific directory first so it is important to clean it for so we use file operation for it.

    Export object  uses mask to find the tables and when new table is added it will be exported automatically.

     

    Screenshots

    Package

    Exported QVD's

    File Operation

    Export Object Properties

     

    More information about Advanced ETL Processor

    Advanced ETL Processor Enterprise is data integration automation Tool

     

    By combining simple Package actions together Advanced ETL Processor Enterprise helps businesses and Fortune 100 companies build complex data-warehouses and automate complicated business processes with ease.