DDL Extraction

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hi Eirc

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:

scptxfr /?

on the command line in the directory containing scptxfr.exe.

Hope this helps,


-- Anonymous, July 31, 2002

Moderation questions? read the FAQ