P
Patrick Tingen
Guest
The DataDigger can do just this for you. In addition, the DataDigger can also generate a local database for you that has the same schema as your remote database. Right-click on the table browse and choose "clone this database": Choose the folder where the database should be created: You end up with a local, empty database with the same structure as your production db. You can dump data from your database in various formats. Make your selection of the records and choose the download button: Then choose the format you like: If you choose XML format, you can simply dump them, switch to your local database and drag the XML file onto the DataDigger window. It will then import the XML file: If you have a lot of tables, this may not be the best way to do it, since you have to do it one by one. If the number of tables is limited, I think this is the smoothest solution. The DataDigger is free and open source, and available here . (disclaimer: I am the author)
Continue reading...
Continue reading...