GenerateDatabaseUpgradeScript Method (WMI MSReportServer_ConfigurationSetting Class)

Generates a SQL Script that can be used to create a report server database.

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 sint32 HRESULT);


A string containing the name of the report server database to upgrade.


A string containing the version of the report server.


[out] A string containing the generated SQL script.


[out] Value indicating whether the call succeeded or failed.

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.

The generated script supports SQL Server 2000 and SQL Server 2005.

Namespace: root\Microsoft\SqlServer\ReportServer\v9\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)