Migration tools

[Sandy]

I can't seem to find an option for migrating a complete database. I want to just move one db to the same server, but other then generating a back up and restoring is their an automated way to do it from MySQL to MySQL? I may be just overlooking the obvious.

Thanks

Sandy

[alexa]

This can be done with the help of Data Export/Import or Schema/Data Compare features.

You can automate the above tasks with the help of the command line interface of dbForge Studio for MySQL. Please refer to the following topics in the product's Help documentation:

- How To: Export Data through Command Line
- How To: Import Data through Command Line
- How To: Compare and Synchronize Schemas through Command Line
- How To: Compare and Synchronize Data through Command Line

and the following articles on our website:

http://blogs.devart.com/dbforge/how-to- ... ndows.html
http://www.devart.com/dbforge/mysql/stu ... ackup.html

[Sandy]

Thanks for the quick reply Alexa. What I was looking for was the 'lazy' way to do the migration. Some of my other tools have a very simple way to migrate databases which essentially is to select the source and the destination and hit start . It's never a problem doing a back up and restore but always looking for a simpler way to do it.

Sandy

[alexa]

You can add a suggestion on our UserVoice forum where other users can vote for it http://devart.uservoice.com/forums/7729 ... -for-mysql

We collect and analyze the information from this forum in order to make a proper roadmap for future product releases.

[Sandy]

Will post a new feature request!

Thanks Alexa

[Sandy]

Also any simple way to just move data from one database's table to another without creating a script and reloading? This is something I do a lot and some of the competitive tools even just allow drag and drop of the table to another database and sets it all up.

Sandy

[alexa]

Please consider the 'Duplicate Object' feature (the 'How To: Create Copy of Database Object' topic in the product's Help documentation).

If that's still not what you were looking for, please add a suggestion on the UserVoice forum.

[Sandy]

Thanks, the duplicate object looks like its only in the same database. I'm looking to duplicate the object to another database so I don't think that will work. I'll hit up the uservoice again

[alexa]

Yes, please add a suggestion on the UserVoice forum.