|
I have a previous cnprog installation and I want to migrate to osqa. How do I do this, I observed that there are quite a few changes to the database. |
|
Actually, here's an option. Download and install django evolution, then upgrade your code, and add "django-evolution" to the INSTALLED_APPS setting, finaly run manage.py evolve --hint --execute. But while you do that, keep django-authopenid around and in the installed apps setting. After the database "evolution" you'll have to run a small script to convert django-authopenid associations to the new style associations. The script is not in the repo because it was in the django-authopenid folder, but I'll add it in a while and update this. Finally you can remove django-authopenid, both the folser and from installed-apps. Django-evolution is very safe, is being written by one of the django core developers, and is a strong candidate to be part of the django core in a near future. that's cool I should learn how to use that.
(20 Mar '10, 20:05)
Evgeny Fadeev
This looks like the right way to do it. I think we should include evolution as part of osqa project.
(21 Mar '10, 03:59)
sorin
I'm srill trying to learn it myself :-) They have some things called "evolutions" that can be bundled with an application, so we can migrate data from the olds schema to the new schema, but this is not very well documented yet. We should at least bundle these "evolutions".
(21 Mar '10, 12:46)
Hernani Cerq... ♦♦
|
|
I already did the migration using the trial of SQLyog - this has an option to synchronize two databases. It does create SQL scripts to update the database. Also it is able to synchronize data in addition to schema. Have you been able to install email subscriptions? If not - run 'subscribe_everyone' job (adds weekly subscription for everyone - for different option edit up the subscribe_everyone.py file)
(21 Mar '10, 16:17)
Evgeny Fadeev
|
|
You are probably in for some fun. There are two ways: (1) write proper migration code (2) use sql scripts from If you choose second option then I recommend taking two steps:
Older sql migration scripts are in the directory The general idea is:
Which scripts you'll want to look into - depends on the date of your CNPROG code. Good luck! |
Gi Sorin, Hernani or I could probably help you if you wish. Just catch us in the OSQA channel.