Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: MySQL
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 18:59pm
Edited 19-Feb-13 1:15am
v2
Rate this: bad
good
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
http://msdn.microsoft.com/en-us/library/ms135739.aspx
 
Hope this helps
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

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.
  Permalink  

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

  Print Answers RSS
0 Afzaal Ahmad Zeeshan 256
1 OriginalGriff 251
2 BillWoodruff 240
3 Maciej Los 230
4 Sergey Alexandrovich Kryukov 195
0 OriginalGriff 6,419
1 Sergey Alexandrovich Kryukov 6,008
2 DamithSL 5,183
3 Manas Bhardwaj 4,673
4 Maciej Los 4,070


Advertise | Privacy | Mobile
Web03 | 2.8.1411019.1 | Last Updated 19 Feb 2013
Copyright © CodeProject, 1999-2014
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