Costpoint 7 Schemas: Who Are You?
As the Olympics wrap up this weekend, I’m looking forward to not only the Men’s Basketball Gold Medal game featuring (hopefully) Team USA on Sunday, but also the closing ceremonies. The closing ceremony is commonly overlooked, but normally just a notch below the opening ceremony on the spectacle scale. And who has London booked to send the Olympics out with a bang? None other than The Who.
I’ve been flipping through my Who catalog in anticipation for Sunday and landed on “Who Are You” this morning. Which reminds me – Costpoint 7 databases, who are you?
Now, it’s important to note that the role of the database server in Costpoint 6 remains the same in Costpoint 7. Fundamentally, the Costpoint database, now called the “Transaction Schema”, has a few more tables and a bunch more columns. The major tables that we’ve come to know and love, however, are still there and intact.
But, if you weren’t running the web version of CP 6, the Costpoint 7 upgrade introduces two new schemas that you’re probably unfamiliar with. One of the new schemas, Metadata (System), primarily contains the code for the application. The other new schema, Admin, stores the new security infrastructure, user profile, and personalized preference data.
All three schemas can be deployed in a single database, typically the recommendation for smaller installations. For larger deployments, each schema can reside in its own database. It is also possible to have a single metadata database server multiple admin/transactional schema pairs.
But schemas aren’t the only change. Costpoint 7 only supports 64-bit databases running on 64-bit operating systems. 32-bit operating systems and databases, like SQL Server 2005 and Windows 2003, are not supported by Deltek Costpoint 7. Unless you are already using this technology (and most aren’t), it’s going to be a significant investment to upgrade your infrastructure in order to support CP7.
While you’re weighing your options for upgrading to 64-bit technology, consider moving Costpoint 7 to the cloud. You’ll avoid infrastructure upgrade costs while getting all the advantages of a secure, private cloud featuring Costpoint 7.
Check back later this week when we’ll tackle an age old argument – SQL Server or Oracle? – so you won’t get fooled again.