DBCopier - Copy data between databases »

Download DBCopier Free Trial »     Buy DBCopier Now »

How to execute command line and scheduled to coping data between databases

When you save session

Copy data between databases - save session

Click "Save & Make Batch File"

Copy data between databases - make batch file

Click "OK", you'll get batch file created.

.bat file for Windows command line, or .sh file for Linux / macOS.

And you can run it in command line.

In Windows:

C:
cd "C:\Users\pan\AppData\Local\Programs\DBCopier\"
DBCopier session="C:\Users\pan\Documents\DBCopier_t.uld" logfile="C:\Users\pan\Documents\DBCopier_t.log"

	

In Linux:

/usr/share/DBCopier/DBCopierCmd session="/home/pan/Documents/DBCopier_t.uld" logfile="/home/pan/Documents/DBCopier_t.log"

	

In macOS:

/Applications/DBCopier.app/Contents/MacOS/DBCopier session="/Users/pan/Documents/DBCopier_t.uld" logfile="/Users/pan/Documents/DBCopier_t.log"

	

Or click "Create & Schedule Task", you can run this batch file at a specific time and/or at a certain time every day. See this for detail: Schedule Task.