### Install Migrate DB Package

Source: https://context7.com/thedragoncode/migrate-db/llms.txt

Instructions for installing the Migrate DB package as a development dependency using Composer.

```bash
composer require dragon-code/migrate-db --dev
```

```json
{
    "require-dev": {
        "dragon-code/migrate-db": "^3.0"
    }
}
```

--------------------------------

### Install Migrate DB using Composer

Source: https://github.com/thedragoncode/migrate-db/blob/main/README.md

Installs the Migrate DB package using Composer. This is the recommended method for adding the package to your Laravel project and ensures you have the latest stable version.

```bash
composer require dragon-code/migrate-db --dev
```

--------------------------------

### Basic Database Migration

Source: https://context7.com/thedragoncode/migrate-db/llms.txt

Performs a full database migration, copying all tables and data from a source to a target connection. It handles foreign keys and uses chunked queries for efficiency. Interactive prompts guide the user through options like truncating and dropping tables.

```bash
php artisan db:migrate --schema-from=mysql_old --schema-to=mysql_new
```

--------------------------------

### Configure Migrate DB in composer.json

Source: https://github.com/thedragoncode/migrate-db/blob/main/README.md

Manually add the Migrate DB package to your project's development dependencies by updating the composer.json file. After modification, run 'composer update' to install the package.

```json
{
    "require-dev": {
        "dragon-code/migrate-db": "^3.0"
    }
}
```

--------------------------------

### Perform Cross-Database Migrations (Bash)

Source: https://context7.com/thedragoncode/migrate-db/llms.txt

Execute database migrations between different systems such as MySQL, PostgreSQL, and SQL Server using Artisan commands. This functionality automatically handles data type conversions and constraint differences.

```bash
# MySQL to PostgreSQL migration
php artisan db:migrate --schema-from=mysql --schema-to=pgsql

# PostgreSQL to MySQL migration
php artisan db:migrate --schema-from=pgsql --schema-to=mysql

# MySQL to SQL Server migration
php artisan db:migrate --schema-from=mysql --schema-to=sqlsrv

# Example connection setup for cross-database migration in config/database.php:
# 'connections' => [
#     'mysql' => [
#         'driver' => 'mysql',
#         'host' => '127.0.0.1',
#         'database' => 'source_db',
#         'username' => 'mysql_user',
#         'password' => 'mysql_pass',
#     ],
#     'pgsql' => [
#         'driver' => 'pgsql',
#         'host' => '127.0.0.1',
#         'database' => 'target_db',
#         'username' => 'postgres_user',
#         'password' => 'postgres_pass',
#     ],
# ]
```

--------------------------------

### Programmatic Database Builder Access (PHP)

Source: https://context7.com/thedragoncode/migrate-db/llms.txt

Utilize the BuilderManager facade to programmatically interact with database builders for custom migration tasks. This allows for fine-grained control over database operations, including fetching tables, managing constraints, and executing custom data transfer logic.

```php
<?php

use DragonCode\MigrateDB\Facades\BuilderManager;
use DragonCode\MigrateDB\Constants\Drivers;

// Get a builder instance for a specific connection
$builder = BuilderManager::of('mysql')->get();

// Get all tables from the connection (excludes 'migrations' table)
$tables = $builder->getAllTables();
// Returns: ['users', 'orders', 'products', ...]

// Get the primary key column for a specific table
$primaryKey = $builder->getPrimaryKey('users');
// Returns: 'id'

// Drop all tables in the database
$builder->dropAllTables();

// Disable foreign key constraints (useful before bulk operations)
$builder->disableForeign();

// Enable foreign key constraints
$builder->enableForeign();

// Access the underlying Laravel schema builder
$schemaBuilder = $builder->schema();
$columns = $schemaBuilder->getColumnListing('users');
// Returns: ['id', 'name', 'email', 'password', 'created_at', 'updated_at']

// Example: Custom migration with progress tracking
$sourceBuilder = BuilderManager::of('mysql_old')->get();
$targetBuilder = BuilderManager::of('mysql_new')->get();

$targetBuilder->disableForeign();

foreach ($sourceBuilder->getAllTables() as $table) {
    $primaryKey = $sourceBuilder->getPrimaryKey($table);

    DB::connection('mysql_old')
        ->table($table)
        ->orderBy($primaryKey)
        ->chunk(1000, function ($records) use ($table) {
            DB::connection('mysql_new')
                ->table($table)
                ->insert($records->toArray());
        });

    echo "Migrated table: {$table}\n";
}

$targetBuilder->enableForeign();

```

--------------------------------

### Run Database Migration with Migrate DB

Source: https://github.com/thedragoncode/migrate-db/blob/main/README.md

Executes the database migration process using the Migrate DB Artisan command. This command transfers data between two specified database connections.

```bash
php artisan db:migrate --schema-from=foo --schema-to=bar
```

--------------------------------

### Database Driver Constants Reference (PHP)

Source: https://context7.com/thedragoncode/migrate-db/llms.txt

Provides constants for supported database drivers, enabling programmatic checks and conditional logic for different database types. This ensures compatibility and allows for flexible handling of various database systems within your application.

