On Mon, Jul 20, 2009 at 11:07 PM, fREW Schmidt<[email protected]> wrote: > Hey guys, > > I was thinking it would be cool to do more local development, and the only > thing tethering me to the VPN is our database server (SQL Server,) > fortunately for this plan the only really special thing I do in the database > is FK constraints and maybe a few non-standard defaults (now() etc.) But I > think for the most part that stuff will be fine to ignore for non-local > development. Anyway, does anyone have any idea how I could use DBIC to > mirror a server into an sqlite database? Thanks!
If you're willing to do TDD, you can use DBIx::Class::Fixtures to dump fixtures on the remote server, then load them onto your local database while running tests. You can also do the inverse, if you don't depend on the data in the remote server, deploy into a local database, dump the fixtures, do your development, then load the fixtures on the remote server and run the tests to fix any incompatibilities. -- Eden Cardim Need help with your Catalyst or DBIx::Class project? Code Monkey http://www.shadowcat.co.uk/catalyst/ Shadowcat Systems Ltd. Want a managed development or deployment platform? http://edenc.vox.com/ http://www.shadowcat.co.uk/servers/ _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
