PHP Classes

PHP Migrate Database: Migrate data that match conditions between tables

Recommend this page to a friend!
  Info   Documentation   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStar 38%Total: 313 All time: 7,286 This week: 455Up
Version License PHP version Categories
migration_database 0.0.1GNU General Publi...5PHP 5, Databases, Systems administration
Description 

Author

This class can migrate data that match conditions between tables.

It can take the parameters of connection of two database and connect to them using PDO.

The class can also migrate data that matches certain conditions from one database table to the other.

Innovation Award
PHP Programming Innovation award nominee
September 2017
Number 3
Sometimes PHP applications need to synchronize databases hosted in different locations. However in many cases the information that needs to be synchronized is not the whole information in the database.

This class provides a solution that allows to migrate data of specific tables by specifying conditions that restrict the table records that need to be migrated.

Manuel Lemos
Picture of joerverson
Name: joerverson <contact>
Classes: 3 packages by
Country: Brazil Brazil
Innovation award
Innovation award
Nominee: 2x

Documentation

migration_database

migrate yours data between databases, easy and fast you can migrate datas of the a database sorce fro database clone or just table of the source database.

How use?

Define the server source and the serve that clone in you database

    "src" => [
        "user" => "",
        "host" => ".db.4855800.hostedresource.com",
        "pass" => "@",
        "database" => ""
    ],
    "clone" => [
        "user" => "dev",
        "host" => "localhost",
        "pass" => "@",
        "database" => ""
    ],
];
$migdb = new Migration_Database($ar);
$migdb->migrate(["table"=>"qualidade", "pk"=>['pk1', 'pk2'], "where"=>["key"=>"value"]]);```

  Files folder image Files (2)  
File Role Description
Plain text file migration_database.php Class Class source
Accessible without login Plain text file README.md Doc. Documentation

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:313
This week:0
All time:7,286
This week:455Up
User Ratings User Comments (3)
 All time
Utility:57%StarStarStar
Consistency:53%StarStarStar
Documentation:50%StarStarStar
Examples:-
Tests:-
Videos:-
Overall:38%StarStar
Rank:3961