.::: 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

.::: Migration MySQL/MariaDB to Microsoft SQL Server (MSSQL) :::.

Pre Migration

1. Download & Install SQL Server Migration Assistant for MySQL 

https://docs.microsoft.com/id-id/sql/ssma/sql-server-migration-assistant?view=sql-server-2017

2. Download Driver Connector ODCB ( version 5.2 - 5.3.3) & Install 

https://dev.mysql.com/downloads/connector/odbc/

3. Optional Backup Database MySQL/MariaDB

.::: Check Table Capacity & Size Report SQL Server on LocalServer & Linked Server (Open Query) :::.

A. Access Local Server
1. Check Database_ID
select @@Servername as LocalServer,@@servername as ServerName_Link, name as dbname,database_id  from sys.databases
select @@Servername as LocalServer,@@servername as ServerName_Link, name as dbname,database_id  from sys.databases where name = 'teguhth';

.::: Study Kasus Praktis belajar Query create & insert table/Collection MongoDB (Data Warehouse) :::.

1. Create Database teguhth
use teguhth
show dbs 

log 
> use teguhth
switched to db teguhth
> show dbs
admin   0.000GB
brgxxx  0.000GB
config  0.000GB
kampus  0.000GB
local   0.000GB
toko    0.000GB
>

.::: Tutorial MongoDB, create Database & Collection (table) nosql :::.

C:\Users\teguh>cd "c:\Program Files\MongoDB\Server\4.4\bin"

.::: Database size & Table Capacity in MySQL MariaDB :::.

https://teguhth.blogspot.com/2020/12/database-size-table-capacity-in-mysql.html
http://teguhth.blogspot.com/2022/08/create-store-procedure-for-database.html
https://teguhth.blogspot.com/2022/08/create-event-scheduler-to-run-query.htm

A. Create database nms tools ;

create database teguhthtools;
use teguhthtools;

MariaDB [(none)]> use teguhthtools;
Database changed
MariaDB [teguhthtools]>

B. table Database size capacity

1. query database size capacity
 

.::: Steps for Installing SQL Server AlwaysOn Availability Groups :::.

SQL Server 2012's new features and enhancements include Always On SQL Server Failover Cluster Instances and Availability Groups which provides a set of options to improve database availability, Contained Databases which simplify the moving of databases between instances, new and modified Dynamic Management Views and Functions, programmability enhancements including new spatial features, metadata discovery, sequence objects and the THROW statement, performance enhancements such as ColumnStore Indexes as well as improvements to OnLine and partition level operations and security enhancements including provisioning during setup, new permissions, improved role management, and default schema assignment for groups.

.::: How to remove and add replica, database, listener on AlwaysOn MSSQL Server :::.

SQL Server 2012's new features and enhancements include Always On SQL Server Failover Cluster Instances and Availability Groups which provides a set of options to improve database availability, Contained Databases which simplify the moving of databases between instances, new and modified Dynamic Management Views and Functions, programmability enhancements including new spatial features, metadata discovery, sequence objects and the THROW statement, performance enhancements such as ColumnStore Indexes as well as improvements to OnLine and partition level operations and security enhancements including provisioning during setup, new permissions, improved role management, and default schema assignment for groups.

1. Avaibility Databases
Remove >>Availability Databases >> Remove Database From Availability Group

.::: Sript multiple dig domain (DNS) using Script :::.

1. Sample host
[root@server-teguht teguht]# cat hostdomain.txt
www.example.com
example.com
a.example.com
aaa.example.com
aaaa.example.com
example.com
info.example.com
cname.example.com
examplealias.example.com
[root@server-teguht teguht]#

.::: Study Kasus Praktis belajar Query create & insert table Postgress SQL (Create Data Warehouse) include via CLI & GUI :::.

1. Create database using query or GUI

CREATE DATABASE tgh

WITH

OWNER = postgres

ENCODING = 'UTF8'

LC_COLLATE = 'English_United States.1252'

LY_TYPE = 'English_United States.1252'

TABLE_SPACE = pg_default

CONNECT LIMIT = -1 ;

GRANT CREATE, CONNECT ON DATABASE tgh TO postgres;

GRANT TEMPORARY ON DATABASE tgh TO postgres WITH GRANT OPTION;

GRANT TEMPORARY, CONNECT ON DATABASE tgh TO PUBLIC ;

.::: How To Install Cursor and PowerAdmin for powerDNS :::.

after install powerdns as http://teguhth.blogspot.com/2019/08/how-to-install-powerdns-and-poweradmin.html now install poweradmin

1. Installing PowerAdmin to Manage PowerDNS
[root@powerdns-teguht ~]# yum -y install httpd php php-devel php-gd php-imap php-ldap php-mysql php-odbc php-pear php-xml php-xmlrpc php-mbstring php-mcrypt php-mhash gettext

2. Install additonal package
[root@powerdns-teguht ~]# yum -y install php-pear-DB php-pear-MDB2-Driver-mysqli