Easy data transfer from one database to another

The Dragon Code

Last update: Dec 7, 2022

Related tags

Database mysql database migrations migration mssql pgsql migration-tool

Overview

Migrate DB

Easy data transfer from one database to another

Installation

To get the latest version of Migrate DB, simply require the project using Composer:

$ composer require dragon-code/migrate-db --dev

Or manually update require-dev block of composer.json and run composer update.

{
    "require-dev": {
        "dragon-code/migrate-db": "^2.0"
    }
}

Upgrade from `andrey-helldar/migrate-db`

In your composer.json file, replace "andrey-helldar/migrate-db": "^1.0" with "dragon-code/migrate-db": "^2.0".
Run the command composer update.
Profit!

Compatibility

Service	Versions
PHP	^7.3, ^8.0
Laravel	^8.0
Databases	MySQL 5.7+, PostgreSQL 9.5+, MSSQL

Using

Create a new database and set up both connections in the connections section of the config/database.php file, then run the db:migrate console command passing two parameters:

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

where:

foo - Source connection name
bar - Target connection name

The command will perform all migrations on the source and destination databases and transfer all records from the old to the new one.

Enjoy 😊

License

This package is licensed under the MIT License.

Comments

Added New Options
Added New options and interactive input options while migrating databases.

Added option to choose whether truncate table or append to existing tables from last migration in case if transfer is interrupted between migration on large database.

tables - This option will migrate only specified tables exclude-tables - This option will exclude specified tables from migrations
opened by Jagdish-J-P 22
Error: The "--schema-from" option does not accept a value.
Migrate DB Version: 1.0.1

PHP Version: 7.4.16

Laravel/Lumen Framework Version: 8.32.1

Description:

Hey, I'm getting the error 'The "--schema-from" option does not accept a value' when trying to run the command provided in the readme. It happens for both the schema-from and schema-to options with any value. I took a look at the source code, and I think it happens because the command signature is missing '=' after the option names, which controls whether the option accepts values or not.

protected $signature = 'db:migrate' . ' {--schema-from : Source connection name}' . ' {--schema-to : Target connection name}';

I have added the equals signs after the option names locally and confirmed the command works fine after that. It looks like this

protected $signature = 'db:migrate' . ' {--schema-from= : Source connection name}' . ' {--schema-to= : Target connection name}';

Would you be interested in a pull request with this fix?

Steps To Reproduce:

Install the package and run the command provided in the readme.
bug
opened by hrslkvc 4
Command only insert data and not create migrations
Migrade DB Version: 1.2.0

PHP Version: 7.4.22

Laravel/Lumen Framework Version: 8.54.0

Database Driver & Version: PostgreSQL 13.2 and MariaDB 10.5.11

Description:

Command doesn't create migration for table. In code it only transfer data from one database to another. For example in my case from PostgreSQL to MariaDB. But MariaDB has empty DB and I thought it must create migration and then insert all data from PostgreSQL, but this command only insert data and that's all. It doesn't make sense..

Steps To Reproduce:

Execution result:

Show result

// paste result here
opened by RomanNebesnuyGC 3
Bump TheDragonCode/codestyler from 2.6.1 to 2.6.2
Bumps TheDragonCode/codestyler from 2.6.1 to 2.6.2.

Release notes

Sourced from TheDragonCode/codestyler's releases.

v2.6.2

What's Changed

Removed hard time reference when scanning dependencies by @andrey-helldar in TheDragonCode/codestyler#94

Full Changelog: https://github.com/TheDragonCode/codestyler/compare/v2.6.1...v2.6.2

Commits

dbbdac5 Merge pull request #94 from TheDragonCode/2.x

1918809 Removed hard time reference when scanning dependencies

See full diff in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Dependabot will merge this PR once CI passes on it, as requested by @andrey-helldar.

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

@dependabot rebase will rebase this PR

@dependabot recreate will recreate this PR, overwriting any edits that have been made to it

@dependabot merge will merge this PR after your CI passes on it

@dependabot squash and merge will squash and merge this PR after your CI passes on it

@dependabot cancel merge will cancel a previously requested merge and block automerging

@dependabot reopen will reopen this PR if it is closed

@dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually

@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

dependencies
opened by dependabot[bot] 1
Bump TheDragonCode/codestyler from 2.3.2 to 2.6.1
Bumps TheDragonCode/codestyler from 2.3.2 to 2.6.1.

