NmPsDmp: Console Named Pipe Dump Device Sample

Click to open or copy the files for the NmPsDmp sample.

This sample is a DB-Library program for using named pipe dump devices for backup and restore data from SQL Server 95. This program shows the usage of named pipe dump devices on the client side.

The program needs the following arguments (it asks from the user interactively):

• Operation: DUMP/LOAD.
  
  
• Servername: Name of the server to dump from/load into.
  
  
• Databasename: Name of the database to dump/load.
  
  
• Stripenum: Number of pipes to use for dump/load.
  
  
• Dumpname: Prefix of the files to write/read the dumped/loaded data (DMP postfix).

Building SDK Samples

This sample uses the following keywords:

_beginthread; argvalue; atoi; bufalign; close_up_pipes; closehandle; createfile; dbclose; dbcmd; dberrhandle; dbfreelogin; dblogin; dbmsghandle; dbnextrow; dbopen; dbresults; dbsetlpwd; dbsetluser; dbsqlexec; dump_proc; err_handler; exit; flushfilebuffers; free; getlasterror; getnamedpipeinfo; load_proc; malloc; msg_handler; newarg; parse_parms; printf; readfile; set_up_pipes; setfilepointer; setnamedpipehandlestate; sleepex; sprintf; strcat; strcmp; strcpy; switch; waitnamedpipe; writefile