How do I extract data for reporting purposes from a Sharepoint database?
There are issues with accessible tables directly. Even your read-only queries may introduce row or table locking that could conflict with normal WSS operations (unless you fine-tine any queries properly, which isn’t trivial). Any updates directly through SQL would put your server into an ‘unsupported’ state — for example, your data may no longer be upgradable to future versions of WSS, or some WSS functionality may break.
Related Questions
- There is a great deal of collected detailed data being accumulated in NetMosaic database. Is there a way to extract this data for further analysis outside of what is provided by NetMosaic?
- If I need only extract (dump) data from Oracle into flat ASCII files without loading into target database, what should I provide for target database?
- Is it possible to replicate, backup, extract and/or purge the historical data from the database?
