Update Database Daily .

Question

0.00/5 (No votes)

See more:

Example -
Database containing several tables - i choose one table name - hotel.
it has 1000 entries in it .
Suppose today 100 entries are added as data in hotel table, all this process is offline on my pc .
what i do ,export the table , open online database find the table , delete all entries from it , then import the table which i exported early and re-insert all data again . This how i update my database tables daily ,

I Have Tried Online Entries From my pc but , it generate a error ( max user connection ) . So i do all database process offline and then changes are done online as mention above .

So anybody have any idea.

Posted 18-Feb-13 17:59pm

Narendra Singh Rathore

Updated 19-Feb-13 0:15am

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jameel VM · Answer 1 · 2013-02-18T18:26:00

Solution 1

Crate a stored procedure for updating and run this procedure automatically every day by using SQL job
for set up the sql job please follow this link
http://msdn.microsoft.com/en-us/library/ms135739.aspx

Hope this helps

Posted 18-Feb-13 18:26pm

Jameel VM

Khorshed Alam, Dhaka · Answer 2 · 2013-02-18T23:58:00

Solution 2

Hi,
Please create a SSIS package with all of your steps (or if you can give more details I can help you.)
Schedule the package with SQL Server Agent.

Posted 18-Feb-13 23:58pm

Khorshed Alam, Dhaka