Wednesday, December 24, 2025

.::: create Tools Migration from SQL Server MSSQL to MariaDB using bash shell script :::.

 

correlation with correlation with https://teguhth.blogspot.com/2024/01/install-configure-odbcinstini-odbc-for.html

1. sample data mssql & mariadb

MySQL MariaDB
https://teguhth.blogspot.com/2019/04/study-kasus-praktis-belajar-query-mysql.html

MSSQL
https://teguhth.blogspot.com/2019/04/study-kasus-praktis-belajar-query.html

2. data server A & B 
server A sql server
ip : 10.10.10.7
db : teguhth
schema : dbo
port 1433
user : admin 
password : admin11!!

server B Mariadb
ip : 10.10.10.90
db : teguhthsql
port 3306
user : admin
password : admin

mysql -h 10.10.10.90 -uadmin -p --skip-ssl

buat script shell untuk migrasi dari server A mssql to server B 
 

3. run script migrasi 

sh migrasi_barang_sql_to_maria_with_ignore_log.sh 
sh migrasi_customer_sql_to_maria_with_ignore_log.sh 
sh migrasi_suplier_sql_to_maria_with_ignore_log.sh 
sh migrasi_pasok_sql_to_maria_with_ignore_log.sh 
sh migrasi_pembelian_sql_to_maria_with_ignore_log.sh 

[root@teguhth-all mssql]# pwd
/data/migrasi/mssql
[root@teguhth-all mssql]# ls -l
total 24
drwxr-xr-x 2 root root 4096 Dec 24 14:28 excel
-rw-r--r-- 1 root root 2482 Dec 24 14:00 migrasi_barang_sql_to_maria_with_ignore_log.sh
-rw-r--r-- 1 root root 2982 Dec 24 14:08 migrasi_customer_sql_to_maria_with_ignore_log.sh
-rw-r--r-- 1 root root 3275 Dec 24 14:23 migrasi_pasok_sql_to_maria_with_ignore_log.sh
-rw-r--r-- 1 root root 3377 Dec 24 14:28 migrasi_pembelian_sql_to_maria_with_ignore_log.sh
-rw-r--r-- 1 root root 2820 Dec 24 14:03 migrasi_suplier_sql_to_maria_with_ignore_log.sh
drwxr-xr-x 2 root root  114 Dec 24 14:41 old
[root@teguhth-all mssql]#
 





4. result after migrasi 
 


5. try run with some data existing


delete from pembelian where kode_pembelian='BEL-E007';
delete from pembelian where kode_pembelian='BEL-E010'; 

 



6. script migrasi 

[root@teguhth-all mssql]# pwd
/data/migrasi/mssql
[root@teguhth-all mssql]# cat migrasi_barang_sql_to_maria_with_ignore_log.sh
#!/bin/bash

# CONFIG SQL SERVER (SOURCE)
MSSQL_HOST="10.10.10.7"
MSSQL_PORT="1433"
MSSQL_DB="teguhth"
MSSQL_USER="admin"
MSSQL_PASS='admin11!!'

# CONFIG MARIADB (TARGET)
MYSQL_HOST="10.10.10.90"
MYSQL_PORT="3306"
MYSQL_DB="teguhthsql"
MYSQL_USER="admin"
MYSQL_PASS="admin"

# FILE
WORKDIR="/data/migrasi/mssql/excel"
CSV_FILE="$WORKDIR/barang.csv"
RESULT_FILE="$WORKDIR/result.log"

mkdir -p "$WORKDIR"

echo "== Export SQL Server -> CSV =="

sqlcmd \
  -S ${MSSQL_HOST},${MSSQL_PORT} \
  -U ${MSSQL_USER} \
  -P "${MSSQL_PASS}" \
  -C \
  -d ${MSSQL_DB} \
  -W -s "," -h -1 \
  -Q "SET NOCOUNT ON;
      SELECT
        KODE_BARANG,
        NAMA_BARANG,
        SATUAN_BARANG,
        STOK_BARANG
      FROM dbo.barang;" \
  > "$CSV_FILE"

if [ $? -ne 0 ]; then
  echo "? Export dari SQL Server gagal"
  exit 1
fi

TOTAL_CSV_ROWS=$(wc -l < "$CSV_FILE")

echo
echo "== CSV hasil export =="
echo "--------------------------------"
cat "$CSV_FILE"
echo "--------------------------------"
echo "? Total baris di CSV : $TOTAL_CSV_ROWS"
echo

