[Buildbot-devel] Switching databases

[Thomas Middeldorp]

You might want to give this a try:

http://adam.heroku.com/past/2009/2/11/taps_for_easy_database_transfers/
http://github.com/ricardochimal/taps

I recently used it to migrate a db from mysql to postgresql and it went 
smoothly. With any luck it will do the trick for this as well.

- Thomas


On 26/06/2012 12:05 a.m., Dustin J. Mitchell wrote:
> On Mon, Jun 25, 2012 at 1:27 AM, "Martin v. Löwis" <martin at v.loewis.de> wrote:
>> I'd like to switch from sqlite to postgres for the build master,
>> and migrate all state in the process. What's the best way to do
>> that?
> We don't have a good story for supporting migration from one DB engine
> to another.
>
> Your best bet is to dump the db from sqlite, use regexps to apply any
> transformations to create SQL that postgres will tolerate, and load it
> into postgres.
>
> Dustin
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Buildbot-devel mailing list
> Buildbot-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/buildbot-devel