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
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.
[!참고] 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:
참고 항목
참조
AttachSubscriptionDatabase Method