Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2004
    Posts
    24

    Unanswered: extracting DDL's in SQL Server

    I really apprciate any idea's

    On extracting ddl's for each object on a separate file in SQL Server?

    Something like ddl's for:
    procedure1.sql, procedure2.sql.....so on procedure100.sql
    onto a file server.

    Does SQL Server has any API's like Oracle's dbms_metadata?

    Or can we use SQL enterprise manager to do this job?

    Thanks, Madhavi.

  2. #2
    Join Date
    Oct 2003
    Posts
    84
    In Query analyser, you can right click on most objects in the object browser
    and select "Script object to" and choose your reference.....


    In enterprise manager you can right click on a DB and select "Generate SQL Script"...from there a window appears where you can choose what object types to script (Tables/UDF/Stored procs/User defined types...)

  3. #3
    Join Date
    Aug 2004
    Posts
    24
    Thanks

    How can I automate this process? As, I will have to schedule this process to run daily.

    Madhavi.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'd use SQL-DMO.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •