PHP Classes
elePHPant
Icontem

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    
Last Updated Ratings Unique User Downloads Download Rankings
2017-10-05 (1 year ago) RSS 2.0 feedStarStar 39%Total: 304 All time: 7,160 This week: 334Up
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
Name: joerverson <contact>
Classes: 2 packages by
Country: Brazil Brazil
Age: ???
All time rank: 3399269 in Brazil Brazil
Week rank: 788 Up53 in Brazil Brazil Up
Innovation award
Innovation award
Nominee: 1x

Details

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:304
This week:0
All time:7,160
This week:334Up
User Ratings User Comments (3)
 All time
Utility:58%StarStarStar
Consistency:54%StarStarStar
Documentation:50%StarStarStar
Examples:-
Tests:-
Videos:-
Overall:39%StarStar
Rank:2991