This is Part 3 of a series on madsql.Part 1 covered split-statements. Part 2 covered infer-schema. This post covers convert — the main migration command. By the time you reach convert in a migration workflow, you’ve already done two things:…
Most enterprises that run an application for many customers, stores, or business units end up in the same spot: one PDB per tenant, and a growing tax every time the application changes. Patches multiply. Reference data drifts. Cross-tenant reporting becomes…
Database migrations are among the most complex initiatives organizations undertake. They involve multiple teams, multiple technologies, competing priorities, operational risk, testing requirements, governance processes, and business-critical applications. Yet despite the complexity, one of the biggest challenges I repeatedly encounter during…
This is Part 2 of a series on madsql. Part 1 covered split-statements. This post covers infer-schema, recovering CREATE TABLE DDL from a SQL workload when your source schema is incomplete or missing. One of the most common situations on…
This is Part 1 of a series on madsql, a deterministic CLI tool for SQL dialect migration. The series covers split-statements, infer-schema, and convert in the order you’d reach for them on a real migration project. The instinct on a…
Exporting data from Oracle databases is a common task that every DBA and developer faces. Whether you’re migrating data, creating backups, or generating reports, having the right export strategy can save you time and headaches. In this post, I’ll walk…
Database design is hard…seriously… If you need to modify a table after you’ve rolled it into production DBMS_REDEFINITION can really save you! Here’s a little example that shows taking a non-partitioned table and adding interval partitioning to it. Enjoy! [code…
Here’s a quick and simple script to help migrate a database over to Automatic Storage Management (ASM). The script implements the Oracle Documentation found here: You can download the script from GitHub here: [code language=”bash”] #!/bin/bash #=============================================================================================================== #…
This is one of those topics that EVERYONE has a different take on and here’s mine! Using the LS_TABLE external table that you can find here you’ll be able to loop through all the files in a directory and load them into…
[sourcecode language=”bash”] #!/bin/bash #=============================================================================================================== # # FILE: quick_diag.sh # # USAGE: run it # # DESCRIPTION: try to diag system # OPTIONS: # REQUIREMENTS: # AUTHOR: Matt D # CREATED: 11.27.2012 # VERSION: 1.0 # EUL : THIS CODE IS…