I think it would be great if it would be possible to do full database backups (and restores) using Toad! That way it would be possible to move a database from one server to another, without the need for extra software.Currently I use Toad for everything MySQL. But for one thing only, creating backups and moving databases from one location to another, I always keep Navicat or DataTools (http://www.terasoft.info/downloads/downloads-datatools.tkl, freeware) on the side.There is an export function in toad, but this only creates SQL-files (or other files) table by table. Depending on the DB structure this can take very long to restore, as each script should be run individually. To make matters worse, you first need to manually re-create the datbase structure, as the SQL only contains 'insert' statements. All in all it can take hours.With datatools, I can just dump an entire database with one click of the button, and re-create it with another click of the button. I have spend a long time trying to create a full backup using Toad, but never found any option. I long refused to believe this, because it seems so very basic to me. But perhaps most people are managing their databases in a completely different way than we do, so they have no need for a GUI to be able to backup or move databases. But for me it would be brilliant if I could do all that using Toad.
Heyas,check out the functions "Schema Compare..." and "Data Compare" under "Tools"/"Compare". Those made my day when migrating a DB/2 schema with data. However, it was a bit bumpy, since the order of tables/stp's isnt maintained according to dependencies (foreign keys or calling stacks).regards/M
Thanks, DocJones! Indeed using a combination of schema compare and data compare does the trick. But it is incredibly contrived for which is really a basic function.There is an export wizard that allows us to export to Excel, separate SQL files per table, and many more formats. A lot of advanced options, but simply downloading importing or exporting an entire database is NOT an option. It just really surprises me. The underlying technology is already there in Toad. Why not allow to download a complete database, upload a complete database or move databases from one server to another with a couple of clicks? There is so much functionality in Toad. For web developers and other users of 'simple databases', most of this is complete overkill. But for basic functionality we still need to resort to the command line tools or other third party programs. By adding simple import, export and backup functions for complete databases, Toad would become a one-stop shop for everything MySQL. It would be so sweet :)
I would like to stress how nice it would be to have full dump (like done with mysqldump) with an easy graphical user interface inside of Toad4mySQL.I'm often transfer daat from the production environment to a R&D environment, and a full dump would make my life much easier.There is already the single table export as script, why not doing the next step and including the full dump? Otherwise I think Toad4mySQL is an awesome tool.ThanksFred