I have a customer that has over 1,000 customer credit cards stored with Sage Payment Solutions (now PAYA).  They are planning on changing banks and through Sage 300 if you attempt to change the processing code with a credit card it will delete all the information.  Has anyone changed the processing code associated with a credit via SQL and skipped Sage 300?  

I am attempting to eliminate the need to have my client ask for over 1,000 credit card numbers from their clients.

TIA