Can you run multiple versions of SQL Server on a development machine?
Hello - I just re-loaded my laptop with Windows 7; I am supporting and developing app's that use Access 2003 & SS 2000, ASP.NET 2.0 and SS 2005, and I am about to start a project that will use ASP.NET 4.0 and SS 2008.
Are there any problems running these 3 versions together? Anything I should or shouldn't do?
Thanks
Are there any problems running these 3 versions together? Anything I should or shouldn't do?
Thanks
Anthony Perkins
You can. Is performance going to suffer? Probably.
yes, it will work but unless you have dual 6 cores and 32 gig of ram its going to be slowwwwwwwwwww LOL
ASKER
I'm not talking about running them at the same time; just having them all on my development pc.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>I'm not talking about running them at the same time; just having them all on my development pc. <<
And how do you propose doing that? Were you planning on stopping and starting the service every time?
>>SQL Server 2000 and SQL Server 2008 can not be installed together. <<
Really? Any documentation to back that up?
And how do you propose doing that? Were you planning on stopping and starting the service every time?
>>SQL Server 2000 and SQL Server 2008 can not be installed together. <<
Really? Any documentation to back that up?
But perhaps we need to backup here and ask for clarification. If you are planning on installing just the client components of SQL Server and are connecting to remote servers, than you should be fine. However, if you are planning on installing all three SQL Server Engines than performance could suffer and you would be very wise to limit the max memory used by each instance.
ASKER
I have always started the 2000 engine manually, when there was something I needed to do on that app, and I never noticed any performance issues with just 2000 & 2005.
2008 is a new thing; I never had all 3 going on the same machine before; I guess I will start to the performance hit if/when I add 2008.
2008 is a new thing; I never had all 3 going on the same machine before; I guess I will start to the performance hit if/when I add 2008.
acperkins:
The reason it is not advisable to be installed on a same machine because instances needs to be rename to avoid problems, otherwise people having this kind of setup will have problems in a long run.
There are no documents to support it now, but in a production environment are you willing to risk having this kind of setup? (OT)
The reason it is not advisable to be installed on a same machine because instances needs to be rename to avoid problems, otherwise people having this kind of setup will have problems in a long run.
There are no documents to support it now, but in a production environment are you willing to risk having this kind of setup? (OT)
>>The reason it is not advisable to be installed on a same machine because instances needs to be rename to avoid problems<<
Why would you rename an instance? Or more appropriately how would you propose doing that?
>>but in a production environment are you willing to risk having this kind of setup?<<
You need to re-read the question. This is not for a production environment: "I am supporting and developing app's".
Why would you rename an instance? Or more appropriately how would you propose doing that?
>>but in a production environment are you willing to risk having this kind of setup?<<
You need to re-read the question. This is not for a production environment: "I am supporting and developing app's".
ASKER
I tried to install SS 2000 in W7, and got a "known compatibility issues" error message, so I guess that solves THAT issue; I've already got XP Mode going, so 2000 will just have to live on that "machine"
I was already doing most of the 2005 work on that clients' network over a VPN connection; I think I will stick with that
That just leaves 2008, which I will install on W7, and everything will live in peace & harmony, and I won't have any problems, again, ever... bah-ha-ha-hahhhhhh....
Thanks, guys
I was already doing most of the 2005 work on that clients' network over a VPN connection; I think I will stick with that
That just leaves 2008, which I will install on W7, and everything will live in peace & harmony, and I won't have any problems, again, ever... bah-ha-ha-hahhhhhh....
Thanks, guys