Re: Sqlite3 to Postgres Migration?

2015-02-20 Thread Mike Dewhirst
On 21/02/2015 9:55 AM, talex wrote: Thanks for your helpful comments. Andrew, thanks for your migration article at http://afrg.co/updj17/a2 . It is slightly daunting for me at this point, but I may need to come back to it later. Your book looks interesting. Mike, thanks for the dump/load load

Re: Sqlite3 to Postgres Migration?

2015-02-20 Thread Andrew Farrell
One approach may be to use django-import-export to add to the admin interface the capability to export your data to CSV (or JSON or Excel) and likewise to import it. Then, simply run two instances of your app: one on top of postgres, one on

Re: Sqlite3 to Postgres Migration?

2015-02-20 Thread talex
Thanks for your helpful comments. Andrew, thanks for your migration article at http://afrg.co/updj17/a2 . It is slightly daunting for me at this point, but I may need to come back to it later. Your book looks interesting. Mike, thanks for the dump/load load suggestion. For the moment, I think

Re: Sqlite3 to Postgres Migration?

2015-02-19 Thread Mike Dewhirst
On 20/02/2015 3:07 AM, Tom Lockhart wrote: On Feb 18, 2015, at 11:04 PM, talex wrote: I have a functioning Django application that is based on sqlite3, but I want to change to using Postgres. I’ll point out for the benefit of others who might be getting started: Postgres is a full feature

Re: Sqlite3 to Postgres Migration?

2015-02-19 Thread Tom Lockhart
On Feb 18, 2015, at 11:04 PM, talex wrote: > I have a functioning Django application that is based on sqlite3, > but I want to change to using Postgres. I’ll point out for the benefit of others who might be getting started: Postgres is a full featured database and supports the full range of Dj

Re: Sqlite3 to Postgres Migration?

2015-02-19 Thread Andrew Pinkham
On Feb 19, 2015, at 1:04 AM, talex wrote: > Am I correct that use of "python makemigrations" followed by > "python migrate", should copy the existing data into Postgres > and leave me with a working application? I'm afraid not. Migration allows for predictable and reversible alterations to the d

Sqlite3 to Postgres Migration?

2015-02-18 Thread talex
I have a functioning Django application that is based on sqlite3, but I want to change to using Postgres. I have altered the DATABASES clause in settings.py to use Postgres. and I am using Django version 1.7. Am I correct that use of "python makemigrations" followed by "python migrate", should co