If you need to extract a sizeable amount of data from a Microsoft Content Management Server 2002 (MCMS) database you have two options:
- Using CMS 2002 API (PAPI)
- Interacting directly with the CMS 2002 database
Although the second option it is totally discouraged due to the fact that the database schema is not published and CMS server executes complex procedures against this database, we are going to use it, but we are only going to do simple read-only queries against the CMS database. Under no circumstances should write operations be performed directly against the database. The PAPI is the appropriate interface for writing to the CMS database. Continue reading »