Blog - KeepTool

How to Migrate an Oracle Database to PostgreSQL – Part 1

20 Nov 2025

Migrating an Oracle database to PostgreSQL can seem challenging—but KeepTool makes the process straightforward. This article walks you through converting tables, views, data, and PL/SQL logic into PostgreSQL, using Hora’s built-in migration tools. Learn how Hora generates compatible DDL, translates trigger logic, and simplifies data transfer.

Learn more

Using Sequences and Fixed Values within INSERT Scripts

INSERT Scripts with Sequence Values and Custom Expressions

01 Sep 2025

KeepTool (Hora) now offers more flexibility in generating INSERT scripts. You can create INSERT Scripts with with Sequence Values and Custom Expressions such as DEPARTMENTS_SEQ.NEXTVAL, SYSTIMESTAMP, or any other function/constant/expression — instead of exporting existing data—making it easy to create fresh inserts for test setups or data initialization.

Learn more

AE-256 Password Encryption - Enhanced Security for KeepTool

AES-256 Password Encryption in KeepTool 16.2

05 Sep 2024

KeepTool 16.2 introduces a major security upgrade for password management: All stored connection passwords are now encrypted with AES-256, one of the most advanced and trusted encryption standards worldwide. A new KeyStore concept adds another layer of protection through a personal master password. Learn how the migration works and how to keep your stored database passwords even more secure with this latest version of KeepTool.

Learn more

Migrate from DBMS_JOBS to ORACLE Scheduler

Easily Migrate Legacy dbms_job Jobs to Oracle Scheduler with KeepTool

21 May 2024

With KeepTool 16.1, you can easily migrate legacy dbms_job jobs to the modern Oracle Scheduler. The new context menu in Hora automatically creates PL/SQL scripts, generates new scheduler jobs, and removes old ones if desired. Enjoy more control, improved security, and long-term compatibility — all with just a few clicks.

Learn more

Flat Detail Data Browser for Oracle Database

22 Jan 2024

The new Flat Detail Data Browser in KeepTool 16 makes Oracle master/detail data analysis faster and easier. Instead of drilling through multiple table levels, the new dialog displays all sub-detail data of a master record in a single, clear view. You can explore relationships, export results, or instantly create INSERT scripts — saving valuable time in daily database work.

Learn more

Speed Up Large Data Inserts with Oracle Bulk Insert Scripts in KeepTool

07 Nov 2023

With KeepTool 16, creating INSERT scripts for large Oracle datasets becomes faster and easier than ever. New features like Bulk Inserts, Direct Path Inserts, and automatic script splitting dramatically improve performance and usability when handling high-volume data operations. Perfect for developers and DBAs who work daily with large Oracle tables.

Learn more

Streamline ORDS Configuration and Testing - With KeepTool

Build Oracle REST Data Services (ORDS) in KeepTool 16

18 Sep 2023

With KeepTool 16, you can easily create and manage Oracle REST Data Services (ORDS) directly from Hora’s graphical interface. Enable schemas, define modules, templates, and handlers, and instantly publish REST endpoints returning JSON data — all without manual PL/SQL coding. Use parameters like ?id=123 or ?sal=10000 to filter results dynamically and integrate your Oracle data into web or mobile applications with just a few clicks.

Learn more

Export XML Data with KeepTool & Oracle XML DB

03 Mar 2023

In Part 2 of this series, you’ll learn how to construct a streamlined XML export interface using Oracle XML DB in tandem with KeepTool. The tutorial demonstrates building key PL/SQL types, registering export-ready XML schemas, and crafting procedures that generate hierarchical master-detail XML exports—stashed in an interface table—for seamless data-sharing workflows.

Learn more

Import XML Data with KeepTool and Oracle XML DB

23 Jan 2023

Dive into the first installment of a two‑part series where you'll learn how to leverage Oracle XML DB alongside KeepTool to build an efficient XML-based data import interface. This post walks you through defining PL/SQL types and registering XML schemas, culminating in a functional solution to import HR‑EMPLOYEES data—ready to be extended with custom logic for your own projects.

Learn more

Encrypted Direct TCP/IP Database Connections

Secure Oracle Connections with SQL*Net Encryption & Checksums

20 Sep 2022

KeepTool now empowers you to configure and monitor Oracle’s native SQL*Net encryption and data integrity checksumming, even when connecting directly via TCP/IP. You can enforce encryption parameters (ACCEPTED, REQUIRED, etc.) without altering sqlnet.ora, and easily track both encryption and checksum status per session in the new Sessions → Network client tab—giving you full visibility and control over your network security.

Learn more

Never Lose Sight of What Matters in Large Schemas

18 Feb 2022

KeepTool lets you flag your database objects—assign icons like colored bullets, stars, or warning signs directly within your object overview. Once flagged, items remain visually marked across all KeepTool components—from the query builder to ER diagrams—making it fast and easy to keep track of the tables, packages, or sequences you're focused on managing.

Learn more

More Efficiency and Security with KeepTool

06 Dec 2021

KeepTool 15 introduces enhanced performance, compatibility, and security for Oracle databases. With full support for Windows 11 and Oracle 21c, new XML DB features, direct TCP/IP encryption, and visual object flagging, this release streamlines daily work for developers and DBAs. Experience faster workflows, better integration, and modern security — all in a single, intuitive tool.

Learn more

KeepTool Blog