什么是开发环境的最佳SQL Server设置？ [英] What's the best SQL Server setup for a development environment?

问题描述

我们是一个小型团队，使用Visual Studio 2008进行开发，并在生产服务器中使用SQL Server 2008 Standard。我们正在建立一个新的开发实验室，我想知道SQL Server的版本/版本和配置。

We are a small team using Visual Studio 2008 for development and SQL Server 2008 Standard in the production servers. We are seting up a new development lab and I am wondering about SQL Server versions/editions and configuration.

Visual Studio 2008附带了SQL Server 2005的开发许可证，但是由于我们仅将SQL Server 2008用于生产，所以我认为我们不应该在开发工作站上安装SQL Server 2005，对吗？您是否建议跳过捆绑的SQL Server 2005，而选择SQL Server 2008 Developer？还是SQL Server 2008 Express？

Visual Studio 2008 comes with a development license of SQL Server 2005, but since we are only targetting SQL Server 2008 for production, I don't think we should install SQL Server 2005 on the development workstations, right? Would you suggest skipping the bundled SQL Server 2005 and going for, perhaps, SQL Server 2008 Developer? Or maybe SQL Server 2008 Express?

或者您是否建议完全不在开发工作站上安装SQL Server，并针对开发服务器进行所有开发？

Or would you recommend not installing SQL Server on the development workstations at all, and doing all the development against a development server?

您的意见受到赞赏。谢谢！

Your views are appreciated. Thanks!

推荐答案

与其他许多答案一样，我将推荐SQL Server 2008 Express。但是，我将提出另外两个建议：

I'm going to recommend SQL Server 2008 Express like many of the other answers. I will, however, make two additional recommendations:

• 将数据库模式保留在版本控制中。开发人员将能够轻松地将其他开发人员的架构更新应用于他们计算机上运行的开发数据库。每当您签出源代码以确保您正在运行最新的数据库模式时，都将执行此操作。

• Keep your DB schema in version control. Developers will be able to easily apply schema updates from other developers to the development databases running on their machine. This would be done whenever you check out your source code to make sure you're running the latest DB schema.

在中间添加一个登台服务器，反映您的生产环境。

Add a staging server in the middle that exactly mirrors your production environment.

这篇关于什么是开发环境的最佳SQL Server设置？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！