Hi Have a customer with 1.3 whose journals were huge and db had reached 2g limit. To get them out of a hole I had to delete the journals completely as it was stopping the pos's being used. Made a backup of the data first. I didnt know the command to only delete before a certain date then.
They are now upgrading to 2.0 and I have the current db with about 2 weeks journals and the old db with years of them.
I want to make the new db have the current journals and the previous years from the db backup, can this be done via some sql commands?
Thanks