echo "== Prepare table di MariaDB =="

mariadb -h ${MYSQL_HOST} -P ${MYSQL_PORT} \
  -u ${MYSQL_USER} -p${MYSQL_PASS} \
  --skip-ssl ${MYSQL_DB} <<EOF
CREATE TABLE IF NOT EXISTS barang (
    KODE_BARANG CHAR(6) NOT NULL,
    NAMA_BARANG VARCHAR(25),
    SATUAN_BARANG VARCHAR(20),
    STOK_BARANG DECIMAL(4),
    PRIMARY KEY (KODE_BARANG)
);
TRUNCATE TABLE barang;
EOF

echo
echo "== Import CSV -> MariaDB =="

mariadb -N -s \
  -h ${MYSQL_HOST} -P ${MYSQL_PORT} \
  -u ${MYSQL_USER} -p${MYSQL_PASS} \
  --local-infile=1 \
  --skip-ssl ${MYSQL_DB} <<EOF > "$RESULT_FILE"

LOAD DATA LOCAL INFILE '${CSV_FILE}'
IGNORE INTO TABLE barang
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(
  KODE_BARANG,
  NAMA_BARANG,
  SATUAN_BARANG,
  STOK_BARANG
);

SELECT ROW_COUNT();
SHOW WARNINGS;

EOF

# ===== AMBIL HASIL =====
INSERTED_ROWS=$(head -n 1 "$RESULT_FILE")
IGNORED_ROWS=$((TOTAL_CSV_ROWS - INSERTED_ROWS))

echo
echo "===================================="
echo "?? HASIL MIGRASI BARANG"
echo "===================================="
echo "Total CSV rows     : $TOTAL_CSV_ROWS"
echo "Inserted rows      : $INSERTED_ROWS"
echo "Ignored / skipped  : $IGNORED_ROWS"
echo "===================================="

if [ "$IGNORED_ROWS" -gt 0 ]; then
  echo
  echo "??  WARNING (duplicate / ignored):"
  tail -n +2 "$RESULT_FILE"
fi

echo
echo "? Migrasi barang SQL Server ? MariaDB SELESAI"
echo "===================================="

[root@teguhth-all mssql]#

[root@teguhth-all mssql]# pwd
/data/migrasi/mssql
[root@teguhth-all mssql]# cat migrasi_suplier_sql_to_maria_with_ignore_log.sh
#!/bin/bash

# =============================
# CONFIG SQL SERVER (SOURCE)
# =============================
MSSQL_HOST="10.10.10.7"
MSSQL_PORT="1433"
MSSQL_DB="teguhth"
MSSQL_USER="admin"
MSSQL_PASS='admin11!!'

# =============================
# CONFIG MARIADB (TARGET)
# =============================
MYSQL_HOST="10.10.10.90"
MYSQL_PORT="3306"
MYSQL_DB="teguhthsql"
MYSQL_USER="admin"
MYSQL_PASS="admin"

# =============================
# FILE
# =============================
WORKDIR="/data/migrasi/mssql/excel"
CSV_FILE="$WORKDIR/suplier.csv"
RESULT_FILE="$WORKDIR/result_suplier.log"

mkdir -p "$WORKDIR"

echo "== Export SQL Server -> CSV (SUPLIER) =="

sqlcmd \
  -S ${MSSQL_HOST},${MSSQL_PORT} \
  -U ${MSSQL_USER} \
  -P "${MSSQL_PASS}" \
  -C \
  -d ${MSSQL_DB} \
  -W -s "," -h -1 \
  -Q "SET NOCOUNT ON;
      SELECT
        KODE_SUPLIER,
        NAMA_SUPLIER,
        ALAMAT_SUPLIER,
        KOTA_SUPLIER,
        TELEPON_SUPLIER
      FROM dbo.suplier;" \
  > "$CSV_FILE"

if [ $? -ne 0 ]; then
  echo "? Export dari SQL Server gagal"
  exit 1
fi

TOTAL_CSV_ROWS=$(wc -l < "$CSV_FILE")

echo
echo "== CSV hasil export (SUPLIER) =="
echo "--------------------------------"
cat "$CSV_FILE"
echo "--------------------------------"
echo "? Total baris di CSV : $TOTAL_CSV_ROWS"
echo

echo "== Prepare table SUPLIER di MariaDB =="

mariadb -h ${MYSQL_HOST} -P ${MYSQL_PORT} \
  -u ${MYSQL_USER} -p${MYSQL_PASS} \
  --skip-ssl ${MYSQL_DB} <<EOF

CREATE TABLE IF NOT EXISTS suplier (
    KODE_SUPLIER CHAR(5) NOT NULL,
    NAMA_SUPLIER VARCHAR(30),
    ALAMAT_SUPLIER VARCHAR(30),
    KOTA_SUPLIER VARCHAR(15),
    TELEPON_SUPLIER VARCHAR(15),
    PRIMARY KEY (KODE_SUPLIER)
);
#truncate table suplier;
EOF

echo
echo "== Import CSV -> MariaDB (SUPLIER) =="

mariadb -N -s \
  -h ${MYSQL_HOST} -P ${MYSQL_PORT} \
  -u ${MYSQL_USER} -p${MYSQL_PASS} \
  --local-infile=1 \
  --skip-ssl ${MYSQL_DB} <<EOF > "$RESULT_FILE"

LOAD DATA LOCAL INFILE '${CSV_FILE}'
IGNORE INTO TABLE suplier
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(
  KODE_SUPLIER,
  NAMA_SUPLIER,
  ALAMAT_SUPLIER,
  KOTA_SUPLIER,
  TELEPON_SUPLIER
);

SELECT ROW_COUNT();
SHOW WARNINGS;

EOF

# ===== AMBIL HASIL =====
INSERTED_ROWS=$(head -n 1 "$RESULT_FILE")
IGNORED_ROWS=$((TOTAL_CSV_ROWS - INSERTED_ROWS))

echo
echo "===================================="
echo "?? HASIL MIGRASI SUPLIER"
echo "===================================="
echo "Total CSV rows     : $TOTAL_CSV_ROWS"
echo "Inserted rows      : $INSERTED_ROWS"
echo "Ignored / skipped  : $IGNORED_ROWS"
echo "===================================="

if [ "$IGNORED_ROWS" -gt 0 ]; then
  echo
  echo "??  WARNING (duplicate / ignored):"
  tail -n +2 "$RESULT_FILE"
fi

echo
echo "? Migrasi SUPLIER SQL Server ? MariaDB SELESAI"
echo "===================================="

[root@teguhth-all mssql]#

[root@teguhth-all mssql]# pwd
/data/migrasi/mssql
[root@teguhth-all mssql]# cat migrasi_customer_sql_to_maria_with_ignore_log.sh
#!/bin/bash

# =============================
# CONFIG SQL SERVER (SOURCE)
# =============================
MSSQL_HOST="10.10.10.7"
MSSQL_PORT="1433"
MSSQL_DB="teguhth"
MSSQL_USER="admin"
MSSQL_PASS='admin11!!'

# =============================
# CONFIG MARIADB (TARGET)
# =============================
MYSQL_HOST="10.10.10.90"
MYSQL_PORT="3306"
MYSQL_DB="teguhthsql"
MYSQL_USER="admin"
MYSQL_PASS="admin"
MARIA_TABLE="customer"

# =============================
# FILE
# =============================
WORKDIR="/data/migrasi/mssql/excel"
CSV_FILE="$WORKDIR/customer.csv"
RESULT_FILE="$WORKDIR/result_customer.log"

mkdir -p "$WORKDIR"

echo "== Export SQL Server -> CSV (CUSTOMER) =="

sqlcmd \
  -S ${MSSQL_HOST},${MSSQL_PORT} \
  -U ${MSSQL_USER} \
  -P "${MSSQL_PASS}" \
  -C \
  -d ${MSSQL_DB} \
  -W -s "," -h -1 \
  -Q "SET NOCOUNT ON;
      SELECT
        KODE_CUSTOMER,
        NAMA_CUSTOMER,
        ALAMAT_CUSTOMER,
        KOTA_CUSTOMER,
        TELEPON_CUSTOMER
      FROM dbo.customer;" \
  > "$CSV_FILE"

if [ $? -ne 0 ]; then
  echo "? Export dari SQL Server gagal"
  exit 1
fi

TOTAL_CSV_ROWS=$(wc -l < "$CSV_FILE")

echo
echo "== CSV hasil export (CUSTOMER) =="
echo "--------------------------------"
cat "$CSV_FILE"
echo "--------------------------------"
echo "? Total baris di CSV : $TOTAL_CSV_ROWS"
echo

echo "== Prepare table CUSTOMER di MariaDB =="

mariadb -h ${MYSQL_HOST} -P ${MYSQL_PORT} \
  -u ${MYSQL_USER} -p${MYSQL_PASS} \
  --skip-ssl ${MYSQL_DB} <<EOF

CREATE TABLE IF NOT EXISTS ${MARIA_TABLE} (
    KODE_CUSTOMER CHAR(6) NOT NULL,
    NAMA_CUSTOMER VARCHAR(30),
    ALAMAT_CUSTOMER VARCHAR(30),
    KOTA_CUSTOMER VARCHAR(15),
    TELEPON_CUSTOMER VARCHAR(15),
    PRIMARY KEY (KODE_CUSTOMER)
);

-- UNCOMMENT jika ingin reload full
-- TRUNCATE TABLE ${MARIA_TABLE};

EOF

echo
echo "== Import CSV -> MariaDB (CUSTOMER) =="

mariadb -N -s \
  -h ${MYSQL_HOST} -P ${MYSQL_PORT} \
  -u ${MYSQL_USER} -p${MYSQL_PASS} \
  --local-infile=1 \
  --skip-ssl ${MYSQL_DB} <<EOF > "$RESULT_FILE"

LOAD DATA LOCAL INFILE '${CSV_FILE}'
IGNORE INTO TABLE ${MARIA_TABLE}
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(
  KODE_CUSTOMER,
  NAMA_CUSTOMER,
  ALAMAT_CUSTOMER,
  KOTA_CUSTOMER,
  TELEPON_CUSTOMER
);

SELECT ROW_COUNT();
SHOW WARNINGS;

EOF

# =============================
# HASIL MIGRASI
# =============================
INSERTED_ROWS=$(head -n 1 "$RESULT_FILE")
IGNORED_ROWS=$((TOTAL_CSV_ROWS - INSERTED_ROWS))

echo
echo "===================================="
echo "?? HASIL MIGRASI CUSTOMER"
echo "===================================="
echo "Total CSV rows     : $TOTAL_CSV_ROWS"
echo "Inserted rows      : $INSERTED_ROWS"
echo "Ignored / skipped  : $IGNORED_ROWS"
echo "===================================="

if [ "$IGNORED_ROWS" -gt 0 ]; then
  echo
  echo "?? WARNING (duplicate / ignored):"
  tail -n +2 "$RESULT_FILE"
fi

echo
echo "? Migrasi CUSTOMER SQL Server ? MariaDB SELESAI"
echo "===================================="

[root@teguhth-all mssql]#

[root@teguhth-all mssql]# pwd
/data/migrasi/mssql
[root@teguhth-all mssql]# cat migrasi_pasok_sql_to_maria_with_ignore_log.sh
#!/bin/bash

# =============================
# CONFIG SQL SERVER (SOURCE)
# =============================
MSSQL_HOST="10.10.10.7"
MSSQL_PORT="1433"
MSSQL_DB="teguhth"
MSSQL_USER="admin"
MSSQL_PASS='admin11!!'

# =============================
# CONFIG MARIADB (TARGET)
# =============================
MYSQL_HOST="10.10.10.90"
MYSQL_PORT="3306"
MYSQL_DB="teguhthsql"
MYSQL_USER="admin"
MYSQL_PASS="admin"
MARIA_TABLE="pasok"

# =============================
# FILE
# =============================
WORKDIR="/data/migrasi/mssql/excel"
CSV_FILE="$WORKDIR/pasok.csv"
RESULT_FILE="$WORKDIR/result_pasok.log"

mkdir -p "$WORKDIR"

echo "== Export SQL Server -> CSV (PASOK) =="

sqlcmd \
  -S ${MSSQL_HOST},${MSSQL_PORT} \
  -U ${MSSQL_USER} \
  -P "${MSSQL_PASS}" \
  -C \
  -d ${MSSQL_DB} \
  -W -s "," -h -1 \
  -Q "SET NOCOUNT ON;
      SELECT
        KODE_PASOK,
        KODE_BARANG,
        KODE_SUPLIER,
        CONVERT(VARCHAR(10), TANGGAL_PASOK, 23) AS TANGGAL_PASOK,
        JUMLAH_PASOK
      FROM dbo.pasok;" \
  > "$CSV_FILE"

if [ $? -ne 0 ]; then
  echo "? Export dari SQL Server gagal"
  exit 1
fi

TOTAL_CSV_ROWS=$(wc -l < "$CSV_FILE")

echo
echo "== CSV hasil export (PASOK) =="
echo "--------------------------------"
cat "$CSV_FILE"
echo "--------------------------------"
echo "? Total baris di CSV : $TOTAL_CSV_ROWS"
echo

echo "== Prepare table PASOK di MariaDB =="

mariadb -h ${MYSQL_HOST} -P ${MYSQL_PORT} \
  -u ${MYSQL_USER} -p${MYSQL_PASS} \
  --skip-ssl ${MYSQL_DB} <<EOF

-- Pastikan parent table sudah ada
-- barang(KODE_BARANG) dan suplier(KODE_SUPLIER)

CREATE TABLE IF NOT EXISTS ${MARIA_TABLE} (
    KODE_PASOK CHAR(10) NOT NULL,
    KODE_BARANG CHAR(6) NOT NULL,
    KODE_SUPLIER CHAR(5) NOT NULL,
    TANGGAL_PASOK DATE,
    JUMLAH_PASOK DECIMAL(4),
    PRIMARY KEY (KODE_PASOK, KODE_BARANG, KODE_SUPLIER),
    CONSTRAINT fk_pasok_barang
        FOREIGN KEY (KODE_BARANG) REFERENCES barang(KODE_BARANG),
    CONSTRAINT fk_pasok_suplier
        FOREIGN KEY (KODE_SUPLIER) REFERENCES suplier(KODE_SUPLIER)
);

-- UNCOMMENT jika ingin reload total
-- TRUNCATE TABLE ${MARIA_TABLE};

EOF

echo
echo "== Import CSV -> MariaDB (PASOK) =="

mariadb -N -s \
  -h ${MYSQL_HOST} -P ${MYSQL_PORT} \
  -u ${MYSQL_USER} -p${MYSQL_PASS} \
  --local-infile=1 \
  --skip-ssl ${MYSQL_DB} <<EOF > "$RESULT_FILE"

LOAD DATA LOCAL INFILE '${CSV_FILE}'
IGNORE INTO TABLE ${MARIA_TABLE}
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(
  KODE_PASOK,
  KODE_BARANG,
  KODE_SUPLIER,
  TANGGAL_PASOK,
  JUMLAH_PASOK
);

SELECT ROW_COUNT();
SHOW WARNINGS;

EOF

# =============================
# HASIL MIGRASI
# =============================
INSERTED_ROWS=$(head -n 1 "$RESULT_FILE")
IGNORED_ROWS=$((TOTAL_CSV_ROWS - INSERTED_ROWS))

echo
echo "===================================="
echo "?? HASIL MIGRASI PASOK"
echo "===================================="
echo "Total CSV rows     : $TOTAL_CSV_ROWS"
echo "Inserted rows      : $INSERTED_ROWS"
echo "Ignored / skipped  : $IGNORED_ROWS"
echo "===================================="

if [ "$IGNORED_ROWS" -gt 0 ]; then
  echo
  echo "?? WARNING (duplicate / FK / ignored):"
  tail -n +2 "$RESULT_FILE"
fi

echo
echo "? Migrasi PASOK SQL Server ? MariaDB SELESAI"
echo "===================================="

[root@teguhth-all mssql]#

[root@teguhth-all mssql]# pwd
/data/migrasi/mssql
[root@teguhth-all mssql]# cat migrasi_pembelian_sql_to_maria_with_ignore_log.sh
#!/bin/bash

# =============================
# CONFIG SQL SERVER (SOURCE)
# =============================
MSSQL_HOST="10.10.10.7"
MSSQL_PORT="1433"
MSSQL_DB="teguhth"
MSSQL_USER="admin"
MSSQL_PASS='admin11!!'

# =============================
# CONFIG MARIADB (TARGET)
# =============================
MYSQL_HOST="10.10.10.90"
MYSQL_PORT="3306"
MYSQL_DB="teguhthsql"
MYSQL_USER="admin"
MYSQL_PASS="admin"
MARIA_TABLE="pembelian"

# =============================
# FILE
# =============================
WORKDIR="/data/migrasi/mssql/excel"
CSV_FILE="$WORKDIR/pembelian.csv"
RESULT_FILE="$WORKDIR/result_pembelian.log"

mkdir -p "$WORKDIR"

echo "== Export SQL Server -> CSV (PEMBELIAN) =="

sqlcmd \
  -S ${MSSQL_HOST},${MSSQL_PORT} \
  -U ${MSSQL_USER} \
  -P "${MSSQL_PASS}" \
  -C \
  -d ${MSSQL_DB} \
  -W -s "," -h -1 \
  -Q "SET NOCOUNT ON;
      SELECT
        KODE_PEMBELIAN,
        KODE_BARANG,
        KODE_CUSTOMER,
        CONVERT(VARCHAR(10), TANGGAL_PEMBELIAN, 23) AS TANGGAL_PEMBELIAN,
        JUMLAH_PEMBELIAN
      FROM dbo.pembelian;" \
  > "$CSV_FILE"

if [ $? -ne 0 ]; then
  echo "? Export dari SQL Server gagal"
  exit 1
fi

TOTAL_CSV_ROWS=$(wc -l < "$CSV_FILE")

echo
echo "== CSV hasil export (PEMBELIAN) =="
echo "--------------------------------"
cat "$CSV_FILE"
echo "--------------------------------"
echo "? Total baris di CSV : $TOTAL_CSV_ROWS"
echo

echo "== Prepare table PEMBELIAN di MariaDB =="

mariadb -h ${MYSQL_HOST} -P ${MYSQL_PORT} \
  -u ${MYSQL_USER} -p${MYSQL_PASS} \
  --skip-ssl ${MYSQL_DB} <<EOF

-- Pastikan parent table sudah ada:
-- barang(KODE_BARANG)
-- customer(KODE_CUSTOMER)

CREATE TABLE IF NOT EXISTS ${MARIA_TABLE} (
    KODE_PEMBELIAN CHAR(10) NOT NULL,
    KODE_BARANG CHAR(6) NOT NULL,
    KODE_CUSTOMER CHAR(6) NOT NULL,
    TANGGAL_PEMBELIAN DATE,
    JUMLAH_PEMBELIAN DECIMAL(4),
    PRIMARY KEY (KODE_PEMBELIAN, KODE_BARANG, KODE_CUSTOMER),
    CONSTRAINT fk_pembelian_barang
        FOREIGN KEY (KODE_BARANG) REFERENCES barang(KODE_BARANG),
    CONSTRAINT fk_pembelian_customer
        FOREIGN KEY (KODE_CUSTOMER) REFERENCES customer(KODE_CUSTOMER)
);

-- UNCOMMENT jika ingin reload total
-- TRUNCATE TABLE ${MARIA_TABLE};

EOF

echo
echo "== Import CSV -> MariaDB (PEMBELIAN) =="

mariadb -N -s \
  -h ${MYSQL_HOST} -P ${MYSQL_PORT} \
  -u ${MYSQL_USER} -p${MYSQL_PASS} \
  --local-infile=1 \
  --skip-ssl ${MYSQL_DB} <<EOF > "$RESULT_FILE"

LOAD DATA LOCAL INFILE '${CSV_FILE}'
IGNORE INTO TABLE ${MARIA_TABLE}
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(
  KODE_PEMBELIAN,
  KODE_BARANG,
  KODE_CUSTOMER,
  TANGGAL_PEMBELIAN,
  JUMLAH_PEMBELIAN
);

SELECT ROW_COUNT();
SHOW WARNINGS;

EOF

# =============================
# HASIL MIGRASI
# =============================
INSERTED_ROWS=$(head -n 1 "$RESULT_FILE")
IGNORED_ROWS=$((TOTAL_CSV_ROWS - INSERTED_ROWS))

echo
echo "===================================="
echo "?? HASIL MIGRASI PEMBELIAN"
echo "===================================="
echo "Total CSV rows     : $TOTAL_CSV_ROWS"
echo "Inserted rows      : $INSERTED_ROWS"
echo "Ignored / skipped  : $IGNORED_ROWS"
echo "===================================="

if [ "$IGNORED_ROWS" -gt 0 ]; then
  echo
  echo "?? WARNING (duplicate / FK / ignored):"
  tail -n +2 "$RESULT_FILE"
fi

echo
echo "? Migrasi PEMBELIAN SQL Server ? MariaDB SELESAI"
echo "===================================="

[root@teguhth-all mssql]#

No comments:

Post a Comment

Popular Posts