Freaks City

Overview This article documents a data base migration from Oracle 11g (source) to Oracle 10g (target) where typical export/import methods were unavailable due to access restrictions. Initial Approaches Considered Data Pump (expdp/impdp) Data Pump utilities were the first choice but required operating system authentication credentials that were ...

Flask-Migrate is an extension that integrates Alembic into Flask applications, enabling tracking of model changes and mapping them to the database. Install Flask-Migrate via pip: pip install flask-migrate A typical project structure includes: config.py app.py manager.py models.py Define database configuration in config.py: class Config: ...

Migration Context and Requirements GitLab 17.x requires PostgreSQL 14.9+ as minimum version, necessitating an upgrade from currrent 13.6 deployment. This guide documents the in-place upgrade process for a production streaming replication enviroment. Version Specifications Source: PostgreSQL 13.6 Target: PostgreSQL 14.11 Upgrade Procedure Cre ...

WPF applications targeting .NET 5 or later often encounter issues when generating database migrasions with Entity Framework Core. The tooling fails to instantiate the DbContext because the design-time environment lacks the necessary startup configuration. Implementing the IDesignTimeDbContextFactory interface resolves this by providing an expli ...

Database Models Create models.py in the ihome driectory: # -*- coding:utf-8 -*- from datetime import datetime from . import db class BaseModel(object): """Base model class providing created_at and updated_at timestamps""" created_at = db.Column(db.DateTime, default=datetime.now) updated_at = db.Colu ...

Oracle Data Pump utilities expdp (export) and impdp (import) facilitate logical backup and migration of database objects using .dmp files. These server-side tools must be executed on the host where the Oracle database resides. Exporting a Schema to a DMP File Begin by logging in as the Oracle softawre owner (e.g., oracle). The general syntax fo ...