CODEWITHSUNDEEP
sql-server-2008ssissql-server-express
Thomas
Thomas

Reputation: 5998

Installing SQL Server 2008 R2 Standard/Enterprise when Express is installed

I have SQL Server 2008 R2 Express with advanced services installed on my computer. I tried creating an SSIS package today and found out that the express edition does not support it.

Can I install Standard/Enterprise and have Express and Standard/Enterprise live happily on my development machine or do I need to uninstall Express?

Thanks

Upvotes: 1

Views: 1176

Answers (1)

driis
driis

Reputation: 164301

Yes.

You can either install a new instance so you have both a Express and Standard instance on the machine; or you can upgrade your Express instance to Standard/Enterprise. If the option to upgrade the SKU is not visible in setup then run setup.exe with SKUUPGRADE=1 on the command line.

Upvotes: 1

Related Questions