Solid Quality Mentors Migrates Payvision to SQL Server 2008 with Only 4 Seconds of Database Downtime

MADRID--()--Payvision, an international payment solutions provider, migrated to SQL Server 2008 with only 4 seconds of database downtime, thanks to Microsoft Gold Certified Partner Solid Quality Mentors.

“The critical phase was changing database mirroring roles between SQL Server 2005 and SQL Server 2008 servers”

Headquartered in Amsterdam with offices in New York, the UK, Singapore, and Madrid, Payvision specializes in multicurrency processing for card-not-present electronic transactions, securely processing exchange transactions in over 150 currencies for all credit card companies.

Payvision’s payment infrastructure is based on Microsoft technologies, from the IIS and .NET-based Web front end through which customers can see detailed transaction status to the SQL Server-based transaction manager. The company was especially interested in SQL Server 2008’s high availability enhancements, data and backup compression, and table-partitioning features.

However, Payvision’s challenge was migrating to SQL Server 2008 while continuing to provide 24x7 customer support. For a safe, reliable, and rapid migration plan with the lowest impact on its system, solutions, and customers, Payvision CTO Jose Fco Bonnin contacted Solid Quality Mentors, authors of the SQL Server 2008 Upgrade Technical Reference Guide and a trusted, global provider of advanced solutions and education for the Microsoft Data Platform.

Payvision’s new SQL Server 2008 configuration required:

  • Database servers in a Microsoft Windows Clustering implementation
  • Reporting servers as subscribers to transactional replication from OLTP servers
  • Warm stand-by servers in asynchronous database mirroring mode from OLTP servers

The migration project began with HA solution design, moved through system and application performance testing and configuration, and concluded with the migration itself and key post-migration tasks.

"The critical phase was changing database mirroring roles between SQL Server 2005 and SQL Server 2008 servers,” said Solid Quality Mentors’ Ruben Garrigós. “By using different threads to fail over multiple databases in parallel, we were able to migrate large databases in just 4 seconds."

See the full case study for details.

Solid Quality Mentors

Since its founding in 2002, Solid Quality Mentors has become a trusted global provider of advanced solutions and education for the Microsoft Data Ecosystem. Our mentors are located around the world and include over 40 Microsoft MVPs and seven Microsoft Regional Directors. Our experts work daily with the Microsoft SQL Server, Business Intelligence, and .NET Development platforms to help you take advantage of the latest features for database and application deployments. Learn more at www.SolidQ.com.

Contacts

Solid Quality Mentors
Kathy Blomstrom, 970-630-3404
kblomstrom@solidq.com

Website

Release Summary

Payvision, an international payment solutions provider, migrated to SQL Server 2008 with only 4 seconds of database downtime, thanks to Microsoft Gold Certified Partner Solid Quality Mentors.

Solid Quality Mentors