• I know you stated you did not want to use third party tools, but I am assuming that is because of cost. So, visit http://www.quest.com and download their free database comparison tool for SQL Server.

    Once installed, create a new blank database then start your comparison. Select your current report server as the source and this new blank database as the destination. The comparison tool will build all of the scripts necessary to synchronize the schema in both databases.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs