Managing multiple database platforms has become the norm rather than an exception for database administrators (DBAs) according to database tools vendor Embarcadero. The company's latest database trends survey that shows 72% of DBAs manage at least two types of database management systems. Of those surveyed, 20% reported managing one database platform, 33% said they manage two, 25% said three, 8% said four, and 14% said they manage five or more.
Microsoft SQL Server and Oracle were cited as the most common database platforms, with 62% of respondents working with SQL Server and 60% with Oracle. Third on the list was Sybase Adaptive Server Enterprise with 35%, and Microsoft Access earned 19%. Oracle ranked tops as the database platform that respondents work with primarily.
Exacerbating the multi-platform database situation is the fact that most DBAs are also tasked with managing multiple versions of a database, adding another layer of complexity to their responsibilities and creating more room for error. According to the survey, 69% manage more than one version of the same database and, of those that do, 51% said they manage three or more versions of the same database platform.
“Each database platform and version has its own features and functionality, and keeping them all straight can be a monumental task for DBAs,” said Scott Walz, senior director of product management for Embarcadero. “Multi-platform database management is becoming more commonplace, but that doesn’t mean it’s getting less complicated.”
Although the vast majority of DBAs said they are proficient with more than one database platform, they believe the variables of multi-platform environments will put their skills to the test. When asked to name the single biggest database-related challenge facing them in the next year, the greatest number of respondents said cross-platform database management. Multi-instance databases and tuning tied for second place, followed by database management in third.
The more than 1,200 survey respondents were a mixture of DBAs, developers, architects, and analysts. The survey results and additional information are available online here.