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
TypingStarsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ste5anSenior DeveloperCommented:
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..
0
pcelbaCommented:
Yes, this is simple when both databases reside on the same server. You'll need some programmer or database administrator to do the work. He will know the command (either INSERT or UPDATE) which can do the work. Emails are stored as clear text obviously so there should be no problem. Passwords are different story and depends on their implementation. If they are also stored as clear text (which is not good practice) then you may copy them without problems. All other ways must be tested first.

If your databases do not reside at one server then you have to create a connection from one database to the other one. This differs for various SQL servers.

To copy new customer record from one database to another one is also possible. Believe or not the piece of code which will do it is called Trigger. And you'll need both insert trigger (for new customers) and update trigger (for customer profile updates), and maybe also the delete trigger when customer is deleted. If your databases reside on different servers then you may think about different ways of data synchronization, e.g. export CSV file from one database periodically and import it to the target server.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TypingStarsAuthor Commented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.