Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [schema-copy]

A schema copy is a backup of the database schema, sans the data.

1
vote
1answer
83 views

How to copy a database using scripts only, no bak, no mdf, no ldf

Too often I face a terrible situation: I have a little time to take the backup of a customer db and download it for studying problems on it. The problem is that the database contains many BLOBs (as ...
3
votes
1answer
94 views

Getting nice PostgreSQL pgAdmin-style DDL

In pgAdmin 3 (and pgAdmin 4 if you're prepared to wait longer) the DDL for the currently selected database object is shown in the main panel, along with corresponding triggers, constraints, etc, all ...
1
vote
1answer
474 views

mysqldump takes forever to dump tables from a remote server

I'm trying to pull the database schema from a remote server, but mysqldump is too slow to output (125+) tables' structures. If I enter the said server and run mysqldump --compact --compress --no-data ...
0
votes
1answer
419 views

Permission denied on function after schema copy

I had one schema 'public' and simple function in the schema named 'isvalidoption'. What was done: backup schema using pg_dump; rename schema to 'development'; create new schema 'public'; restore it ...
3
votes
2answers
1k views

Moving database objects to another database without wizard

I have several databases on production and i have also test environment. I don't have permission to do backup and restore operations. Actually i am using wizard to generate scripts (schema + data) and ...
0
votes
2answers
410 views

Is it possible to copy a dev. database schema over a prod. one, but keep the prod. database' data?

I'm using MySQL 5.6. I have a production database and a development database. As I'm developing the application, I sometimes need to add new columns/tables to the database. Is it possible, when I'm ...
1
vote
1answer
480 views

PostgreSQL, PostGIS: Copying a schema with a geometry column

According to the PostGIS manual, geometry columns should not by added directly, but using AddGeometryColumn(): AddGeometryColumn — Adds a geometry column to an existing table of attributes. I ...