|
Home > Archive > MS SQL Server > March 2006 > Generate SQL Script
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Generate SQL Script
|
|
| Billy Leung 2006-03-09, 7:23 am |
| Hi,
To generate SQL script, we can right click the database in SQL Server
Enterprise Manager. But is there any way that I can schedule to generate
this script automatically?
Thank you for your help, and any feedback will highly appreciated.
Billy
| |
| Jeffrey K. Ericson 2006-03-09, 8:23 pm |
| Yes. You can hijack the sample DMO code that comes with SQL and alter it to
script out your objects to a text file using a win32 DTS task scheduled in a
job..
"Billy Leung" wrote:
> Hi,
>
> To generate SQL script, we can right click the database in SQL Server
> Enterprise Manager. But is there any way that I can schedule to generate
> this script automatically?
>
> Thank you for your help, and any feedback will highly appreciated.
>
>
> Billy
>
>
>
|
|
|
|
|