创建有效的SQL脚本以生成SQL服务器数据库

I'm working on testing an application that utilizes a SQL Server database. For testing purposes, I'd really like to be able to utilize an in-memory database, like HSQL. I actually have my tests running but I have one pain point still outstanding - I have a difficult time generating a SQL script that I can use to build my HSQL database. As this system is still in development, database changes can and do happen so I don't want to spend all my time manually updating SQL scripts.I'm working on testing an application that util