在 TFS 2008 中创建 Visual Studio 数据库项目
我正在开发 Visual Studio 数据库项目，我已经从数据库服务器导入了现有的数据库架构，将我的数据库项目作为沙箱，以便无论谁更改它，都应该在提交到数据库服务器之前在本地完成。
接下来，我使用数据生成计划（使用顺序数据绑定生成器）创建了数据，因为我们的项目需要一些表（主表和初始化）的数据。
我也能够实现这一点，现在为了将数据库部署到另一个系统或 PC，我必须更改项目属性下的部署选项卡的连接字符串。
成功部署后，我发现只创建了数据库，但数据库生成尚未运行，我发现这是因为我为数据生成计划中的每个表提供的连接字符串（因为顺序数据绑定生成器）。
现在有没有办法在顺序数据绑定生成器的一个常见位置更改连接字符串，因为我有近 42 个表，并且对于每一列，我需要更改连接字符串才能插入数据。
提前致谢
I am working on Visual Studio Database Project,i have imported existing Database Schema from Database Server, made my database project as sand box so that whoever ever changes it,it should be done locally before committing to Database Server .
Next i have created data using Data Generation Plans(Using Sequential Databound Generator) , since our project need to have data for some of tables ( Master and Initialize).
I am able to achieve this as well, now in order to deploy the database into another system or P.C., i have to change connection string of Deploy tab under project Properties.
After successful deployment i came to know that only database got created, but database generation has not ran, i figured out it's because of the connection string i had provided for each tables in Data Generation Plans(because of Sequential Datbound Generator).
Now is there any way to change the connection string in one common place for Sequential Databound Generator, because i have nearly 42 tables and for each column i need to change the connection string in order to insert the data.
Thanks in advance
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
虽然我是 TFS 中这个数据库项目的新手，为了在部署期间插入数据，您需要在 scripts 文件夹下的 Script.PostDeployment.sql 中添加一些脚本，在我们的如果我们有超过 42 个表来插入数据，而不是提及我使用过 SQLCMD 命令的所有 INSERT 脚本，您需要提及包含各种表的 INSERT 查询的 .SQL 文件，例如
在部署期间，上述查询将被附加使用 SQLCMD 实用程序。
though i am new to this DB proj in TFS, in order to insert data during deployment you need to add some script in Script.PostDeployment.sql under scripts folder, in our case we have more than 42 tables to insert data, instead of mentioning all INSERT scripts i have used SQLCMD commands there you need to mention the .SQL file which has INSERT queries for various tables, for example
during deployment the above query will be appended along with SQLCMD utility.