Tuesday, March 20, 2012

Problems bringing up Project REAL

Most of the installation went well. I got to the point of attaching the

source database, but had problems attching the warehouse database:

Database 'REAL_Warehouse_Sample_V6' cannot be started in this edition

of SQL Server because it contains a partition function 'pf_Range_Fact'.

Only Enterprise edition of SQL Server supports partitioning.

I am running standard edition at mey development workstation, the only

one we have running. I do not necessarily need to see partitioning

working. But sounds like I will need to install Enterprise edition at

my development computer to go down this path of discovery? Anyone been

able to do otherwise?

Is there any way to get in and look at the stored procedures at least, or schemas?

Even after going back, it was not clear to me from the prerequisit list that Enterprise edition was required for this.Developer Edition would work as well. Simply a $50 fee for that.|||Yes, it works!

Edition upgrade sucks. I've done it twice, two different ways, and each time it trashes SQL installation. Both times I ended up doing a complete uninstall, and then install. So really the edition upgrade was a wasted diversion of time.

No comments:

Post a Comment