Download to read offline
Uploaded byAshnikbiz
Migrating from legacy Database to Postgres
This document discusses migrating from a legacy database to Postgres. It notes that 35% of software budgets are spent on database management systems, 80% of in-house applications are candidates to move off expensive databases, and migrating can result in 70% cost savings. The advantages of Postgres include database compatibility with Oracle, proven performance, enterprise-class support, and being cloud ready. The steps to migrate include assessing the database, preparing the environment, migrating data and objects, porting applications, testing, integrating, and rolling out to production. Migrating allows leveraging existing skills while gaining benefits like agility, cost savings, and flexibility.
More Related Content
Similar to Migrating from legacy Database to Postgres
![[EPPG] Oracle to PostgreSQL, Challenges to Opportunity](https://cdn.slidesharecdn.com/ss_thumbnails/eppg-oracletopostgresqlchallengestoopportunity-190409033058-thumbnail.jpg?width=600ounds&width=560&fit=bounds)
Migrating from legacy Database to Postgres
- 1. Migrating from LegacyDatabase to Postgres: How, Why and its Advantages By – Kaustubh Patwardhan (KP) Director - SEA and HK, Ashnik
- 2. CONFIDENTIAL © 2011 EnterpriseDB.All rights reserved. WHY Migrate
- 3. Digital represents challengefor some, OPPORTUNITY FOR OTHERS. With new digital initiatives on the scene, players will fall on both sides of the fence. The digital business revolution is radically transforming the marketplace...
- 4. 4 Finding Money inIT 35% 80% 70% Software Infrastructure Budget on DBMS1 In House DBMS Apps Candidates to Move Off Expensive DBMS2 Cost Savings3 1 Gartner, Forrester and EDB analysis 2 The State of Open-Source RDBMS, 2015, Gartner, April 2015 3 The State of Open-Source RDBMS, 2015, Gartner, April 2015; EDB analysis of customer experiences and market prices CONFIDENTIAL © 2011 EnterpriseDB. All rights reserved.
- 5. 5CONFIDENTIAL © 2011 EnterpriseDB.All rights reserved. BUSINESS AGILITY
- 6. CONFIDENTIAL © 2011 EnterpriseDB.All rights reserved. WHY Postgres
- 7. Database Compatibility withOracle® Everything works On EDB Postgres Applications Running on Oracle Oracle Developers Your BusinessYour AppsYour People Compatible with: CONFIDENTIAL © 2011 EnterpriseDB. All rights reserved.
- 8. 8 Why EDB Postgres?- Customer Benefits Proven Performance Cost Enterprise-Class Support Cloud Ready CONFIDENTIAL © 2011 EnterpriseDB. All rights reserved.
- 9. CONFIDENTIAL © 2011 EnterpriseDB.All rights reserved. EDB Postgres Platform
- 10. CONFIDENTIAL © 2011 EnterpriseDB.All rights reserved. How to Migrate
- 11. Steps to Migrate CONFIDENTIAL ©2011 EnterpriseDB. All rights reserved. 1. Database Assessment 2. Prepare Environment 3. Migrate Database Objects and Data 4. Port Application 5. Test 6. Integrate 7. Rollout
- 12. STEP 1: DBMigration Assessment 12 • Schema Discovery • DB Analysis • Scoring • App Selection • Success & Savings
- 13. © Copyright EnterpriseDBCorporation, 2017. All Rights Reserved. STEPS 2 & 3: Prepare Environment & Migrate Database Objects and Data EDB POSTGRES MIGRATION TOOLKIT
- 14. STEP 4: PortApplication Change connection information (Readily available EDB drivers based on your application need ) Recompile/Link application(OCI or Pro*C) (EDB ECPG Plus) STEP 5: Test Verify Application Functionality (Monitoring with EDB PEM and EDB advance auditing) Test Performance (Monitoring and analysing current and history Database and system data with PEM) Tune (EDB SQL profiler) STEP 6: Integrate Establish co-existence strategy (FDW to connect with foreign system) Setup replication between Oracle or SQL Server and EDB Postgres Advance Server (Hydride replication using EDB replication Server) STEP 7: Rollout System Becomes Production.
- 15. EDB POSTGRES SOLUTIONUSE CASES – Approach to migrate CONFIDENTIAL © 2011 EnterpriseDB. All rights reserved. NEW APPLICATIONS: DevOps, schema-less rapid development, and multiple programming language support APPLICATION MODERNIZATION: Multi-model flexibility and integration with popular data sources REPLACEMENT OF LEGACY DBMS: Compatibility with Oracle leverages existing DBA and Developer skills CLOUD REPLATFORMING: Flexible deployment options and simple business terms
- 16. Ashnik – ValueProposition 16 Value based subscription model Insight based consulting Need based Training Outcome based managed services Peace of Mind in Open Source Technology Adoption CONFIDENTIAL © 2011 EnterpriseDB. All rights reserved.
- 17.
Editor's Notes
- #4 This is an unprecedented time in history Data and technology are fueling a digital business revolution Current competitors and new entrants like Uber, YouTube, etc. 3 out of 4 F500 will drop out in next 12 years Harnessing tech to drive competitive advantage is now a business imperative—you must move fast and smart to win in tomorrow’s marketplace
- #14 KEY TAKEAWAY: Fast, flexible and customized database migration to PostgreSQL and EDB Postgres Advanced Server Are you looking to migrate your database to Postgres or just want to test drive Postgres with your own data? If so, the EDB Migration Toolkit from EnterpriseDB was made for you. This powerful utility is full of options to make the task fast and customized to your needs. Product Highlights Automated schema/data migration. Saves time, money and effort. Online migration. Migrate your source database directly into PostgreSQL or EDB Postgres Advanced Server making it available for immediate use. Offline migration. Creates DDL scripts that can be edited and run at a later scheduled time. Multiple database support. Ability to migrate from SQL Server*, Sybase*, or Oracle* to PostgreSQL or EDB Postgres Advanced Server. Customize migrations. Specify whether or not to include table constraints/triggers/indices, manage bulk inserts, apply row filters, change datatypes inline, specify subsets of schema objects to migrate or all. Fast data migration. Utilize parallel data movement techniques, bypass logging for faster data loads or use native connectivity to source database.