Database Exporter

Export your database quickly and easily as a Laravel Migration and all the data as a Seeder class. This can be done via artisan commands or a controller action.

Please note that I've only tested this package on a MySQL database. It has been confirmed it does not work with Postgres.

Installation

$ composer require nwidart/db-exporter

Add the service provider to app/config/app.php:

'Nwidart\DbExporter\DbExportHandlerServiceProvider'

(Optional) Publish the configuration file.

php artisan config:publish nwidart/db-exporter

Use dev-master as version requirement to be on the cutting edge

Documentation

From the commandline

Export database to migration

Basic usage

php artisan dbe:migrations

Specify a database

php artisan dbe:migrations otherDatabaseName

Ignoring tables

You can ignore multiple tables by seperating them with a comma.

php artisan dbe:migrations --ignore="table1,table2"

Export database table data to seed class

This command will export all your database table data into a seed class.

php artisan dbe:seeds

Important: This requires your database config file to be updated in app/config/database.php.

Uploading migrations/seeds to remote server

Important: This requires your app/config/remote.php to be configured.

Important: The package configuration remote key needs to be configured to correspond to your remotes directory structure.

You can with the following command, upload migrations and / or seeds to a remote host with php artisan dbe:remote remoteName [--migrations] [--seeds]

For instance to upload the migrations to the production server:

php artisan dbe:remote production --migrations

Or upload the seeds to the production server:

php artisan dbe:remote production --seeds

Or even combine the two:

php artisan dbe:remote production --migrations --seeds

From a controller / route

Database to migration

Export current database

This requires your database config file to be updated. The class will export the database name from your app/config/database.php file, based on your 'default' option.

Make a export route on your development environment

Route::get('export', function()
{
    DbExportHandler::migrate();
});

Export a custom database

Route::get('export', function()
{
    DbExportHandler::migrate('otherDatabaseName');
});

Database to seed

This will write a seeder class with all the data of the current database.

Route::get('exportSeed', function()
{
    DbExportHandler::seed();
});

Next all you have to do is add the call method on the base seed class:

$this->call('nameOfYourSeedClass');

Now you can run from the commmand line:

• php artisan db:seed,
• or, without having to add the call method: php artisan db:seed --class=nameOfYourSeedClass

Chaining

You can also combine the generation of the migrations & the seed:

DbExportHandler::migrate()->seed();

Or with:

DbExportHandler::migrateAndSeed();

Important : Please note you cannot set a external seed database. If you know of a way to connect to a external DB with laravel without writing in the app/database.php file let me know.

Ignoring tables

By default the migrations table is ignored. You can add tabled to ignore with the following syntax:

DbExportHandler::ignore('tableToIgnore')->migrate();
DbExportHandler::ignore('tableToIgnore')->seed();

You can also pass an array of tables to ignore.

TODO

• ~~Export data too. It would be cool if it could also generate a seed file based of the data in the tables. This would be more usefull to run on the production server to get the seed on the development server.~~ 3/1/13
• ~~Deploy the migration directly to the production server ready to be migrated. (as an option)~~ 5/1/13
• ~~Make commands to do the same thing (export db to migration)~~ 4/1/13
• ~~Make commands to do the same thing (export db to seed)~~ 4/1/13
• Making the upload to remote available directly when generating the migrations/seeds

Credits

Credits to @michaeljcalkins for the original class on paste.laravel.com (which goal was to generate migrations from a database). Sadly I couldn't get it working as-is, so I debugged it and decided to make a package out of it, and added a couple a features of my own.

License (MIT)

Copyright (c) 2013 Nicolas Widart , n.widart@gmail.com

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.