Oracle to Sybase Migration

Migrating a Database Requires Meticulous Planning

In-Depth

In April of 2012, SAP announced that it plans to become the number two by 2015. One of the major activities to achieve this goal will be database from other vendors to the Sybase platform.

db-migration

Click Here to Request a FREE Consultation

Migrating a database requires meticulous planning and an Oracle to Sybase migrations is no different. Earlier this year I spent a lot of time to write down all the differences between Oracle and SAP Sybase and what are available workaround when a direct migration path was not possible. It turned into a several hundred pages monster that is hard to read and to comprehend.

We decided to slowly release a series of white papers that are based on my previous work. The first white paper is called “Oracle to Sybase ASE Migration Guide“.

Dobler provided the management, technical expertise and vision for implementing an advanced content management system at our attractions/entertainment company. We had over 80 years of content in various forms and ended up with a solution and architecture which will allow us to grow another 80 years. Peter Dobler was able to condense business requirements down to technical specifications and then provide the leadership and hands-on expertise to implement the solution. He was able to communicate and gather consensus at the board level and at the system user level, which is critical in a project of this nature. We continue to work with Peter and are very comfortable in recommending his firm.

Dave Ugan, VP of IT, Ripley Entertainment Inc.

Dobler provided the management, technical expertise and vision for implementing an advanced content management system at our attractions/entertainment company. We had over 80 years of content in various forms and ended up with a solution and architecture which will allow us to grow another 80 years....

...more
Dave Ugan, VP of IT, Ripley Entertainment Inc.

Dobler is a leading expert in the deployment and use of Sybase IQ technology for data warehousing and business . While at NMR, Dobler’s team deployed one the largest and most successful implementations of Sybase IQ.

Lou Stanton, Principal Systems Consultant, Sybase, Inc

Dobler is a leading expert in the deployment and use of Sybase IQ technology for data warehousing and business analytics. While at NMR, Dobler’s team deployed one the largest and most successful implementations of Sybase IQ.

Lou Stanton, Principal Systems Consultant, Sybase, Inc

I was introduced to Peter Dobler when seeking an experienced Sybase and Replication Server DBA. After contacting Peter, we spoke in great detail about his and his company’s experience. The Professional Services Agreement and Statement of Work process went very smoothly. By this time, I was hoping that the consultant Peter sent me really would be a senior level Sybase DBA; in fact he was. The consultant had more than 20 years of experience, and quickly uncovered root causes of performance issues, made recommendations and implemented those recommendations over a 2 week period. If you are seeking an expert to tackle tough issues with ASE and Replication Server at a fraction of the cost of SAP, then Dobler Consulting is your company of choice.

Pat Meeks, IT Manager, Williams

I was introduced to Peter Dobler when seeking an experienced Sybase and Replication Server DBA. After contacting Peter, we spoke in great detail about his and his company’s experience. The Professional Services Agreement and Statement of Work process went very smoothly. By this time, I was hoping that...

...more
Pat Meeks, IT Manager, Williams

Peter came in on literally less than 24 hours notice. He jumped right into the fray of an envisioning stage project that was about to implode. Peter guided the technical team, educated the business team and developed a creative solution that he sold to the Executive team. Peter is the rare professional that has an Executive presence when necessary, but also operates very naturally with the most granular of technical details.

Ed Forth, CIO, Healthplan Services

Peter came in on literally less than 24 hours notice. He jumped right into the fray of an envisioning stage project that was about to implode. Peter guided the technical team, educated the business team and developed a creative solution that he sold to the Executive team. Peter is the rare professional...

...more
Ed Forth, CIO, Healthplan Services

Dobler Consulting stepped in and helped us to initially navigate the Sybase-to-SAP transition while we expanded our Sybase product base and switched to a virtual server environment.

Peter and Allan Roeder went the extra mile in helping us get the best deal possible with SAP, also providing invaluable guidance as we transition to a globally distributed environment for ASE and Replication Server. Peter's consummate Sybase experience would be an asset to any enterprise, and we are very happy to have him as our Sybase/SAP partner.

Hector L., DBA, Revelex

Dobler Consulting stepped in and helped us to initially navigate the Sybase-to-SAP transition while we expanded our Sybase product base and switched to a virtual server environment.

Peter and Allan Roeder went the extra mile in helping us get the best deal possible with SAP, also providing invaluable...

...more
Hector L., DBA, Revelex

Peter Dobler is a go-to partner for Sybase. His knowledge of our products and services spans multiple years, and he is a resource that Sybase values within our partner ecosystem. His thought leadership around cloud computing with Sybase technology makes Dobler Consulting a clear choice for our customers.

Matt Reaves, Vice President, Channels, Sybase, an SAP Company

Peter Dobler is a go-to partner for Sybase. His knowledge of our products and services spans multiple years, and he is a resource that Sybase values within our partner ecosystem. His thought leadership around cloud computing with Sybase technology makes Dobler Consulting a clear choice for our custo...

...more
Matt Reaves, Vice President, Channels, Sybase, an SAP Company

Read more from our clients ›

Leave Feedback›

A Recognized Authority

I would like to take this opportunity to thank you for your contributions to the Oracle to Sybase ASE Migration Guide that was recently released on sybase.com. This guide would not have been possible without your experiences working on both platforms. The and appropriate comparisons that you brought into the publication has helped us frame a more effective document that our community will be able to leverage as both a reference and project planning tool. Your ideas for the side-by-side code comparison and sample SQL migration were the items missing from the first document created in 2006, which was more of an architecture and than a code level migration document.

Jeff Pryslak & Analytics Sybase, an SAP Company

Oracle to Sybase Migration Papers

Due to my work on the Oracle to Sybase migration paper, I got invited to present the topic at TechWave 2011. We agreed on 2 one hour sessions. Here’s the abstract of the sessions:

CIO’s unanimously agree that reducing infrastructure costs is key to ensuring adequate budget investment to achieve top-line business growth. While there are obviously many approaches to achieving this, one area gaining attention is migrating from the higher cost Oracle database platform to Sybase ASE, Long known as the highly performant and resilient database powering much of Wall Street, its’ flexibility and low total cost of ownership, both in hardware and administrative costs, are making CIO’s take notice. This 2-part session will explore this topic from two perspectives. We will first dive into this topic from the perspective of the business’ “Program Manager” by identifying the major high-level tasks and milestones of a typical project plan as well as quantifying the level of effort and risk for each. We will then explore this from an implementation perspective looking at some of the most critical and resource-intensive technical aspects of such projects to help you minimize the effort and risk of these types of career-enhancing projects. If your company is considering its options for a competitive, yet cost-effective, database infrastructure, this is a session you can’t afford to miss.

If this is something that caught your interest, you can access the two sessions for free as PDF documents below.

Click Here to Request Part 2

We would love to send you PART 2 of A Practitioner’s Guide to Successfully Migrate from Oracle to Sybase ASE. Just submit the quick form below.