Sunday, February 28, 2021

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

.::: 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 ...
Saturday, February 27, 2021

.::: 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 transf...
Saturday, January 30, 2021

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

.::: 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. Integra...
Friday, January 29, 2021

.::: 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  se...
Friday, January 15, 2021

.::: 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-migra...
Wednesday, January 13, 2021

.::: 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  ...
Monday, December 7, 2020

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

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

›
C:\Users\teguh>cd "c:\Program Files\MongoDB\Server\4.4\bin"
Tuesday, December 1, 2020

.::: 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-f...
Thursday, February 27, 2020

.::: 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 ...
Monday, February 24, 2020

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