Release notes

Sourced from TheDragonCode/codestyler's releases.

v2.6.1

What's Changed

Fixed bug with applying risky changes by @andrey-helldar in TheDragonCode/codestyler#93

Full Changelog: https://github.com/TheDragonCode/codestyler/compare/v2.6.0...v2.6.1

v2.6.0

What's Changed

The bootstrap folder added to exclusions by @andrey-helldar in TheDragonCode/codestyler#92

Full Changelog: https://github.com/TheDragonCode/codestyler/compare/v2.5.0...v2.6.0

v2.5.0

What's Changed

Added --risky option by @andrey-helldar in TheDragonCode/codestyler#90

Improved rules by @andrey-helldar in TheDragonCode/codestyler#91

Full Changelog: https://github.com/TheDragonCode/codestyler/compare/v2.4.0...v2.5.0

v2.4.0

What's Changed

Update codestyle rules by @andrey-helldar in TheDragonCode/codestyler#89

Full Changelog: https://github.com/TheDragonCode/codestyler/compare/v2.3.2...v2.4.0

Commits

1c4d20e Merge pull request #93 from TheDragonCode/2.x

769521d Fixed bug with applying risky changes

2e58175 The bootstrap folder added to exclusions

f11facb Update code-style 💻

a1cb00c Merge pull request #92 from TheDragonCode/2.x

72da981 Update code-style 💻

7841a31 Improved rules

9671b7b Merge pull request #91 from TheDragonCode/2.x

2798178 Update code-style 💻

68c2d71 Added --risky option

Additional commits viewable in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Dependabot will merge this PR once CI passes on it, as requested by @andrey-helldar.

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

@dependabot rebase will rebase this PR

@dependabot recreate will recreate this PR, overwriting any edits that have been made to it

@dependabot merge will merge this PR after your CI passes on it

@dependabot squash and merge will squash and merge this PR after your CI passes on it

@dependabot cancel merge will cancel a previously requested merge and block automerging

@dependabot reopen will reopen this PR if it is closed

@dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually

@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

dependencies
opened by dependabot[bot] 1
Bump TheDragonCode/codestyler from 2.3.1 to 2.3.2
Bumps TheDragonCode/codestyler from 2.3.1 to 2.3.2.

Release notes

Sourced from TheDragonCode/codestyler's releases.

v2.3.2

Full Changelog: https://github.com/TheDragonCode/codestyler/compare/v2.3.1...v2.3.2

Commits

a7637ae Fixed codestyle for json

a37b94b Update FUNDING.yml

f50e288 Merge pull request #87 from TheDragonCode/dependabot/github_actions/TheDragon...

eb3790a Bump TheDragonCode/codestyler from 2.3.0 to 2.3.1

See full diff in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Dependabot will merge this PR once CI passes on it, as requested by @andrey-helldar.

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

@dependabot rebase will rebase this PR

@dependabot recreate will recreate this PR, overwriting any edits that have been made to it

@dependabot merge will merge this PR after your CI passes on it

@dependabot squash and merge will squash and merge this PR after your CI passes on it

@dependabot cancel merge will cancel a previously requested merge and block automerging

@dependabot reopen will reopen this PR if it is closed

@dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually

@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

dependencies
opened by dependabot[bot] 1
Bump TheDragonCode/codestyler from 2.3.0 to 2.3.1
Bumps TheDragonCode/codestyler from 2.3.0 to 2.3.1.

Release notes

Sourced from TheDragonCode/codestyler's releases.

v2.3.1

What's Changed

Updated .editorconfig file

Full Changelog: https://github.com/TheDragonCode/codestyler/compare/v2.3.0...v2.3.1

Commits

df6e5cf Update .editorconfig

f5455f2 Merge pull request #86 from TheDragonCode/dependabot/github_actions/TheDragon...

3606716 Bump TheDragonCode/codestyler from 2.2.0 to 2.3.0

See full diff in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Dependabot will merge this PR once CI passes on it, as requested by @andrey-helldar.

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

@dependabot rebase will rebase this PR

@dependabot recreate will recreate this PR, overwriting any edits that have been made to it

@dependabot merge will merge this PR after your CI passes on it

@dependabot squash and merge will squash and merge this PR after your CI passes on it

@dependabot cancel merge will cancel a previously requested merge and block automerging

