PHP Classes

PHP Migrate Database: Migrate data that match conditions between tables

Recommend this page to a friend!
  Info   View files Documentation   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum (4)   Blog    
Ratings Unique User Downloads Download Rankings
StarStar 38%Total: 313 This week: 1All time: 7,278 This week: 560Up
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
Age: ???
All time rank: 3212240 in Brazil Brazil
Week rank: 109 Up9 in Brazil Brazil Up
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  
File Role Description
Plain text file migration_database.php Class Class source
Accessible without login Plain text file README.md Doc. Documentation

 Version Control Unique User Downloads Download Rankings  
 100%
Total:313
This week:1
All time:7,278
This week:560Up
User Ratings User Comments (3)
 All time
Utility:57%StarStarStar
Consistency:53%StarStarStar
Documentation:50%StarStarStar
Examples:-
Tests:-
Videos:-
Overall:38%StarStar
Rank:3881