Re: transferring data between Postgres databases

On 24/10/2016 3:08 PM, 'Aaron C. de Bruyn' via Django users wrote:
> If you're talking about migrating data using tools outside of django,
> I've used SQLWorkbench[0] in the past.
> I currently use it to selectively sync a handful of tables out of a
> ~900 table database *in* to my Django app.

Aaron, thanks for that. Do you know if it will handle a bunch of related
records in many tables to be copied as a related "set" to the other
database. Both databases have identical structures.

M

>
> [0] - http://www.sql-workbench.net/
>
> -A
>
> On Sun, Oct 23, 2016 at 9:04 PM, Mike Dewhirst <miked@dewhirst.com.au> wrote:
>> I have a user who has done a lot of work (instead of playing) in the staging
>> server and now wants to get that work into the production database.
>>
>> I'm about to research selective dump and load capabilities of Postgres but
>> in the meantime can anyone suggest any shortcuts?
>>
>> 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 https://groups.google.com/group/django-users.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/django-users/4ba85f65-b90c-c786-d112-96168cfbd9ca%40dewhirst.com.au.
>> For more options, visit https://groups.google.com/d/optout.

--
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 https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/8dd2221e-4201-d214-f747-73aa1e64cce6%40dewhirst.com.au.
For more options, visit https://groups.google.com/d/optout.