```php
<?php

use DragonCode\MigrateDB\Constants\Drivers;

// Available database drivers
$mysql = Drivers::MYSQL;      // 'mysql'
$postgres = Drivers::POSTGRES; // 'pgsql'
$sqlServer = Drivers::SQL_SERVER; // 'sqlsrv'

// Example: Conditionally handle different database types
$driver = config('database.connections.mydb.driver');

switch ($driver) {
    case Drivers::MYSQL:
        // MySQL-specific logic
        break;
    case Drivers::POSTGRES:
        // PostgreSQL-specific logic
        break;
    case Drivers::SQL_SERVER:
        // SQL Server-specific logic
        break;
}

```

--------------------------------

### Migrate Specific Tables

Source: https://context7.com/thedragoncode/migrate-db/llms.txt

Migrates only specified tables from the source to the target database connection. Use the --tables option multiple times for each table. This is useful for partial migrations or testing.

```bash
php artisan db:migrate --schema-from=mysql_old --schema-to=mysql_new --tables=users --tables=orders
```

```bash
php artisan db:migrate --schema-from=mysql_old --schema-to=mysql_new --tables=products
```

```bash
php artisan db:migrate --schema-from=mysql --schema-to=pgsql --tables=users --tables=profiles --tables=settings
```

--------------------------------

### Bash: Migrate DB with UUID/ULID Primary Keys

Source: https://context7.com/thedragoncode/migrate-db/llms.txt

This bash command utilizes the Migrate DB package to perform a database migration, specifically highlighting its capability to handle tables with UUID or ULID primary keys. It ensures correct data transfer and ordering.

```bash
# UUID/ULID tables are automatically detected and transferred correctly
php artisan db:migrate --schema-from=mysql_old --schema-to=pgsql_new

# The command handles string-based primary keys properly:
# - Maintains original UUID/ULID values
# - Orders by primary key for consistent chunked transfer
# - Works across different database systems

```

--------------------------------

### Manage Laravel Migrations During Data Transfer (Bash)

Source: https://context7.com/thedragoncode/migrate-db/llms.txt

Control the execution of Laravel migrations on the target or source database during the data transfer process. This ensures schema consistency by allowing migrations to run before, during, or after data transfer, or to be skipped entirely.

```bash
# Run the migration command
php artisan db:migrate --schema-from=mysql_old --schema-to=mysql_new

# When prompted "Please choose option to run migration on which connection?":
# - Select "target" to run migrations on the target database first
# - Select "source" to run migrations on the source database
# - Select "none" to skip running migrations

# Alternatively, run migrations manually before the data transfer:
php artisan migrate --database=mysql_new

# Then run the data transfer without running migrations again:
php artisan db:migrate --schema-from=mysql_old --schema-to=mysql_new
# Select "none" when prompted about migrations

```

--------------------------------

### Migrate Specific Tables with Migrate DB

Source: https://github.com/thedragoncode/migrate-db/blob/main/README.md

Migrates only the specified tables between two database connections using the Migrate DB Artisan command. This allows for selective data transfer.

```bash
php artisan db:migrate --schema-from=foo --schema-to=bar --tables=table1 --tables=table2
```

--------------------------------

### PHP: Create Tables with UUID Primary Key

Source: https://context7.com/thedragoncode/migrate-db/llms.txt

This PHP code snippet demonstrates how to define a table with a UUID primary key using Laravel's migration system. It sets up a 'documents' table with an 'id' column of type UUID.

```php
<?php

// Example migration with UUID primary key
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    public function up()
    {
        Schema::create('documents', function (Blueprint $table) {
            $table->uuid('id')->primary();
            $table->string('title');
            $table->text('content');
            $table->timestamps();
        });
    }
};

```

--------------------------------

### Exclude Tables from Migration with Migrate DB

Source: https://github.com/thedragoncode/migrate-db/blob/main/README.md

Performs a database migration while excluding specific tables from the process. This is useful when you want to transfer most of the data but keep certain tables untouched.

```bash
php artisan db:migrate --schema-from=foo --schema-to=bar --exclude=table1 --exclude=table2
```

--------------------------------

### PHP: Create Tables with ULID Primary Key

Source: https://context7.com/thedragoncode/migrate-db/llms.txt

This PHP code snippet shows how to define a table with a ULID primary key using Laravel's migration system (available from Laravel 9.30+). It sets up an 'events' table with an 'id' column of type ULID.

```php
// Example migration with ULID primary key (Laravel 9.30+)
return new class extends Migration
{
    public function up()
    {
        Schema::create('events', function (Blueprint $table) {
            $table->ulid('id')->primary();
            $table->string('name');
            $table->timestamp('occurred_at');
            $table->timestamps();
        });
    }
};

```

--------------------------------

### Exclude Tables from Migration

Source: https://context7.com/thedragoncode/migrate-db/llms.txt

Migrates all tables except those specified using the --exclude option. This is useful for skipping large or temporary tables like logs or cache tables.

```bash
php artisan db:migrate --schema-from=mysql_old --schema-to=mysql_new --exclude=logs --exclude=sessions
```

```bash
php artisan db:migrate --schema-from=mysql_old --schema-to=mysql_new \
    --exclude=cache \
    --exclude=jobs \
    --exclude=failed_jobs \
    --exclude=password_resets
```

```bash
php artisan db:migrate --schema-from=production --schema-to=staging \
    --exclude=audit_logs \
    --exclude=activity_log \
    --exclude=telescope_entries
```

=== COMPLETE CONTENT === This response contains all available snippets from this library. No additional content exists. Do not make further requests.