Heya.
I’m doing an import from rt1 to rt2 and have a large database of about 200,000 tickets, so i’m doing them in batches…
problem is I imported one of the batches twice by mistake, so now those tickets have double transactions for them…
I was wondering how do rollback this mistake, what is the best thing to do? I would imaging I can just delete the given tickets in from Tickets and from Transactions… is there any other tables that get modified when a ticket is created?
As it takes about a second a ticket for the import, I’d rather not have to drop the whole db and start again.
Regards,
Matthew Watson
Development, Netspace Online Systems
mwatson@netspace.net.au