Hi,
I am trying to create a dump of a sql database from VB6. From isqlw it goes like this:
dump database master to disk = "c:\mssql7\backup\test.dmp"
I am runnig MSSQL7 and VB6. Any idea on how to do this?
Thanks,
Yared
Printable View
Hi,
I am trying to create a dump of a sql database from VB6. From isqlw it goes like this:
dump database master to disk = "c:\mssql7\backup\test.dmp"
I am runnig MSSQL7 and VB6. Any idea on how to do this?
Thanks,
Yared
OK guys, I figured out how to do it myself. Here is the code:
*********
Private Sub Form_Load()
Dim name As String
Dim src As String
Dim dst As String
Dim dsn As String
src = "c:\mssql7\backup\master.dmp"
dsn = "Provider=SQLOLEDB.1;Password='';User ID=sa;Data Source=SQL_SERVER_NAME"
DE.Connection1.Open (dsn)
DE.Connection1.Execute "dump database master to disk = '" + src + "'"
DE.Connection1.Close