GenerateDatabaseUpgradeScript Method (WMI MSReportServer_ConfigurationSetting)
Generates a script that can be used to upgrade the report server database to the SQL Server 2008 schema.
Syntax
Public Sub GenerateDatabaseUpgradeScript(DatabaseName as String, _
ServerVersion as String, ByRef Script as String, _
ByRef HRESULT as Int32)
public void GenerateDatabaseUpgradeScript (string DatabaseName,
string ServerVersion, out string Script,
out Int32 HRESULT);
Parameters
Databasename
A string containing the name of the report server database to upgrade.ServerVersion
A string containing the version of the report server.Script
[out] A string containing the generated SQL script.HRESULT
[out] Value indicating whether the call succeeded or failed.
Return Value
Returns an HRESULT indicating success or failure of the method call. A value of 0 indicates that the method call was successful. A non-zero value indicates that an error has occurred.
Remarks
The generated script supports SQL Server 2000, SQL Server 2005, and SQL Server 2008.
Requirements
Namespace: root\Microsoft\SqlServer\ReportServer\RS_<EncodedInstanceName>\v10\Admin
Platform: Windows Server 2003, Datacenter Edition; Windows Server 2003, Enterprise Edition; Windows Server 2003, Standard Edition; Windows Vista; Windows XP Professional with Service Pack 2 (SP2) or Service Pack 1 (SP1); or Windows 2000 (all versions)