[求助]兩個問題求大家相教
我使用的是VB+SQL開發的,現在有兩個問題不知道怎麽解決,求高手指點.1,怎麽實現上傳功能,無須上傳到網上,只需要上傳到本地文件夾就可以了
2,怎麽實現備份和還原數據庫?
[此贴子已经被作者于2006-2-24 11:16:02编辑过]
本地怎么说上传？拷贝就可以
2,怎麽實現備份和還原數據庫?
可以使用SQLDMO组件，很简单
This example illustrates using SQL-DMO to perform a complete database backup
.
' Create a Backup object and set action and source database properties.
Dim oBackup As New SQLDMO.Backup
oBackup.Action = SQLDMOBackup_Database
oBackup.Database = "Northwind"
' Example illustrates a striped backup using two target devices. Note:
' Device creation is not illustrated in this example.
oBackup.Devices = "[NorthDev1],[NorthDev2]"
' Optional. Backup set name and description properties provide
' descriptive text when backup header is displayed for the device(s).
oBackup.BackupSetName = "Northwind_Full"
oBackup.BackupSetDescription = "Full backup of Northwind sample."
' Call SQLBackup method to perform the backup. In a production
' environment, consider wrapping the method call with a wait pointer
' or use Backup object events to provide feedback to the user.
'
' Note: Create and connect of SQLServer object used is not
' illustrated in this example.
oBackup.SQLBackup oSQLServer
