On a quarterly basis I need to provide our clients a copy of all their data. We need to provide this data in a database independent format (in other words I cannot simply send them a backup file). The typical client has roughly 1GB of data. This includes BLOB fields with files up to 10mb in size. These files are a mix of Office documents, PDFs, and images.
I’ve looked into both the BCP and the XML query capabilities, and from my understanding both only seem to work at the table level which would mean I would have to write a query per table. The schema size of this database makes those options prohibitively time consuming, not to mention future maintenance of this process seems costly.
The database independent format can be anything. XML and scripts (scripts have to support both Oracle and SQL) are less desirable due to the storage size that these typically require.