Backup Restore MS Sql

Post Reply
Jack
Posts: 249
Joined: Wed Jul 11, 2007 11:06 am

Backup Restore MS Sql

Post by Jack »

Hello,
I have a MS SQL database and want to make backup of the table DEM.
I try this code but it d'nt work (go to the catch) :
***
csql:=[UNLOAD 'c:\apps\dem.txt' DELIMITER '|' SELECT * FROM DEM]

Try
oCon:Execute( cSQL )
Catch
ShowAdoEr(oCon,cSql )
Return
End try
***

Any idea ?

Thanks
Jack
Posts: 249
Joined: Wed Jul 11, 2007 11:06 am

Re: Backup Restore MS Sql

Post by Jack »

No idea about Backup ?
How is it possible to make a copy of a Table with a SQL command ?

Thanks
User avatar
Baxajaun
Posts: 853
Joined: Wed Oct 19, 2005 2:17 pm
Location: Gatika. Bizkaia

Re: Backup Restore MS Sql

Post by Baxajaun »

Post Reply