Hi Nathan, I'd be curious to know your position about this one year later.
At the moment, like Paul said, I can still see where an integration of dbunit tasks as <changeset> could give the user best of both worlds. DBunit has been around for years and is fine for data import/export needs. Not to the point that a data structure refactoring in most IDE would take DBunit XML syntax into account though, it'd then be near perfect. regards, nodje Paul Keeble wrote: > > I've been using DBUnit recently and its quite possible to do this sort of > export and import of data via XML files that it uses. Its pretty easy to > use and will likely do what you need. A combination of liquibase and > DBUnit is a powerful combination allowing you to maintain the structure > and the data as part of the move without having to do a binary copy (while > at the same time capturing a baseline). > > Maybe integration with DBUnit would be a good idea for the future to > support data export and import. > > Paul Keeble > > ----- Original Message ---- > From: "Voxland, Nathan" <[email protected]> > To: [email protected] > Sent: Wednesday, 30 April, 2008 5:50:05 AM > Subject: Re: [Liquibase-user] Migrating ddbb, what about the existing > data? > > The changelog files themselves support <insert > tags, it's just the diff > tool that does not pull out data, primarily because I don't think it is a > useful feature until we have a way of specifying what tables to export > data from. > > You can certainly work around the issue. One option is to use a separate > tool to export the data as insert statements and reference the file with > the <sqlFile> tag. You could also write sql to generate your insert > statements (or even <insert> tags) with something like "select 'insert > into TABLENAME (id, name) values '(||id||','||'''name||''');' from > TABLENAME" for each of your tables. The resulting rows can be pasted > inito your change log file or referenced with the <sqlFile> tag. > > Nathan > > ________________________________ > > From: [email protected] on behalf of > javier.rivas > Sent: Tue 4/29/2008 5:16 PM > To: [email protected] > Subject: [Liquibase-user] Migrating ddbb, what about the existing data? > > > > > Hi, > > we are trying to migrate an existing database, so we are thinking of using > liquibase. > > I haven't found anything in the documentation or in the mailing lists, > apart > form this (http://www.liquibase.org/manual/diff - "It does not (currently) > check: Data differences ") about keeping the existing data. > > Is there any way of getting some kind of ddl, as well as the change log? > > Apart from that, this looks like a very promising tool. Well done!! > > Thank you very much, > > Javier > > > -- > View this message in context: > http://www.nabble.com/Migrating-ddbb%2C-what-about-the-existing-data--tp16971720p16971720.html > Sent from the LiquiBase - User mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Don't miss this year's exciting event. There's still time to save $100. > Use priority code J8TL2D2. > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone > _______________________________________________ > Liquibase-user mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/liquibase-user > > > > > > > > __________________________________________________________ > Sent from Yahoo! Mail. > A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html > > ------------------------------------------------------------------------- > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Don't miss this year's exciting event. There's still time to save $100. > Use priority code J8TL2D2. > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone > _______________________________________________ > Liquibase-user mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/liquibase-user > > -- View this message in context: http://www.nabble.com/Migrating-ddbb%2C-what-about-the-existing-data--tp16971720p23701314.html Sent from the LiquiBase - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT is a gathering of tech-side developers & brand creativity professionals. Meet the minds behind Google Creative Lab, Visual Complexity, Processing, & iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian Group, R/GA, & Big Spaceship. http://www.creativitycat.com _______________________________________________ Liquibase-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/liquibase-user
