Banner img

Database Migration From Sybase DB

Move Off Your Sybase Database Faster

Banner img

Sybase DB Migration Factory: Powered by Prolifics

Accelerated Migration
to Your Target Database

When SAP acquired Sybase in 2010, it was seen by some as a move to tap into Sybase’s extensive customer base. However, SAP’s investment in HANA has led to Sybase being phased out.

With Sybase going out of support, many in regulated industries face a problem. They have numerous Sybase databases, some critical, that need to be migrated. But how?

The most obvious answer is for internal teams to handle the migration. They’ll examine the existing code, rewrite it in the new SQL flavour required, move the data, rewrite the application, and test everything.

Yet, inexperience in database migration often leads to delays, higher costs, and a risk of failure. If this isn’t an acceptable risk for your business, consider the ADAM option.

The ADAM option? ADAM, developed by Prolifics, is a software package our expert consultants use for database migration. It analyses every line of your Sybase code in advance, providing an accurate schedule of required work. ADAM automates code conversion where possible and suggests enhancements at the database layer to minimize code changes in your application. Our consultants, experts in database migration, use ADAM daily. This ensures your project has reduced risk, shorter timelines, and lower costs.

Accelerated Migration to EDB

Minimising Database Migration Risk

Prolifics Database Migration Strategy Reduces Errors for Improved Performance

Technical and Commercial Viability Assessment

before any work takes place, we do this because we don't want your migration to fail.

Comprehensive Code Assessment

Prolifics covert your code optimally taking into account the nuances of SQL compatibility, to get the best version of your source. Incompatibilities are highlighted and changes tracked, to provide full auditability.

Automated Change Management

Minimise human-error. The target database is checked against the source environment to confirm successful conversion of the code. Then, using Prolifics' bespoke tooling of Python and NiFi we will migrate the data itself to the target EDB database.

Unmatched Consultation and Guidance

Guidance every step of the way. Without a robust testing methodology and knowledge of common SQL pitfalls, timelines can become compromised. Our specialist testing team create the right environment to make this final process seamless.

Detailed Strategy and Fixed-Cost Pricing

Know how much it will cost and why etc. etc.

Is Your Oracle DB a good candidate?

Meet ADAM, Our Automated Database Agnostic Migrator

Automated – Prolifics went to market searching for a database migration tool to help with moving our customers between database vendors. We found many, but none that worked for us. They were either just a bunch of scripts that didn’t do the job, or a ‘black-box’ with no auditability that also didn’t suit our needs. What we needed was customisable automation. A system that tells us what it is going to do before it does it, takes the application into account, and then automates the creation of the best solution under the guidance of a database migration expert. It didn’t exist so we built it.

Database Agnostic – Most migration tools move code from A to B, or from C to D, but unless they specifically target A to D you need a different tool. ADAM works differently as it doesn’t convert directly, but rather works on a hub and spoke model. This means that it converts A, B, C and D into a central model, and then converts that into your target database A, B, C or D. Obviously it does not work with every single database ever made but it does work with all the major relational DBMS’s. So if you want to move to Postgres, Db2, Sybase, SQL Server, Aurora, etc etc – then ADAM will work for you.

Migrator – The tool is an assistant to our consulting services. We do not provide the ADAM software to our customers, we provide a migration service using ADAM. We do not just run your code through a tool and hope for the best. ADAM will analyse all of your SQL code upfront as a part of the planning process. From that analysis we will then identify every line of code as one of the below
• Needs a re-architecture as it is not supported on the target database, storing Oracle parquet files on postgresql for example (correct at the time of writing)
• Needs a sensible decision made by the consultant, distribution keys for example.
• Code that could be migrated a few ways, and so the specific conversion is application dependent, how to store numbers for example.
• Code that can only be migrated one way, and so can be automatically converted without further analysis.


Expert Insight

Why is SQL
so... incompatible?

Prolifics’ database expert and architect, Paul Vernon speaks candidly about why SQL databases are notoriously difficult to migrate.

Find out why this is stopping IT teams in their tracks when considering new, target databases.

Read Now


SQL Data Migration:
What You Need to Know

Moving databases can be tricky, so we’ve put together a short article on everything you need to know before embarking on a migration.

Read Now


Arrange a Call With Our Expert

Request a Database Assessment

Your next step may or may not be crystal clear, but a lack of tried and tested skills can be a daunting prospect when it comes to moving or migrating enterprise databases.

Spend 30 minutes with our database migration expert, for an assessment of the time and cost required to move you from Sybase to your target database.

Connect on LinkedIn


Need Clarification?

Prolifics offer a database migration service, where our consultants will use our proprietary ADAM tooling to offer an accelerated migration program and minimise project risk.

Reach out to one of our team who will help you conduct a viability assessment over a short 30 min call. From there we will provide a questionnaire about your environment for your application teams to respond to, and we will request all SQL code from your database (table definitions, stored procedures, triggers, the lot). Prolifics will run the code through ADAM and assess every single line of code. From there Prolifics will issue a quotation to migrate the database for you, and then you either sign up or you don’t.

Prolifics usually help our customers with the planning, data migration, code migration, and then database tuning – leaving most of the testing and application changes to the client’s internal teams. However, Prolifics can offer testing services and application development consultancy too if required. “We can do this with you, or we can do this for you”.

Please use the form below to get in contact with one of our Account Executives who will be able to get you started.