file.sqlite3

INSERT INTO new_db.lettings_letting(id,title,address_id) SELECT id,title,address_id FROM oc_lettings_site_letting;

INSERT INTO new_db.profiles_profile(id,favorite_city,user_id) SELECT id,favorite_city,user_id FROM oc_lettings_site_profile;

INSERT INTO new_db.lettings_address(id,number,street,city,state,zip_code,country_iso_code) SELECT id,number,street,city,state,zip_code,country_iso_code FROM oc_lettings_site_address;

INSERT INTO new_db.auth_user(id,password,last_login,is_superuser,username,first_name,email,is_staff,is_active,date_joined,last_name) SELECT id,password,last_login,is_superuser,username,first_name,email,is_staff,is_active,date_joined,last_name FROM auth_user