Unfortunately, I have not yet had a chance to look at dbunit enough to have an opinion. I agree that something better would be good, but I'm not sure.
It would be a very good option as a project in the new LiquiBase 3rd party plugin respository :) Anyone else have thoughts? Nathan -----Original Message----- From: nodje [mailto:[email protected]] Sent: Monday, May 25, 2009 12:33 AM To: [email protected] Subject: Re: [Liquibase-user] Migrating ddbb, what about the existing data? 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. But it's definitely worth looking into IMHO since Liquibase doesn't have a way to export data yet. 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--tp 16971720p16971720.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/j avaone > _______________________________________________ > 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/j avaone > _______________________________________________ > 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--tp 16971720p23701379.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 ------------------------------------------------------------------------------ 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 as they present alongside digital heavyweights like Barbarian Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com _______________________________________________ Liquibase-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/liquibase-user
