I'm looking at using Sql Server Database projects. It appears to import schema and stored procedures from a database, but there's no mechanism to import actual data. As part of our build process, we usually import both schema and data.
我正在寻找使用Sql Server数据库项目。它似乎从数据库导入模式和存储过程,但没有导入实际数据的机制。作为构建过程的一部分,我们通常会导入架构和数据。
Can this be done from Sql Server Database projects?
可以从Sql Server数据库项目完成吗?
1 个解决方案
#1
6
The current solution is to place reference data use a post-deployment script. The script must be written to be idempotent as it has no knowledge of the state of the target. This is described in detail here:
当前的解决方案是使用部署后脚本放置参考数据。必须将脚本编写为幂等的,因为它不了解目标的状态。这在这里有详细描述:
Including Data in a SQL Server Database Project
在SQL Server数据库项目中包含数据
#1
6
The current solution is to place reference data use a post-deployment script. The script must be written to be idempotent as it has no knowledge of the state of the target. This is described in detail here:
当前的解决方案是使用部署后脚本放置参考数据。必须将脚本编写为幂等的,因为它不了解目标的状态。这在这里有详细描述:
Including Data in a SQL Server Database Project
在SQL Server数据库项目中包含数据