@dependabot reopen will reopen this PR if it is closed

@dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually

@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

dependencies
opened by dependabot[bot] 1
Bump TheDragonCode/codestyler from 2.2.0 to 2.3.0
Bumps TheDragonCode/codestyler from 2.2.0 to 2.3.0.

Release notes

Sourced from TheDragonCode/codestyler's releases.

v2.3.0

What's Changed

Update .editorconfig by @andrey-helldar

Full Changelog: https://github.com/TheDragonCode/codestyler/compare/v2.2.0...v2.3.0

Commits

c9d730c Merge pull request #85 from TheDragonCode/2.x

4cf3e97 Update GitHub Actions rules

417776f Update .editorconfig 📖

564cf7c Update .editorconfig

866f47b Updated permissions to run plugins 🦾

c4f6382 Merge pull request #84 from TheDragonCode/dependabot/github_actions/TheDragon...

2dcfe4e Update Dependabot 🤖

f4f0e3f Bump TheDragonCode/codestyler from 2.1.0 to 2.2.0

3251184 Update dependabot.yml

See full diff in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Dependabot will merge this PR once CI passes on it, as requested by @andrey-helldar.

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

@dependabot rebase will rebase this PR

@dependabot recreate will recreate this PR, overwriting any edits that have been made to it

@dependabot merge will merge this PR after your CI passes on it

@dependabot squash and merge will squash and merge this PR after your CI passes on it

@dependabot cancel merge will cancel a previously requested merge and block automerging

@dependabot reopen will reopen this PR if it is closed

@dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually

@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

dependencies
opened by dependabot[bot] 1
Bump TheDragonCode/codestyler from 2.1.0 to 2.2.0
Bumps TheDragonCode/codestyler from 2.1.0 to 2.2.0.

Release notes

Sourced from TheDragonCode/codestyler's releases.

v2.2.0

What's Changed

Added filling in permission keys to launch plugins by @andrey-helldar in TheDragonCode/codestyler#83

Full Changelog: https://github.com/TheDragonCode/codestyler/compare/v2.1.0...v2.2.0

Commits

915fb64 Merge pull request #83 from TheDragonCode/2.x

1890ed0 Merge remote-tracking branch 'origin/main' into 2.x

b915798 Merge remote-tracking branch 'origin/2.x' into 2.x

bb2b0de Added filling in permission keys to launch plugins

cb7479e Merge pull request #81 from TheDragonCode/dependabot/github_actions/TheDragon...

e17d6a4 Bump TheDragonCode/codestyler from 2.0.3 to 2.1.0

See full diff in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Dependabot will merge this PR once CI passes on it, as requested by @andrey-helldar.

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

@dependabot rebase will rebase this PR

@dependabot recreate will recreate this PR, overwriting any edits that have been made to it

@dependabot merge will merge this PR after your CI passes on it

@dependabot squash and merge will squash and merge this PR after your CI passes on it

@dependabot cancel merge will cancel a previously requested merge and block automerging

@dependabot reopen will reopen this PR if it is closed

@dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually

@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

dependencies
opened by dependabot[bot] 1
Bump TheDragonCode/codestyler from 2.0.3 to 2.1.0
Bumps TheDragonCode/codestyler from 2.0.3 to 2.1.0.

Release notes

Sourced from TheDragonCode/codestyler's releases.

v2.1.0

Full Changelog: https://github.com/TheDragonCode/codestyler/compare/v2.0.3...v2.1.0

Commits

f6c80ee Merge pull request #80 from TheDragonCode/2.x

611fdc2 Added message about missing composer.json file

20d88d1 Merge pull request #79 from TheDragonCode/main

32d6fd1 Normalize composer.json 👀

1cf3bd3 Update code-style 💻

4b45964 Fixed PHP versions compare and added version tests

894274b Removed symfony 5.x components

501fb61 Merge pull request #78 from TheDragonCode/dependabot/github_actions/TheDragon...

4eca6eb Bump TheDragonCode/codestyler from 2.0.1 to 2.0.3

See full diff in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Dependabot will merge this PR once CI passes on it, as requested by @andrey-helldar.

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

@dependabot rebase will rebase this PR

@dependabot recreate will recreate this PR, overwriting any edits that have been made to it

@dependabot merge will merge this PR after your CI passes on it

@dependabot squash and merge will squash and merge this PR after your CI passes on it

