共用方式為

  • 發行項

CopySubscriptionDatabase Method

未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能，並規劃修改目前使用這項功能的應用程式。

The CopySubscriptionDatabase method copies a subscription database that has pull subscriptions, but no push subscriptions. Only single file databases can be copied.

語法

object.CopySubscriptionDatabase(szFileName,[fOverWriteExistingFile])

Parts

  • Object
    Expression that evaluates to an object in the Applies To list.

  • szFileName
    String that specifies the complete path, including file name, to which a copy of the data portion (.mdf) file is saved.

  • fOverWriteExistingFile
    Optional Boolean that specifies whether to overwrite an existing file of the same name specified in the szFileName parameter. The default is FALSE.

Prototype (C/C++)

HRESULT CopySubscriptionDatabase(
SQLDMO_LPCSTR pszFilename,
BOOL fOverWriteExistingFile);

備註

You can use CopySubscriptionDatabase to copy a subscription database to a file as an alternative to applying a snapshot at the Subscriber. The database must be configured to support only pull subscriptions. Users having appropriate permissions can make copies of the subscription database and then e-mail, copy, or transport the subscription file (.msf) to another Subscriber, where it can then be attached as a subscription.

This technique is useful for copying highly customized databases that contain user-defined objects, such as triggers, stored procedures, and views.

To copy a subscription database

  1. Use the CopySubscriptionDatabase method to copy the subscription database as an .msf file.

  2. Use the AttachSubscriptionDatabase method to attach the .msf file to the Subscriber.

    [!附註]

    If an application calls CopySubscriptionDatabase on an instance of SQL Server version 7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000" are returned.