Re: data transfer between databases

Mike

FWIW - I have a site for which I need to do that, I use MySQL so I just dump the data using mysqldump, transfer it to the other machine and load it up. There is some scripting around it to keep track of IDs so I dump deltas only, works just fine.

Best regards

François


On Jun 30, 2013, at 6:24 PM, Mike Dewhirst <miked@dewhirst.com.au> wrote:

> mulianto and Avraham
>
> Thanks for your suggestions. Dumping data isn't the entire problem - which is this:
>
> There will be an *ongoing* need to add new data from tables in one database to the same-named tables in another database on a remote machine. Two of the tables are in a m2m relationship.
>
> Thanks
>
> Mike
>
> On 30/06/2013 5:40pm, Mike Dewhirst wrote:
>> This is probably a Postgres question but someone might be able to offer
>> advice on how to transfer data :)
>>
>> New "reference" or read-only data gets input during development and I
>> want to transfer it to the production database from time to time.
>>
>> I think my choices are:
>>
>> 1. Re-enter it manually - only if all else fails.
>>
>> 2. Use Django's multi-database feature and write a utility to transfer
>> data which doesn't already exist. Except the databases are on different
>> machines in different data centres.
>>
>> 3. Exploit some pre-existing tool written for precisely this problem.
>>
>> Any suggestions?
>>
>> There are currently three reference tables involved and two have m2m
>> relationships between themselves. The other is stand-alone.
>>
>> Customer data is fine in the production database and won't be touched.
>> There are no relationships with the reference tables.
>>
>> Thanks
>>
>> Mike
>>
>
> --
> You received this message because you are subscribed to the Google Groups "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
> To post to this group, send email to django-users@googlegroups.com.
> Visit this group at http://groups.google.com/group/django-users.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
For more options, visit https://groups.google.com/groups/opt_out.