Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Stephan Hennekens: "Excelent tools!!! Suberb design and interface. I have just pumped an Access database into a SQLite database. All the data including the indexes with just a few clicks".
Gianmarco Brundo: "I have purchased SQLite Mestro and SQLite Data Wizard, your products are very good".

More

Add your opinion

SQLite Data Wizard online Help

Prev Return to chapter overview Next

Command line options

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

 

The SQLite Data Wizard command line syntax is as follows:

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

 

mydatawizard[.exe]

The SQLite Data Wizard program file.

<task>

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).

<template_file_name>

The template with all the task's settings.

<log_file_name>

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

 

Examples.

The examples below assume that you are entering the command lines in the SQLite 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