SQL 2000 和 SQL 2008 Express 并存?
这个问题是关于 2005 年提出的,但没有看到 2000 年的任何内容。我们有一个新的应用程序需要在 2005 年或更好的版本上运行,但我们拥有的其他一切都是针对 2000 年的。我们可以升级,但这不在范围内此时的预算。
我们认为,在升级之前,我们可以在与 2000 相同的服务器上运行 SQL Server 2008 Express 一段时间。
有人这样做吗? 有什么问题吗? 确定可以继续吗?
提前致谢
This question has been asked in regards to 2005, but did not see anything with 2000. We have a new application that needs to run on 2005 or better but everything else we have is geared towards 2000. We could upgrade, but that is not within budget at this time.
We were thinking we could run SQL Server 2008 Express on the same server as 2000 for the period of time it takes before we upgrade.
Anyone do this?
Have any issue?
Ok to proceed?
Thanks in advance
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
在我们的开发服务器上,我们安装了很多版本,例如:2000、2005 Express、2005 标准、2008 Express,我们没有遇到任何重大问题。
当您完成安装过程时,您需要将它们安装为命名实例,例如:
MyServer\SQL2000
MyServer\SQL2005Express
MyServer\SQL2005
等等
我不建议在生产机器上运行这么多版本或实例,但在将其他应用程序升级到 2005 之前运行 2 个实例应该没有问题。
On our development server we have lots of versions installed eg: 2000, 2005 Express, 2005 standard, 2008 express we haven't had any major problems.
You will need to install them as named instances when you go through the installation procedure, eg:
MyServer\SQL2000
MyServer\SQL2005Express
MyServer\SQL2005
etc
I wouldn't advise running this many versions or instances on a production box but 2 instances until you upgrade your other applications to 2005 should be no problem.
我有一台运行 sql2000 和 2005 的服务器,而且我没有遇到任何问题 - sql2005 正在运行一个单独的实例。
我认为继续进行没有问题。 我遇到的唯一问题是 2005 Express 没有 DTS/SSIS,因此获取数据很麻烦,但这与运行两者无关:-)
I have a server that runs both sql2000 and 2005 and i have had not problems whatsoever - sql2005 is running a seperate instance.
I see no problems with proceeding. The only issue i've had is 2005 express does not have DTS/SSIS so getting data in is cumbersome, but that has nothing to do with running both :-)