1. I have a creation script for a SQL Server database and beside it I have a test script
2. My test Script should compare the result of my original script and the database and let me know if it is a match
3. I need to store the resulting script in a repository.

I've already got a script and the database. It's not hard to write the test script, but I want an app that automates the process.

I've already got Redgate tools and I heard it can make the job for me, but how? If not, are there any other tools that could do such a thing?