SQL Server 2008 Express 可以与 SQL Server 2000 共存于同一服务器上吗?
我想知道是否有人有尝试将 SQL Server 2008 Express 与 SQL Server 2000 一起安装的经验。我们有一台运行 2000 的生产服务器,我们当前的所有内容都在其上运行。 然而,使用 SQL Server 2008 Express 的新功能正在酝酿之中。
到目前为止,谷歌并没有给我带来任何具体的信息。 2008 年的预览版中明显有一个“否”,但没有任何关于 RTM 2008 的内容。
我可以尝试安装它,但在这样做之前想尽可能多地了解情况。 我可以看到 2008 安装失败,在此过程中消耗了 2000 个。
我的替代路径包括将 2008 数据库转换为 2000 格式(我想避免这种情况,因为我们只有 5 个连接许可证)和构建一个新服务器(我们已经有足够的连接许可证,这似乎有点矫枉过正)。 重做 2008 DB 是可行的,因为它没有使用 2008 年的任何新的出色功能。
虚拟化也可以是一种选择,但它还不太符合我们的文化。
这里的任何见解将不胜感激。
基思
I'm wondering if anybody has had any experience in trying to install SQL Server 2008 Express along side with SQL Server 2000. We have a production server running 2000 which all of our current stuff is running on. However, something new is in the pipeline that uses SQL Server 2008 Express.
Hitting Google thus far has given me nothing concrete. There was an obvious no from a preview release of 2008 but nothing about RTM 2008.
I could try installing it but would like to find out as much as I can before doing so. I can see the 2008 install failing, eating 2000 in the process.
The alternative paths that I have include having the 2008 db be turned into a 2000 format (which I'd like to avoid as we only have a 5 connection licenses) and building a new server (we already have enough and it seems overkill). Redoing the 2008 DB is viable as it doesn't use any new whiz-bang features from 2008.
Virtualization can be an option as well, but it's not quite in our cultural yet.
Any insights here will be appreciated.
Keith
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
是的,可以,如果 2000 版本是默认实例,则必须将 2008 版本设为命名实例
yes you can, you have to make the 2008 version a named instance if the 2000 version is a default instance