This topic has not yet been rated - Rate this topic

GenerateDatabaseUpgradeScript Method (WMI MSReportServer_ConfigurationSetting Class)

SQL Server 2005

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

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)

Reference

MSReportServer_ConfigurationSetting Members
MSReportServer_ConfigurationSettingForSharePoint Members

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD