.::: How To Add Column, Update, Insert & Delete row table on SQL example MariaDB :::.

1. Check original table Barang

2. Add Column table Barang (add KETERANGAN)

3. update row table ( update/fill column keterangan)

4. delete row table (example delete KODE_BARANG='ELK-99')

5. Modify Column table ( example change ELK02-ket to ELK02-ketvv2)

6. drop column on table (example delete/drop column KETERANGAN)

1. Check original table Barang

syntax

mysql -u root -p

show tables;

desc barang;

select * from barang;

.::: Migration Oracle to MSSQL using SQLines Data Migration :::.

A. Prepare software migration
1. Download SQLines Data & extract 
http://www.sqlines.com/download
SQLines Data is a tool for data transfer, schema conversion and data migration validation/testing.
Note:
SQLines Data tool does not convert views, stored procedures, functions, and triggers, use SQLines SQL Converter to convert them.

2. Download SQLines SQL Converter (Optional)
SQLines SQL Converter
SQLines SQL Converter helps you convert database schema (DDL), queries and DML statements, views, stored procedures, packages, functions and triggers.

.::: Migration MariaDB/MySQL to MSSQL using SQLines Data Migration :::.

A. Prepare software migration

1. Download SQLines Data & extract 

http://www.sqlines.com/download

SQLines Data is a tool for data transfer, schema conversion and data migration validation/testing.

Note:

SQLines Data tool does not convert views, stored procedures, functions, and triggers, use SQLines SQL Converter to convert them.

.::: Migration MariaDB/MySQL to Oracle using SQLines Data Migration :::.

A. Prepare software migration
1. Download SQLines Data & extract 
http://www.sqlines.com/download
SQLines Data is a tool for data transfer, schema conversion and data migration validation/testing.
Note:
SQLines Data tool does not convert views, stored procedures, functions, and triggers, use SQLines SQL Converter to convert them.

2. Download SQLines SQL Converter (Optional)
SQLines SQL Converter
SQLines SQL Converter helps you convert database schema (DDL), queries and DML statements, views, stored procedures, packages, functions and triggers.

.::: Migration SQL Server (MSSQL) to Oracle using SQLines Data Migration :::.

A. Prepare software migration

1. Download SQLines Data & extract 

http://www.sqlines.com/download

SQLines Data is a tool for data transfer, schema conversion and data migration validation/testing.

Note:

SQLines Data tool does not convert views, stored procedures, functions, and triggers, use SQLines SQL Converter to convert them.

2. Download SQLines SQL Converter (Optional)

SQLines SQL Converter

SQLines SQL Converter helps you convert database schema (DDL), queries and DML statements, views, stored procedures, packages, functions and triggers.

.::: Migration SQL Server (MSSQL) to MariaDB/MySQL using SQLines Data Migration :::.

  

A. Prepare software migration

1. Download SQLines Data & extract 

http://www.sqlines.com/download

SQLines Data is a tool for data transfer, schema conversion and data migration validation/testing.

Note:

SQLines Data tool does not convert views, stored procedures, functions, and triggers, use SQLines SQL Converter to convert them.

2. Download SQLines SQL Converter (Optional)

SQLines SQL Converter

SQLines SQL Converter helps you convert database schema (DDL), queries and DML statements, views, stored procedures, packages, functions and triggers.

3. Extract SQLlines Data

.::: Migration MariaDB / MySQL to Oracle Using SQL Developer and Metode Copy to Oracle (Only Table) :::.

A. Pre Upgrade
1. Download SQL Developer & Extract
2. To connect to third-party database (MySQL, Microsoft SQL Server, Sybase Adaptive Server,  Microsoft Access, IBM DB2) using SQL Developer, we need jTDS driver. You can download needed jTDS driver from following link. http://sourceforge.net/projects/jtds/files/jtds/1.2/jtds-1.2-dist.zip/download  . Extract the dowloaded zip file named jtds-1.2-dist.zip

.::: Migration SQL Server to Oracle Using SQL Developer and Metode Copy to Oracle (Only Table) :::.

A. Pre Upgrade

1. Download SQL Developer & Extract

2. To connect to third-party database (MySQL, Microsoft SQL Server, Sybase Adaptive Server,  Microsoft Access, IBM DB2) using SQL Developer, we need jTDS driver. You can download needed jTDS driver from following link. http://sourceforge.net/projects/jtds/files/jtds/1.2/jtds-1.2-dist.zip/download  . 

Extract the dowloaded zip file named jtds-1.2-dist.zip

3. Click “Tools” and then “Prefenrences”.

.::: Migration SQL Server to Oracle Using SQL Developer with Migration Metode :::.

A. Pre Upgrade

1. Download SQL Developer & Extract

2. To connect to third-party database (MySQL, Microsoft SQL Server, Sybase Adaptive Server,  Microsoft Access, IBM DB2) using SQL Developer, we need jTDS driver. You can download needed jTDS driver from following link. http://sourceforge.net/projects/jtds/files/jtds/1.2/jtds-1.2-dist.zip/download  . 

Extract the dowloaded zip file named jtds-1.2-dist.zip

3. Click “Tools” and then “Prefenrences”.

.::: Migration Oracle to MariaDB/MySQL using SQLines Data Migration :::.

A. Prepare software migration
1. Download SQLines Data & extract 
http://www.sqlines.com/download
SQLines Data is a tool for data transfer, schema conversion and data migration validation/testing.
Note:
SQLines Data tool does not convert views, stored procedures, functions, and triggers, use SQLines SQL Converter to convert them.

2. Download SQLines SQL Converter (Optional)
SQLines SQL Converter
SQLines SQL Converter helps you convert database schema (DDL), queries and DML statements, views, stored procedures, packages, functions and triggers.

.::: Migration Oracle Database to Microsoft SQL Server (MSSQL) using SSMA for Oracle :::.

A. Pre Migration

1. Download & Install SQL Server Migration Assistant for Oracle 

https://docs.microsoft.com/id-id/sql/ssma/oracle/installing-ssma-for-oracle-client-oracletosql?view=sql-server-2017

SSMAforOracle_8.16.0.msi

SSMAforOracleExtensionPack_8.16.0.msi

.::: Configure Microsoft Distributed Transaction Coordinator (MSDTC). Trouble shoot Failed to restart the MS DTC Service :::.

Modules such as the Web Portal, the iOS app, and any custom built API rely on Integration Services to communicate with the database. Integration Services enables access so these programs can authenticate, read, and update information in your Perspective database.

Integration Services is based on Microsoft Distributed Transaction Coordinator (MSDTC). The MSDTC service is a component of modern versions of Microsoft Windows that are responsible for coordinating transactions that span multiple resource managers, such as databases, message queues, and file systems.

MSDTC needs to be configured only if your database and the Perspective application reside on separate servers. 

Configure MSDTC

1. From Start, search for dcomcnfg and press Enter on your keyboard.

.::: Migration Microsoft SQL Server to MariaDB/MySQL using MySQL WorkBench :::.

 

A. Pree

1. capture mysql for destination/Target

  show databases

 

2. capture MSSQL for source

select * from sys.databases
use teguhth 
select * from INFORMATION_SCHEMA.TABLES
exec sp_columns barang
select * from barang