問題描述
有沒有辦法在VS 2010的數據庫項目中使用數據生成計劃來創建一組默認數據?或者我是在吠錯樹，即數據生成計劃最適合創建虛擬示例數據嗎?
Are there way to using data generation plans in VS 2010's database projects to create a set of default data? Or am I barking up the wrong tree i.e. are data generation plans best suited to create dummy example data?
我們有一堆數據(默認設置、默認用戶等)需要為每個數據庫部署創建.如果有工具可以幫助我們解決這個問題，那就太好了，這樣就可以進行源代碼控制和更好的管理.
We have a bunch of data (default settings, default users etc etc) that needs to be created for each database deployment. It would be nice to have tooling to help us with this, so it can be source controlled and better managed.
我猜可能有第三方替代品，但我希望有一個內置的 Visual-Studio-Way 做事方式，因此它可以與 TFS 等很好地集成.
I'm guessing that there are probably third party alternatives, but I'm hoping there is a built-in Visual-Studio-Way of doing things, so it can integrate nicely with TFS etc.
推薦答案
可能有不同的方法來做到這一點，但基本的是:
There are probably different ways to do this, but the basics are to:
- 創建一個插入默認數據的腳本
- 編輯 Script.PostDeployment.sql 腳本以使用您的腳本插入默認值
例如，我在項目的 Scripts->Post-Deployment 文件夾下創建了一個新文件夾 DefaultData，并在此處添加了用于插入默認數據的腳本 InsertDefaultData.sql.然后，我將以下行添加到 Script.PostDeployment.sql ":r ..\DefaultData\InsertDefaultData.sql".
For example, I created a new folder, DefaultData, under the Scripts->Post-Deployment folder of my project and added my script for inserting the default data here, InsertDefaultData.sql. Then, I added the following line to Script.PostDeployment.sql ":r ..\DefaultData\InsertDefaultData.sql".
這篇關于在 Visual Studio 數據庫項目/SQL Server 中創建默認數據的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！