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)