Post reply

DTS Import/Export Wizard - Generate DDL - Data Dictionary tool

  • September 21, 2004 at 1:48 pm

    #163204

    How does the DTS Import/Export wizard create the DDLs for the destination database?

    I am trying to create a cross platform data dictionary tool and want to be able to do something very similar.  i.e. point it to a driver or DSN and pull back a DDL. (or actually an XML version of the database schema would be even better.)

    Any suggestions for tools/utilities that will generate an xml document for a given database structure?


    "I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
    (Memoirs of a geek)

  • September 22, 2004 at 4:37 pm

    #524084

    Hello,

    I don't know of any TP tools, but with .NET that probably would be easy, what you could do is use the INFORMATION_SCHEMA.COLUMNS table to retrieve the database information, and encode it in XML using the XML objects or the dataset object (which is the easiest by far, only need to do a WriteXML and your done).

    You could use other means, such as VB6, ASP, or vbscript.

    Brian

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply