Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shubhada
Posting Yak Master
117 Posts |
 Posted - 2006-12-06 : 02:15:34
|
| I have a database in which every day new data is inserted.I want database scripts (insert statement) to update my database instead of taking dump.Is SQL server 2000 having any provision to generate scripts for newly added data.SQLTeam |
|
|
seyha_moth
Yak Posting Veteran
74 Posts |
Posted - 2006-12-06 : 02:24:03
|
| According to ur question I find that u should use Trigger to inserted table.seyha moth |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-06 : 02:26:17
|
| Check this link:[url]http://vyaskn.tripod.com/code.htm#inserts[/url]Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
shubhada
Posting Yak Master
117 Posts |
Posted - 2006-12-06 : 03:04:43
|
| Is it possible through Enterprise Manager?SQLTeam |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-06 : 03:06:45
|
| No.Peter LarssonHelsingborg, Sweden |
|
|
|
shubhada
Posting Yak Master
117 Posts |
Posted - 2006-12-06 : 04:34:31
|
| Is any tool is avaliable for this like TOAD?SQLTeam |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-12-06 : 10:54:24
|
<<if you feel that the link Harsh provided is not good enough.>>Good enough to generate INSERT statements  MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Generate SQL Scripts.