[Dbix-class] Local DB Mirror

Eden Cardim edencardim at gmail.com
Tue Jul 21 11:52:42 GMT 2009


On Mon, Jul 20, 2009 at 11:07 PM, fREW Schmidt<frioux at gmail.com> 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/



More information about the DBIx-Class mailing list