1

I have an application running on SQL Express SQL 9.0. Are there any known problems installing a Development Edition of MS SQL Server 2008 R2 along side SQL Express? In other words, is there a known problem having two different flavors of SQL Server installed? Is the Development edition treated like a second instance?

I know you can have multiple instances of SQL Server, with only one instance allowed as the unnamed or default instance. I'm just curious if anyone knows of a gotcha.

Thanks.

octopusgrabbus
  • 175
  • 5
  • 20

1 Answers1

2

Aside from the normal cautions and warnings about a side-by-side SQL installation, there are no "known issues" as a result of doing a side-by-side installation between SQL Express 9 and SQL Server 2008 R2.

This guy's done it without issue, as have I, though with different versions. Pretty sure it was SQL Express 2005 and SQL 2008 (100)/R1 in my case.

EDIT:

Since you've updated the question, I'll do the same... the Developer Edition will be treated exactly like a second instance (because that's what it is), and the general use-case of a side-by-side MSSQL installation is to have different versions of MSSQL. Because, for example, in my case, our #$^@ing employee time-keeping software is shackled to MSSQL 2000, while the rest of the world has moved on, and requires a higher version of MSSQL. So one of our [production] SQL servers has MSSQL 2000 and MSSQL 2008 on it in a side-by-side installation.

HopelessN00b
  • 53,385
  • 32
  • 133
  • 208
  • Thanks. I'm trying not to screw up a production environment running Wasp Barcode Inventory Control. Since it's a public works server and we're short of SQL server space, I've got a license that will cover two people. – octopusgrabbus Aug 28 '12 at 19:46
  • Just another point but remember the developer edition is not licensed for production use (last time I checked). SQL Express however is. – Brent Pabst Aug 28 '12 at 19:49