Question : I had one schema ‘public’ and simple function in the schema named ‘isvalidoption’. What was done: backup schema […]
Tag: schema-copy
How to daily copy selected data from MySQL and PostgreSQL servers to another PostgreSQL server
Question : I have two source servers, a MySQL 5.7 and a PostgreSQL 9.6, respectively. I would like to daily […]
PostgreSQL, PostGIS: Copying a schema with a geometry column
Question : According to the PostGIS manual, geometry columns should not by added directly, but using AddGeometryColumn(): AddGeometryColumn — Adds […]
How to daily copy selected data from MySQL and PostgreSQL servers to another PostgreSQL server
Question : I have two source servers, a MySQL 5.7 and a PostgreSQL 9.6, respectively. I would like to daily […]
mysqldump takes forever to dump tables from a remote server
Question : I’m trying to pull the database schema from a remote server, but mysqldump is too slow to output […]
Getting nice PostgreSQL pgAdmin-style DDL
Question : In pgAdmin 3 (and pgAdmin 4 if you’re prepared to wait longer) the DDL for the currently selected […]
Sync database table schema and stored procedures
Question : We have 2 databases. One is at our server, the other is local. We need to sync them […]
Is it possible to copy a dev. database schema over a prod. one, but keep the prod. database’ data?
Question : I’m using MySQL 5.6. I have a production database and a development database. As I’m developing the application, […]