vlsup
02-24-2010, 04:28 PM
1) User has trial HEM but 15 days expired
2) user has another comp and installs HEM there
3) but no access via network (or smth) to the first one
4) so he can't set Postgres to connect to old DB anyway
5) user wants notes only from this old DB - no stats, no winnings. But because of trial end he can't start HEM and export notes via menu. HHs are in archive - no problem to import in a new DB.
6) We know - notes are stored in a DB table "hemplayernotes" (4 fields: note_id - player_id - note - icon_id)
and is possible to SQL-search playername (from another DB table) using player_id
Q: How to extract notes from old DB and put them in a new one?
It must be simple set of SQL queries...
DB_old --- csv-file --- DB_new
Tell me it's text, pls
2) user has another comp and installs HEM there
3) but no access via network (or smth) to the first one
4) so he can't set Postgres to connect to old DB anyway
5) user wants notes only from this old DB - no stats, no winnings. But because of trial end he can't start HEM and export notes via menu. HHs are in archive - no problem to import in a new DB.
6) We know - notes are stored in a DB table "hemplayernotes" (4 fields: note_id - player_id - note - icon_id)
and is possible to SQL-search playername (from another DB table) using player_id
Q: How to extract notes from old DB and put them in a new one?
It must be simple set of SQL queries...
DB_old --- csv-file --- DB_new
Tell me it's text, pls