This is exactly what I am working on, more for importing a foreign database that backing up, but it could be used for both. Unfortunately I am in the early alpha stages, so I don't have much to offer you, except that I have a card where you enter the connection information for 2 databases, which then connects to them and reads the database schema. After that there are 2 phases: Table links and column links. Once you set those up, you click the go button and it will import just the tables and columns you selected from the second database into the first.
One of the features is that it will add tables and columns that do not already exist in the first database for you. Very handy. But as I said I am writing it really as an import/merge from a Spiceworks database so I can get all the devices collected by Spiceworks networks scanner into my own database where I can handle software licenses and other resources associated with the device the way I want them handled. Still, the techniques I use are very much along the lines of what you describe. Bob On May 31, 2010, at 11:35 AM, JosepM wrote: > > Hi Folks, > > I need to create and backup mySQL database from Rev. I have created the > database, so only I need to run the schema, but I have no clear what can be > the best solution for. > > Any experience? > > Salut, > Josep > -- > View this message in context: > http://runtime-revolution.278305.n4.nabble.com/Create-mySQL-database-structure-from-Rev-tp2237715p2237715.html > Sent from the Revolution - User mailing list archive at Nabble.com. > _______________________________________________ > use-revolution mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
