Batch file commands to import the dumps

Write the below commands in batch file and execute through command prompt with the parameter values.

MySQL

"%~1\mysql" -h %2 -p%3 -u %4 %5 < "%6.sql" >> %7 2>&1

Call

cmd>MySQL_Import.bat "C:\Program Files\MySQL\MySQL Server 5.6\bin" localhost 1234 root app301 E:\ASBREST\AgileCloud\ReplicateApp\app1_bak e:\mysqldump.log

Oracle

imp %1/%2@%3 file=%~4 full=y log=%~5;

Call

cmd>Oracle_Import.bat app301 log orcl11g “E:\oradump.dmp” “E:\oralog.txt”

MSSQL

SQLCMD -U %1 -P %2 -S %3 -Q "RESTORE DATABASE %4 FROM DISK='%5' WITH RECOVERY, REPLACE, MOVE '%6' TO '%7.mdf', MOVE '%6_log' TO '%7_log.ldf'" -o %8

Call

cmd>MSSql_Import.bat sa dms@123 ARAVIND-PC\SQLEXPRESS app301 \\192.168.2.254\Backups\ mssqldump.bak v95 \\192.168.2.254\axpert\data\app301 E:\MSSqlLog.txt