Django -- Multiple Databases -- Data Migration

Question

I am having difficulty understanding Django Multiple Databases documentation. Below is what I am trying to achieve.

I have to migrate some data from one database to another in Python. Both databases have same structure, so I only have one model file.

What I need to do in code is select data from some tables of one database and insert into tables of another database.

How can I do it, i.e., select in Model query which database to use? Also any suggestions and recommendation would be appreciated.

Thanks

bruno desthuilliers · Accepted Answer · 2013-12-26 08:38:52Z

1

Assuming you have "db_for_read" and "db_for_write" configured in your settings, for the reading:

YourModel.objects.using("db_for_read").all()

For the writing - per instance:

your_model_instance.save(using="db_for_write")

or in batch:

YourModel.objects.using("db_for_write").bulk_create(
    [your_model_instance1, your_model_instance2, etc]
    )

answered Dec 26, 2013 at 8:38

78.3k6 gold badges102 silver badges129 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1