Continue from our previous post, please find the below sample screenshots of MAXDB Studio to use LOADERCLI
Once you install MAXDB studio in windows, you can see that it’s also deploy the LOADER.
I have installed the latest MAXDB Studio available in SMP.
Once Installed you can connect the existing DB.

MaxDB DB connection
Make sure the Commandbuffersize parameter should set to below value other export/import failed.

MaxDB commandbuffersize parameter
Right click on DB & click on SQL Editor

MaxDB SQL editor connect
Provide your SQL credentials

MAX DB SQL Credentials
It will connect to DB & open the SCHEMA as below –

Schema Connection
Select the Schema & Right Click —-> Export

MAxDB SQL Export through LoaderCli
Select the default options & start the export.
It will export the Entire Schema with Tables & Data.

MaxDB Export

MaxDB Export

MaxDB Export

MaxDB Export

MaxDB Export
Check the Exported Contents on folder as given during Export, it will contain Catalog & Data files.

MaxDB loadercli export contents
MaxDB Lodercli Import Procedure
Follow the same steps by logging to Target DB via SQL Login & Right Click —-> Import & follow the same to import.
Note – As i am importing the SCHEMA in same DB so my SCHEMA is already exists so i have chosen “Add to Existing Schema”. it will import the CATALOG & TABLE contents on existing schema(Overwrite).

MaxDB Loader Cli Import Procedure

MaxDB Loader Cli Import Procedure

MaxDB Loader Cli Import Procedure

MaxDB Loader Cli Import Procedure

MaxDB Loader Cli Import Procedure

MaxDB Loader Cli Import Procedure

MaxDB Loader Cli Import Procedure

MaxDB Loader Cli Import Procedure
Once Import Successfully completed, you can verify the DB contents from Source to Target by running below SQL command in MaxDB Studio SQL Editor.
select * from tablesize order by ROWCOUNT
It will show the Tables & their Rowcounts to compare between 2 DB’s.