@dependabot cancel merge will cancel a previously requested merge and block automerging

@dependabot reopen will reopen this PR if it is closed

@dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually

@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

dependencies
opened by dependabot[bot] 1
Bump TheDragonCode/codestyler from 2.0.1 to 2.0.3
Bumps TheDragonCode/codestyler from 2.0.1 to 2.0.3.

Release notes

Sourced from TheDragonCode/codestyler's releases.

v2.0.3

Full Changelog: https://github.com/TheDragonCode/codestyler/compare/v2.0.2...v2.0.3

v2.0.2

Full Changelog: https://github.com/TheDragonCode/codestyler/compare/v2.0.1...v2.0.2

Commits

a551188 Update config.sh

63ec3c7 Update config.sh

3ecc665 Merge pull request #77 from TheDragonCode/dependabot/github_actions/TheDragon...

a0ae34e Bump TheDragonCode/codestyler from 2.0.0 to 2.0.1

See full diff in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Dependabot will merge this PR once CI passes on it, as requested by @andrey-helldar.

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

@dependabot rebase will rebase this PR

@dependabot recreate will recreate this PR, overwriting any edits that have been made to it

@dependabot merge will merge this PR after your CI passes on it

@dependabot squash and merge will squash and merge this PR after your CI passes on it

@dependabot cancel merge will cancel a previously requested merge and block automerging

@dependabot reopen will reopen this PR if it is closed

@dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually

@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

dependencies
opened by dependabot[bot] 1

Releases(v3.0.0)

v3.0.0(Apr 20, 2022)

Source code(tar.gz)
Source code(zip)
v2.2.0(Feb 12, 2022)
What's Changed

Added New Options by @Jagdish-J-P in https://github.com/TheDragonCode/migrate-db/pull/15

New Contributors

@Jagdish-J-P made their first contribution in https://github.com/TheDragonCode/migrate-db/pull/15

Full Changelog: https://github.com/TheDragonCode/migrate-db/compare/v2.1.0...v2.2.0
Source code(tar.gz)
Source code(zip)
v2.1.0(Jan 17, 2022)
What's Changed

Update README.md by @andrey-helldar in https://github.com/TheDragonCode/migrate-db/pull/13

Added Laravel 9 support by @andrey-helldar in https://github.com/TheDragonCode/migrate-db/pull/14

Full Changelog: https://github.com/TheDragonCode/migrate-db/compare/v2.0.0...v2.1.0
Source code(tar.gz)
Source code(zip)
v2.0.0(Nov 20, 2021)
What's Changed

Changed namespace by @andrey-helldar in https://github.com/TheDragonCode/migrate-db/pull/12

Full Changelog: https://github.com/TheDragonCode/migrate-db/compare/v1.2.0...v2.0.0
Source code(tar.gz)
Source code(zip)
v1.2.0(Jul 6, 2021)

Source code(tar.gz)
Source code(zip)
v1.1.1(Mar 23, 2021)

Source code(tar.gz)
Source code(zip)
v1.1.0(Mar 23, 2021)

Source code(tar.gz)
Source code(zip)
v1.0.2(Mar 16, 2021)

Source code(tar.gz)
Source code(zip)
v1.0.1(Feb 26, 2021)

Source code(tar.gz)
Source code(zip)
v1.0.0(Feb 26, 2021)

Source code(tar.gz)
Source code(zip)
v1.0-RC5(Feb 26, 2021)

Source code(tar.gz)
Source code(zip)
v1.0-RC4(Feb 25, 2021)

Source code(tar.gz)
Source code(zip)
v1.0-RC3(Feb 24, 2021)

Source code(tar.gz)
Source code(zip)
v1.0-RC2(Feb 24, 2021)

Source code(tar.gz)
Source code(zip)
v1.0-RC1(Feb 12, 2021)

Source code(tar.gz)
Source code(zip)

Owner

The Dragon Code

GitHub

Just another PDO database library

PDO Just another PDO database library Installation Use Composer $ composer require faapz/pdo Usage Examples selecting, inserting, updating and deletin

313 Oct 11, 2022

SleekwareDB is a NoSQL database storage service. A database storage service that can be used for various platforms and is easy to integrate.

SleekwareDB is a NoSQL database storage service. A database storage service that can be used for various platforms and is easy to integrate. NoSQL API