Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Paul Gibson: "The strength of SQL Maestro Group's technical skills and support allow us to recommend PostgreSQL Maestro and PostgreSQL Data Wizard to others. Above that, they provide us with amazing value (great service, fair price) in comparison with every other software development teams that I've researched".
Michael Pavitsky: "SQL Maestro Group provided the kind of services and support for managing PostgreSQL data expected in a true business partnership. Their devotion to customer satisfaction and cost curtailment is a pleasure for PostgreSQL users. I wouldn?t hesitate to recommend PostgreSQL Data Wizard to any of my peers and I know and trust they will surpass all expectations".


Add your opinion

PostgreSQL Data Wizard online Help

Prev Return to chapter overview Next

Command line options

PostgreSQL Data Wizard supports a number of command line options that make it possible to fully automate the data management operations.


The PostgreSQL Data Wizard command line syntax is as follows:

mydatawizard[.exe] <task> <template_file_name> [<log_file_name>]



The PostgreSQL Data Wizard program file.


An operation to execute. It can be one of the following:

import (for Data Importing tasks);

export (for Data Exporting tasks);

sqldump (for SQL Dump tasks);

blobimport (for BLOB Import tasks);

blobexport (for BLOB Export tasks).


The template with all the task's settings.


The name of text file to store log information (optionally).



The examples below assume that you are entering the command lines in the PostgreSQL Data Wizard program directory.  Don't forget to enclose all paths and filenames containing spaces in quotes.

mydatawizard export "C:\Templates\Export\MySQL\northwind.extx" "C:\Logs\Export_to_MySQL_NBA_db.log"
pgdatawizard.exe import  "D:\Templates\Import\PostgreSQL\northwind.imtx"
mydatawizard.exe sqldump "C:\Templates\SQLDump\MySQL\sakila.sdmpx" "C:\Logs\SQLDump\MySQL\sakila.log"

Prev Return to chapter overview Next