I like to know how to take the dump of data from specific database and generate an sql file with insert statement on specified duration of time i.e. day,week or month.Also it be helpful if someone already implemented the above thing and can provide me with the detail description of how to do the thing in windows using a batch file or using the sql mode.