Blog about SAP Learning & My Personal Interest

This site represent my personal views & findings on SAP Technology.

Menu

Skip to content
  • Finology

Tag Archives: loader cli export

SAP MAXDB: Loadercli Export/Import Screenshots

June 22, 2020 by adil
Leave a comment

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.

Posted in SAP
loader cli export loadercli MAXDB Maxdb studio SAP SQL login

Recent Posts

  • Experience on Google Chrome OS – Chromium
  • SAP MAXDB: Loadercli Export/Import Screenshots
  • SAP MAXDB : Export/Import through Loader utility
  • How to fix MaxDB SDBSETUP issue
  • AZ-120: Planning and Administering Microsoft Azure for SAP Workloads

Recent Comments

  • adil on SAP STANDALONE GATEWAY INSTALLATION & CONFIGURATION
  • Gokul on SAP STANDALONE GATEWAY INSTALLATION & CONFIGURATION

Archives

Categories

  • Cloud
  • Entertainment
  • General
  • IT
  • Networking
  • News
  • SAP
  • Tools/Service

Visitor Counter

Hit Counter

Recent Posts

  • Experience on Google Chrome OS – Chromium
  • SAP MAXDB: Loadercli Export/Import Screenshots
  • SAP MAXDB : Export/Import through Loader utility
  • How to fix MaxDB SDBSETUP issue
  • AZ-120: Planning and Administering Microsoft Azure for SAP Workloads

Recent Comments

  • adil on SAP STANDALONE GATEWAY INSTALLATION & CONFIGURATION
  • Gokul on SAP STANDALONE GATEWAY INSTALLATION & CONFIGURATION
  • Ankur on SAP STANDALONE GATEWAY INSTALLATION & CONFIGURATION
  • Bhagath on ECC 5.0 Homogenous System Copy via SAPinst
  • GOM on RFC error when sending logon data in SM59
January 2021
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« Jun    
Proudly powered by WordPress | Theme: Triad by Cristian Bodnar.