• whoops

    i thought you said schema, not data!

    Red gate's data compare does it quite well, and the tablediff utility is worth investigating...

    Atlantis Interactive - SQL Server Tools
    My blog[/url]
    Why I wrote a sql query analyzer clone