<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div>On Jul 20, 2009, at 8:19 PM, fREW Schmidt wrote:</div><blockquote type="cite">On Mon, Jul 20, 2009 at 10:10 PM, Ashley <span dir="ltr"><<a href="mailto:apv@sedition.com">apv@sedition.com</a>></span> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <div class="im">On Jul 20, 2009, at 7:52 PM, fREW Schmidt wrote:<br> <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> Very interesting! How did you generate the table structure for the SQLite database?</blockquote></div> Still, I think deploy is a really hot feature and I'm so glad it's become more mature/stable lately along with the pieces it relies on like SQL::Translator; the folks who work on those rule. Check out DBIx::Class::Fixtures too. Chocolate and peanut-butter.<div> <div></div><div class="h5"></div></div></blockquote><div><br>Interesting. I assumed that might be how you pull it off. Our models don't have any column type information, but I doubt that will be an issue since everything in SQLite is just TEXT or BLOB or whatever. One last question. Did you dump the SQL statements with perl or MySQL? <br> </div></div></blockquote></div><br><div>I think that's a trick to answer. You don't need to dump any SQL at all. I happen to do so because I use the Loader stuff to create my schemata but I'm dumping definitions (because SQLite has no FK support yet). Your DBIC classes create the DB and from there you could--never tried it but it should work fine--use the original DB via a connected schema to populate the new DB via its own connected schema. Then just iterate through the DB that has data copying it to the one that doesn't.</div><div><br></div><div>If your original DB has the FKs and such you could recreate your schema dynamically from a connection to it. See <a href="http://search.cpan.org/dist/DBIx-Class-Schema-Loader/lib/DBIx/Class/Schema/Loader.pm">http://search.cpan.org/dist/DBIx-Class-Schema-Loader/lib/DBIx/Class/Schema/Loader.pm</a>#make_schema_at</div><div><br></div><div>The data transfer would be (possibly extremely) slow on a big DB and dumping SQL in some standard format and reloading would be faster and maybe easier if you can find the right docs and flags; which I couldn't help with off-hand.</div><div><br></div><div>-Ashley</div></body></html>