Potentially pain-free migration
There are two steps to a SQL Server migration; the database itself and apps built on the database. If it's just the database, that's a whole lot faster than a Server upgrade, says O'Connor. "Just migrating the SQL engine is a two-hour process. You can move the engine and point back to data on a SAN. When it becomes apps that talk to database, that can take time," he notes.
Turley says Microsoft tools like SQL Server Upgrade Advisor and Installation Center make it simple to install and migrate the product, plus analysis and reporting services migrate. For SQL Server 2014, there is an ISV certification program so you can test your custom database apps against 2014 to help with the move.
"Let's say they use Web services and custom extensions. We can migrate a lot of those things. In general there is a lot of prescriptive guidance around making that migration. It all depends on how custom that install is," he says.
If there is a challenge, it could be finding a skilled DBA who knows how to use the old versions. DBAs trained in recent years haven't been trained on the 2005 version and earlier. "Most new DBAs have never even seen SQL Server 2000. Finding a junior to mid-level DBA to support it can get challenging quickly," says Turley.
Sign up for CIO Asia eNewsletters.