CopySubscriptionDatabase Method
Questa funzionalità verrà rimossa in una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.
The CopySubscriptionDatabase method copies a subscription database that has pull subscriptions, but no push subscriptions. Only single file databases can be copied.
Sintassi
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);
Osservazioni
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
Use the CopySubscriptionDatabase method to copy the subscription database as an .msf file.
Use the AttachSubscriptionDatabase method to attach the .msf file to the Subscriber.
[!NOTA] 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.
Applies to:
Vedere anche
Riferimento
AttachSubscriptionDatabase Method