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

Answers

Shrinivas,

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,

Eric

-- Anonymous, July 31, 2002