Automating an application

5 pts.
Tags:
Microsoft SQL Server 2000
VB
I am a beginner in VB. I was working on a project to upload data from one table to another. The tables are in different databases. Now I am supposed to automate it so that the update from one table to another can be done regularly. I guess it should be timer based but I do not know how to use it. Please help.

Answer Wiki

Thanks. We'll let you know when a new response is added.

What database are you using? If it is SQL Server or Oracle, I would consider writing a trigger for the insert/update/delete actions. That way, any changes made to one table can be immediately affected upon the other table. You can even traverse databases with the trigger code.

Another alternative would be to schedule a job on the server to do the updating.

Either of these would be the preferred solution as it keeps all activity on the server, thus cutting down on the amount of traffic between the client and the server.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following