Running ALTER TABLE … ADD COLUMN can have side effects which have the potential to cause serious issues in production. Changing data structures is an important issue and often comes up, therefore it’s important to understand what is really going on. Let’s dive in and see how to run ALTER TABLE … ADD COLUMN in […]
What are aliases in SQL? SQL aliases in FROM clauses are used to give a result set a temporary name. A result set may be produced by a table or view name, sub-SELECT and/or VALUES clause. An alias is created with the AS keyword, but the grammar allows us to omit it. An alias only […]
Coming Soon from CYBERTEC- CYPEX Components. Save time – use existing templates to quickly create database tables within your application. What are the components? They are SQL code fragments with sample data already in place. The Model Builder places the fragments into your code and guides you through inserting your own data, which really speeds […]
Navigate changes with style and ease – migrate to CYPEX. Stuck in a legacy system you’re no longer satisfied with? The CYBERTEC team of experts has helped many customers out of this situation. We’ve created the CYBERTEC CYPEX app builder and are ready to help our customers migrate to CYPEX from Oracle, Informix and Salesforce […]
Uniform, speedy migration For many companies, it doesn’t make sense to migrate Oracle databases to PostgreSQL one-by-one. Sometimes it’s necessary to migrate hundreds or even thousands of identical deployments to PostgreSQL, all at once. If you need to run huge numbers of migrations, CYBERTEC’s Migrator is ready to be put to work. Clone definitions for […]
The CYBERTEC Migrator is Kubernetes- and OpenShift- ready. We rely on modern container technology, perfect for quick deployment. Conveniently scale your deployments and ensure the round-the-clock reliability of your databases. CYBERTEC’s Kubernetes- and OpenShift- ready migration to PostgreSQL means your enterprise is ahead of the game before others have even lined up at the starting […]
Migrate from Oracle with ease CYBERTEC Migrator is a feature-complete migration tool which allows you to facilitate Oracle migrations. As an enterprise-ready product, it focuses explicitly on providing the richest feature set possible. With years of successful migrations behind us, CYBERTEC has developed the ultimate tool for getting the job done right. Minimum downtime, maximum […]
CYBERTEC migrator offers a brand new graphical user interface (GUI) for visual migration of large and possibly complex Oracle databases to PostgreSQL even faster. Navigate quickly through giant databases, and assess the situation with more speed and agility than ever before. Keep track of your migrations with an eagle eye and dive into projects with […]
One of the biggest obstacles faced by people who want to migrate quickly is performance. But your performance doesn’t have to suffer. CYBERTEC Migrator is likely the fastest solution out there to reliably ship data from Oracle to PostgreSQL. We use state-of-the-art techniques such as parallelization and change data capture to ensure we stay at […]
There is no good way to shut down critical systems for a prolonged period of time. It’s not possible to shut down factories, airports, harbors, customs, the federal police, or an emergency service because of a simple database migration. Database uptime is a must and this is especially true if you want to migrate a […]
zheap has been designed as a new storage engine to handle UPDATE in PostgreSQL more efficiently. A lot has happened since my last report on this important topic, and I thought it would make sense to give readers a bit of a status update – to see how things are going, and what the current […]
CYBERTEC offers comprehensive services to move from Oracle to PostgreSQL. Intelligent tooling is available on our website. We want to help you to move to PostgreSQL faster. This quick-start migration guide will get you rapidly moving in the right direction. There are various aspects you need to take into consideration when moving from Oracle to […]
