update Database using .sql files

kirkuk_um · Post by **kirkuk_um** » Wed 23 Aug 2006 07:57

hi all..

hope u all can help me ;(

let say i hv one file (eg. consumer.sql)
..then i need to update the Consumer table in my database using my sql file (consumer.sql). what component should i use n how? thanks..

Antaeus · Post by **Antaeus** » Wed 23 Aug 2006 12:59

You can use either of following components: TMyScript, TMyDump, TMyQuery. But only TMyDump allows you to watch restoration progress (OnRestoreProgress event).