5👍
Totally untried procedure follows. Not sure what you mean by ‘clean’. Here’s a few things on the internet that might help:
Step 1 – export from Access to MySQL:
http://www.geeksengine.com/article/export-access-to-mysql-4.html
Step 2 – point django at the database and use inspectdb to create models.py
https://docs.djangoproject.com/en/dev/ref/django-admin/#inspectdb
Step 3 – clean up models.py, run syncdb, add it to the admin, see what you go.
Step 4 – ask this guy if he ever managed it:
http://ifdebug.com/django-northwind-coming-soon/ – he’s had four years!
0👍
https://github.com/ouykjh/northwind_management/
I managed to create models for Northwind Database.
Just clone the repo. Make sure that settings.py are set.
Enter postgres -> create database named ‘mydb’ (as in settings.py).
Hit python manage.py syncdb – it will create tables with relations.
Enter postgres -> psql mydb
hit
\i inserty.psql
Inserts are here(https://github.com/ouykjh/northwind_management/blob/master/inserty.sql#L11)
Hope it works 🙂