How to synchronize SQL Server 2008 database with SQL Server 2005 database?

I am using VS 2008 Team Suite and SQL Server 2008 in my development environment. I am deploying to a shared-host website with shared-host SQL Server 2005.

I want to push changes from my development 开发者_JAVA技巧environment to my production host.

I tried using Data | Schema Compare... and it reports to me that it does not support SQL Server 2008.

What do people use for this (Besides Red-Gate tools - I use those at my day job, and they rock...this is a volunteer thing for my son's school)?

I am looking for something very inexpensive if not free.

Downgrade the development environment is my advice -- I use the management studio and script everything by hand directly, or often just generate the scripts and trim them by hand. Tools are dangerous.

Once you know T-SQL backwards and forwards (every little under-the-hood or non-obvious way of doing something) a tool is just a shackle.

If this is a one-time thing, why not just use a demo version of Red Gate's comparison suite?

If you have Visual Studio 2008 Team Suite or Database Edition, Microsoft has a patch for this, "Microsoft® Visual Studio Team System 2008 Database Edition GDR R2," which you can download from msdn. You'll have to close Visual Studio to do the install, but that's really about all the hassle that's involved.

Brief Description: "Microsoft® Visual Studio Team System 2008 Database Edition GDR R2 implements support for SQL Server 2008."