I need to take "database script" or generate script for database by using scheduled job or by SSIS package.
Currently we are doing it manually by selecting "database" --> "Generate Script". But i need to do it by scheduling a job say for every month and copy it in a particular folder.
Is there any way to do it? if yes, what is the methodologies to accomplished it
View Complete Post