Currently I export the old database, search and replace the database names and do:]
File -> Export -> SQL Alter script
But first is there a way to avoid the database names? As my live database is likely to have a different name then in workbench.
Second I encounter many times that the script tries to add foreign keys, but these will throw a 121 error in mysql. I guess because they are double indexes... is there some way to check if the index exists if not add.. as the create table syntax?