Retrieving a SQL Server 2005 Database Structure in XML

Question

This is what I know, can be done in some way, because I did it before, but I can’t let my life remember how.

I want to export the SQL Server database structure to an XML file. The one that I had last time, we did it with this structure:

<Data>
    <Details>
        <Server>Server Name</Server>
        <Database>Database Name</Database>
    </Details>
    <Tables>
        <Table>
            <Name>Table Name</Name>
            <Columns>
                <Column>
                    <Colname>Column Name</Colname>
                </Column>
            </Columns>
        </Table>
    </Tables>
    <Procedures>
        <Procedure>
            <Name>Procedure Name</name>
            <Definition>Full text of script</Definition>
        </Procedure>
    </Procedures>
</Data>

... Etc. Does anyone know where to find this option?

Answer 1

Yeah. In the end, it was not a built-in function - we use SQL Delta ( http://www.sqldelta.com/ ), and its "Snapshot" function is what it was b.

Answer 2

DatabaseSpy 30- .

: , SSIS, XML .