Print Logger Database Dumper

The Print Logger Database Dumper (plDBDumper.exe) is placed in the Print Logger folder. This command line tool is intended to "dump" your Print Logger related tables from the database to SQL script files, like this:

INSERT INTO H1_PRINTERS (LastModified,pAddingDateTime,pLastModified,pPrinterName,pPrinterDescription,pPrinterLocation,pPrinterShareName,pAudit,pdAudit,pRestrictions,pPrinterQuotaCosts,pPrinterQuotaCostsUsed,pPrinterQuotaPages,pPrinterQuotaKBytes,pPrinterQuotaPagesUsed,pPrinterQuotaKBytesUsed,pNetworkPrinter,pConnectedFromWin9x,pDoNotAdjustPrinterSettingsAutomaticaly,pNotExist,pRes1,pRes2,pPagesLimitEnabled,pPagesLimit,pColorPrinter,pPagesQuotaEnabled,pCostsQuotaEnabled,SoftQuota,DisableDownlevelDocuments) VALUES ('2010-04-12 16:52:04','2010-02-03 09:03:09','2010-03-19 19:44:13','Fax','','','','Yes',1,0,0,0,100,0,0,0,0,0,0,0,'',0,0,10,0,0,0,1,1)

INSERT INTO H1_PRINTERS (LastModified,pAddingDateTime,pLastModified,pPrinterName,pPrinterDescription,pPrinterLocation,pPrinterShareName,pAudit,pdAudit,pRestrictions,pPrinterQuotaCosts,pPrinterQuotaCostsUsed,pPrinterQuotaPages,pPrinterQuotaKBytes,pPrinterQuotaPagesUsed,pPrinterQuotaKBytesUsed,pNetworkPrinter,pConnectedFromWin9x,pDoNotAdjustPrinterSettingsAutomaticaly,pNotExist,pRes1,pRes2,pPagesLimitEnabled,pPagesLimit,pColorPrinter,pPagesQuotaEnabled,pCostsQuotaEnabled,SoftQuota,DisableDownlevelDocuments) VALUES ('2010-04-12 16:52:04','2010-04-10 19:48:43','2010-04-10 19:48:43','doPDF v7','','','doPDF v7','Yes',1,0,0,0,100,0,0,0,0,0,0,0,'',0,0,10,0,0,0,1,1)

The command line syntax is:

plDBDumper.exe [-out_folder] ["Path to output folder"] [-skip_documents]

-out_folder "Path to output folder" - instructs dumper to save all SQL scripts to the folder specified. When -out_folder is used, all SQL scripts is created as                                one table - one script file. Files are not compressed.

-skip_documents - instructs dumper to skip document tables (PrintedDocuments and BlockedDocuments). SQL scripts are compressed in archive                            HSLAB_Print_Logger-dumper.zip and saved to the %TEMP%\HSLAB Print Logger\plDBDumper folder.

When you run this tool without parameters, SQL scripts will be compressed in archive HSLAB_Print_Logger-dumper.zip and saved to the %TEMP%\HSLAB Print Logger\plDBDumper folder.

This tool also can be used as database backup tool.