asked on

Copy database record from one database to another.

I have an existing database that my software program works great with.
However the shopping cart is not good for my needs and I want to add WooCommerce.
My question is, since my program requires the customers Email and a password, can those fields be copied to my existing customer database table so my program continues to work? And how to code of course. Lastly, what would trigger this to happen after a new customer is added?
Thank You

ste5an

Normally not.

Cause passwords are should not be saved in plaintext. So it maybe possible when the used authentication mechanisms (hash and salt algorithm) are the same. But I would not bet on it.

When you're passwords are stored as plain text, well, then you have an serious security issue..

ASKER CERTIFIED SOLUTION

Pavel Celba

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

TypingStars

ASKER

Thank you for your comments. I did not expect to get into the password area, but both of you are right. The passwords are already being encrypted, so they are not plain text at all.

I'm going to WooCommerce and if I could just get my VB 6 program to read its customer table, I would not have the need to copy any records to the older database where the customers email and password is presently being read to authenticate them. Any additional feedback would be appreciated, Thank You