25 August 2017 Bill Ramos
DB Best recently completed a project to migrate Sybase ASE databases to SQL Server for a global leader in security technology. Faced with skyrocketing license costs with SAP to renew t...
WHY MIGRATE POWERBUILDER TO SQL SERVER?
Aging PowerBuilder applications present a number of risks for mission-critical systems due to the lack of high availability and disaster recovery capabilities. In addition, these applications are often running on declining hardware. Finally, the original PowerBuilder developers are likely long gone or retired, it’s very difficult to find someone who can support the upgrade process.
Microsoft SQL Server offers broader-based functionality and is more cost-effective than SAP ASE due to SQL Server’s “out-of-the-box” functionality (such as table partitioning, disaster recovery, high availability, encrypted columns, and full-text search), without requiring additional purchases.
Typical challenges that we see
Once I have migrated my database, how do I validate that it is working at full capacity?
Prior to the migration, you should have a good understanding of your database workload including any performance data and frequency of heavy load. The key to a proper comparison is a mechanism to replay a load. You can do this through Distribute Replay Controller or your own load harness.
Once under load, you can evaluate your new technology by monitoring pressure on CPU, Memory, IO Operations, and network traffic.
By monitoring the times the system is under pressure you can determine if your technology is properly sized.
DB Best can help you profile your existing environment and then grade your migration against that profile.
Migrating away from your current data solution
Traditionally, this means a switch from one data platform to another. However, just switching the nameplate on the back-end DB server may not be the best solution. Some data patterns and use cases may have a better fit for a NoSQL or Data Lake solution.
DB Best Architects are trained to spot these patterns and discuss with the customer another approach that may be a better fit or be able to leverage new technology such as IoT devices.
Learn more about migrating PowerBuilder to SQL Server
Contact us Why you can trust us with SAP ASE to SQL Server migration
The DB Best team has developed a unique methodology to migrate PowerBuilder to SQL Server that has been proven many times over with hundreds of positive customer experiences. Being an architect and the original creator of SQL Server Migration Assistant (SSMA) for SAP ASE, the DB Best team is THE database migration expert you can trust with your project.
Based on our vast migration experience, the DB Best team developed our in-house product Database Compare Suite, which greatly complements SSMA for SAP ASE.
SQL Server Migration Assistant (SSMA)
See how you can get the most out of SSMA from the company who originally created the tool for Microsoft.
DB Best Database Compare Suite
Comparing two production databases for migration or an upgrade? Now you can do this with one powerful and simple tool that every DBA and database developer needs.
Migrating SAP ASE databases to SQL Server to increase system's performance
Faced with skyrocketing license costs with SAP to renew their out-of-support server instances, our customer needed a way to migrate hundreds of SAP ASE databases. To make matters worse, our customer faced upgrading out of support PowerBuilder applications.
By migrating to SQL Server on commodity Intel-based servers, our customer found that they could exceed their performance needs and lower overall licensing costs. Check out the video to see how we approached the project to migrate SAP ASE databases to SQL Server.
Contact us
Learn more
We have a great set of blog posts and data sheets to help you better understand our capabilities as the leader in database migration services showcasing our expertise in moving SAP ASE workloads to Microsoft SQL Server and Microsoft SQL Azure.
Blog posts
Migrate Sybase ASE databases to SQL Server for a security technologies company
Using Sybase SQL Server application unification to reduce migration risks
14 March 2017 Bill Ramos
A financial service software provider needed to upgrade their customer facing applications to SQL Server while keeping their Sybase ASE database. Our Sybase SQL Server Application Unif...
Migrate Sybase Java applications to SQL Server for content services provider
4 October 2016 Bill Ramos
A leading provider of content services for the legal industry looked to DB Best to help them modernize their aging Sybase ASE and IQ solutions that were built on top of an old IBM AIX ...
Delivering expert support in resolving database conversion errors
21 June 2017 Stanislav Andrenko
One of the major United States universities has been migrating their complex data managing system from Sybase to SQL Server. They used SQL Server Migration Assistant for Sybase to aut...
Reference data sheet
Modernizations to Microsoft's Data Platform
21 September 2016 Bill Ramos
Cloud services such as Microsoft Azure, coupled with database technologies like SQL Server, enable organizations to quickly create and scale solutions that solve challenges and fuel ne...
Sybase to SQL Server Migration Datasheet
23 September 2016 Bill Ramos
The number one reason businesses want to migrate from Sybase to SQL Server is reducing Total Cost of Ownership. The DB Best team developed a unique methodology for migrating Sybase app...
Reference white paper
Guide to migrating from Sybase ASE to SQL Server 2014 and Azure SQL Database using SSMA
15 November 2015 Bill Ramos
Summary: This white paper covers known issues for migrating Sybase Adaptive Server Enterprise database to SQL Server 2014. Instructions for handling the differences between the two pla...
eBook: Database Migration
9 August 2018 Bill Ramos
DB Best goes well beyond other migration service providers. We take a vested interest in your migration strategy, combining innovation with an accelerated ROI that meets your business ...
Request a quote