Database Training Days: PostgreSQL Resources

In today's data-driven world, the demand for data is increasing, and its protection is critical. Oracle is everywhere—from ERP systems to medical and other applications. However, not all applications require the extensive features and costs associated with Oracle. In this dynamic session, we will explore practical strategies for moving data from Oracle to PostgreSQL, focusing on the key considerations to ensure a smooth and efficient transition.

Topics that will be discussed include:

• High-level trends in data and the growing need for data movement
• The impact of increasing data demand
• Challenges in moving applications that access the data
• Key considerations for data growth, demand, and protection
• Options for selective data movement from Oracle to PostgreSQL

Speaker:

• Clay Jackson
  Senior Sales Engineer, Quest Software

As data volumes continue to grow, the need to make better use of your data while cutting costs becomes increasingly important. Leveraging more affordable database technologies like PostgreSQL can be a cost-effective solution, but traditional ETL processes often fall short in meeting the demand for continuous processing and timely decision-making. Additionally, repeatedly reloading the same data can lead to lost productivity. This on-demand webcast offers valuable insights into syncing essential Oracle tables with a community PostgreSQL database to migrate workloads efficiently and reduce costs.

Topics that will be discussed include:

• Mapping your Oracle schema to a PostgreSQL schema
• Performing the initial load of data into PostgreSQL
• Syncing data between Oracle and PostgreSQL tables
• Conducting quick data analysis

Speaker

Martin Wild
Solution Consultant, Quest

As large enterprises increasingly prioritize migrating from Oracle to PostgreSQL, selecting the right migration model—whether rehosting, re-platforming, or refactoring—is crucial. To ensure a successful transition, it's essential to carefully consider the best approach for moving to the cloud or an on-premises solution. In this webcast, we will share five key considerations learned from real-world experiences, offering valuable insights and recommendations for a professional and efficient transition.

Topics that will be discussed include:

• Choosing the right migration model: rehosting, re-platforming, or refactoring
• Key factors for a successful migration to PostgreSQL
• Insights for moving to the cloud or maintaining an on-premises solution
• Strategies to ensure a smooth and efficient migration process

Speaker

Cybertec

Are you looking to modernize your database infrastructure? Join CYBERTEC's webcast to uncover valuable strategies for a smoother and more efficient migration journey. Our expert insights and recommendations will guide you in mitigating risks, minimizing pitfalls, and optimizing both time and cost savings as you transition from Oracle to PostgreSQL.

Topics that will be discussed include:

• Strategies for a successful migration from Oracle to PostgreSQL
• Risk mitigation techniques during the migration process
• Tips for minimizing common pitfalls in database transitions
• Optimizing time and cost savings throughout your migration journey

Speaker

CYBERTEC

In this webcast, you'll learn how to reduce costs and enhance database performance by offloading reporting tasks. Microsoft Cloud Solutions Architect Sri Hari and Quest® Database Solutions Engineer Martin Wild will guide you through the process of safely and efficiently migrating Oracle data to lower-cost Azure SQL and SQL Server databases.

This session will provide practical insights on how to leverage Azure's capabilities to optimize your reporting processes, making it easier to manage and analyze your data without sacrificing performance.

Topics that will be discussed include:

• Offloading Oracle reporting to an Azure PaaS database, such as PostgreSQL, MySQL, or SQL Server
• Using Oracle data in Azure Analytics
• Locating your audit data from Oracle to Azure (CDC)
• Building a data warehouse in Azure that’s based on and in sync with your Oracle data
• Continuously moving Oracle data to Azure SQL Database to accurately and affordably offload reporting

Additional Considerations:

• Optimizing reporting performance on target databases by placing workloads closer to users and segregating reporting workloads to different locations and data sets
• Using a data replication solution that is easy, flexible, accurate, and can handle high transaction volumes with low overhead
• Monitoring the health and performance of your Azure databases
• Addressing network latency and running Azure database workloads

Speakers

Sri Hari
Microsoft Cloud Solutions Architect

Martin Wild
Quest® Database Solutions Engineer