DDL Extractiongreenspun.com : LUSENET : SQL Server Database Administration : One Thread
I want to know , is there any way to extract schema information , other that Enterprise Manager method ? I want to create a job which will extract DDL every night .
Please let me know .
-- Anonymous, July 29, 2002
You can schedule a CmdExec jobstep launching c:\mssql7 \upgrade\scptxfr.exe. (The path to this file may be different on your server.)
You can see the documentation for this by typing:
on the command line in the directory containing scptxfr.exe.
Hope this helps,
-- Anonymous, July 31, 2002