我已阅读有关迁移升级到不同服务器的 Microsoft 文档。我们当前的设置使用我们不再需要的 SharePoint 2.0，并且是在 SQL Server 2005 上。
建议的步骤提到备份现有数据库并将它们恢复到 SQL Server 2008。我猜这些帐户不会包含在其中？
我的问题是：是否可以使用 VS 2010 中的数据库发布向导来编写现有 SQL Server 2005 DB 的脚本并将其定位到 SQL Server 2008（使用向导中的下拉列表）？我知道该向导通常包含所有安全信息，但我不确定这种类型的迁移是否支持这种方法，而且我找不到任何现有文档甚至提到数据库发布向导的使用。有人吗？
I have read the Microsoft documentation on a migration upgrade to a different server. Our current setup uses SharePoint 2.0 which we will no longer need, and is on SQL Server 2005.
The recommended steps mention backing up the existing databases and restoring them to SQL Server 2008. I'm guessing that the accounts would not be included in this?
My question is this: would it be possible to use the Database Publishing Wizard within VS 2010 to script the existing SQL Server 2005 DBs and target them for SQL Server 2008 (using the drop down list within the wizard)? I know that the wizard usually includes all security info but I'm not sure if this approach is supported for this type of migration and I can find no existing documentation which even mentions the use of the Database Publishing Wizard. Anyone?
发布评论
评论（1）
根据您的设置，您可能需要将 SQL 登录添加到新服务器。但我认为数据库发布向导不会帮助您完成此任务。
有关如何进行升级的详细说明，请参阅：http://blogs.msdn.com/b/wlennon/archive/2009/12/02/upgrade-tfs-2010-from-tfs-2005-or-tfs-2008.aspx
Depending on your setup, you may need to add the SQL Logins to the new server. But I do not think that the database publishing wizard would help you with that.
For a good description of how to do the upgrade see: http://blogs.msdn.com/b/wlennon/archive/2009/12/02/upgrade-tfs-2010-from-tfs-2005-or-tfs-2008.aspx