在SQL Server中存储数据库架构版本的最佳实践？

I have an app which will be deployed on production PCs with SQL Server. I want to be able to store and retrieve a version of the schema in my database. I'm interested in best practices to be able to accomplish this, with the following main goals:I have an app which will be deployed on product