Site Deployment export does not work on databases created before SP2 and moved to SQL Server 2005
This problem will occur with all databases which have been migrated from MCMS 2002 SP1a and then moved to SQL Server 2005. If you are affected by this issue please open a support case with Microsoft Support Services.
Databases created on SQL Server 2005 are not affected.
Update January 25, 2006: the hotfix for this request has been released and can be requested from Microsoft Support as KB 913401
The hotfix has been provided as self-extracting zip file. Two files are included:
These two files have to be copied into the <cms02 install path>\server\setup files\sql install directory.
Run DCA (Database Configuration Application); point to the existing (or any sp1a database) and click "next".
The DCA will indicate that an upgrade is needed and will apply the new upgrade script (_sp1aTosp2upgrade.sql) to the database. NOTE: make sure the user accessing the db has rights to change schema.
Unfortunatelly - due to the way this hotfix has been build - there are a couple of things to consider:
1) customers running the DCA to upgrade a SP1a database will be successfully upgraded and will reflect to CMS2002SP2.
2) customers running the DCA to upgrade a SP1 or RTM database will successfully upgrade to SP1a(!) and reflect CMS2002SP1a.
A second run of the DCA is required to upgrade the database to SP2. Without the second run of the DCA the database will not contain the new procedures from the hotfix.
(A list of all SP2 issues including state can be found here: Current known issues with MCMS 2002 SP2)