SQL Server 2005和2008在同一个开发人员机器上？

Has anyone tried installing SQL Server 2008 Developer on a machine that already has 2005 Developer installed?

有没有人尝试在已经安装了2005 Developer的机器上安装SQL Server 2008 Developer?

I am unsure if I should do this, and I need to keep 2005 on this machine for the foreseeable future in order to test our application easily. Since I sometimes need to take backup files of databases and make available for other people in the company I cannot just replace 2005 with 2008 as I suspect (but do not know) that the databases aren't 100% backwards compatible.

我不确定我是否应该这样做,并且我需要在可预见的将来将2005年保留在这台机器上,以便轻松测试我们的应用程序。由于我有时需要获取数据库的备份文件并可供公司中的其他人使用,因此我不能仅将2008替换为2008,因为我怀疑(但不知道)数据库不是100%向后兼容的。

What kind of issues would arise? Do I need to install the new version with an instance name, will that work? Can I use a different port number to distinguish them?

会出现什么样的问题?我是否需要安装带有实例名称的新版本,这有用吗?我可以使用不同的端口号来区分它们吗?

I found this entry on technet: http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3496209&SiteID=17

我在technet上找到了这个条目:http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID = 3496209&SiteID = 17

It doesn't say more than just yes you can do this and I kinda suspected that this was doable anyway, but I need to know if there are anything I need to know before I start installing.

它不仅仅是肯定你可以做到这一点,我有点怀疑这是可行的,但我需要知道在开始安装之前是否有任何我需要知道的事情。

Anyone?

7 个解决方案

#1

Yes this is possible. You will have to create a named instance not used by another version of SQL Server as per the previous answer and version 3.5 of .Net installed. Works great!!

是的,这是可能的。您必须创建一个未被其他版本的SQL Server使用的命名实例,如前面的答案和安装的.Net 3.5版本。效果很棒!!

Here the list of prerequisites:

这里列出了先决条件:

.NET Framework 3.5 SP1

.NET Framework 3.5 SP1

Windows Installer 4.5

Windows Installer 4.5

Windows PowerShell 1.0

Windows PowerShell 1.0

#2

If you have Visual Studio 2008 installed you will get a validation error and you cannot install SQL server 2008 until you install Visual Studio 2008 SP1. If you don't have Visual Studio 2008 installed it should not be a problem. So if you do have Visual Studio 2008 wait till August 11th since that is the day that Visual Studio 2008 SP1 will ship

如果安装了Visual Studio 2008,则会出现验证错误,并且在安装Visual Studio 2008 SP1之前无法安装SQL Server 2008。如果您没有安装Visual Studio 2008,它应该不是问题。因此,如果您确实拥有Visual Studio 2008,请等到8月11日,因为那是Visual Studio 2008 SP1发布的那一天

#3

I believe that this is perfectly possible. I am currently running both SQL Server 2000 and SQL Server 2005 on my development server while I transfer applications over.

我相信这是完全可能的。我正在我的开发服务器上运行SQL Server 2000和SQL Server 2005,同时我转移应用程序。

The only thing you will have to do is create a new instance which isn't already being used by SQL Server 2005.

您唯一需要做的就是创建一个SQL Server 2005尚未使用的新实例。

As with anything new, there will probably be some bugs, however, it should generally "just work".

与任何新东西一样,可能会有一些错误,但是,它通常应该“正常工作”。

#4

my experience is after having sql sever 2005 and 2008 on same machine SSIS 2005 does not work properly... specially with script task, data flow and sequence container

我的经验是在同一台机器上安装sql sever 2005和2008之后SSIS 2005无法正常工作...特别是脚本任务,数据流和序列容器

#5

You could run just SQL 2008 as the single instance and then attach/create databases with compatability level of 2005? The problem with that is that its a theory. Im not 100% positive that if you create a database on 2008 , with a compatability level of 2005, and then detach it, that a SQL 2005 instance is capable of attaching it.

您可以只运行SQL 2008作为单个实例,然后附加/创建具有2005年兼容级别的数据库?问题在于它是一个理论。我不是百分之百肯定的,如果你在2008年创建一个数据库级别为2005,然后分离它,那么SQL 2005实例能够附加它。

I think its a good enough chance to try though. But I agree with the previous answers, the multiple instance options will work fine.

我认为它有足够的机会尝试。但我同意以前的答案,多个实例选项将正常工作。

#6

Unfortunately, it seems SQL Server 2008 Client Tools requires Visual Studio 2008 SP1, and I'm loath to install a beta of this on my main development machine.

不幸的是,似乎SQL Server 2008客户端工具需要Visual Studio 2008 SP1,我不愿意在我的主开发机器上安装这个测试版。

I'll wait until SP1 is RTM before I move on.

在我继续之前,我会等到SP1是RTM。

Edit: Yes, I do have Visual Studio 2008 on this machine, but I'd like to avoid beta installations of debugger applications. They tend to dig themselves too deep in for my taste.

编辑:是的,我在这台机器上安装了Visual Studio 2008,但我想避免调试器应用程序的beta版安装。他们倾向于根据自己的口味深入挖掘自己。

#7

I have try it with negativ result. The 2k8 installation breaks with a mysterious error-message. The installation-protocol looks fine, but it will not work. After this the 2k5 installation was buggy too.The 2k8 installation was half-ready, so it´s already in controlpane / software, but uninstallation is not possible.

我试着用否定的结果。 2k8安装打破了一个神秘的错误消息。安装协议看起来很好,但它不起作用。在此之后,2k5安装也是错误的.2k8安装是半就绪的,所以它已经在控制面板/软件中,但是卸载是不可能的。

So my result - don´t do it on a productive server / workstation. If you need both versions, use a virtual machine instead.

所以我的结果 - 不要在高效的服务器/工作站上进行。如果您需要两个版本,请改用虚拟机。

#1