GenerateDatabaseUpgradeScript Method (WMI MSReportServer_ConfigurationSetting Class)

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

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 sint32 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 and SQL Server 2005.

Requirements

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)

See Also

Reference

MSReportServer_ConfigurationSetting Members
MSReportServer_ConfigurationSettingForSharePoint Members

Help and Information

Getting SQL Server 2005 Assistance