Click here to Skip to main content
13,052,022 members (65,346 online)
Rate this:
Please Sign up or sign in to vote.
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
Updated 19-Feb-13 0:15am
Rate this: bad
Please Sign up or sign in to vote.

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

Hope this helps
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

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.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 19 Feb 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100