Skip to main content

Questions tagged [schema-copy]

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

Filter by
Sorted by
Tagged with
0 votes
1 answer
63 views

How to execute complete database script without checks on objects existence

I'm working on a customer data archiving. I created a complete database script to prepare the new database for archiving data with the same DB schema of the production one. At the moment I'm preparing ...
El See's user avatar
  • 1
0 votes
1 answer
390 views

View or build create table schema statement programmatically with T-SQL [closed]

Is it possible to view or build create statement for selected table? For example SSMS has feature Table > Script Table as > Create To > New Query Editor Window that can generate similar ...
Muflix's user avatar
  • 1,109
0 votes
0 answers
114 views

SQL Server - cloning a subset of a database for a test environment

I'm trying to set up an automated script which I can run on a schedule in SQL Server 2016 (probably nightly) to copy the structure of our production database and then transfer a subset of data into ...
wizzardmr42's user avatar
0 votes
1 answer
441 views

How to daily copy selected data from MySQL and PostgreSQL servers to another PostgreSQL server

I have two source servers, a MySQL 5.7 and a PostgreSQL 9.6, respectively. I would like to daily update some tables from each source to another target PostgreSQL 11 server (via a cron-job). On the ...
Vlad's user avatar
  • 1
0 votes
2 answers
776 views

Sync database table schema and stored procedures

We have 2 databases. One is at our server, the other is local. We need to sync them both in a manner that local database has all data and server database has no data only empty tables and stored ...
Sadiqabbas Hirani's user avatar
0 votes
1 answer
169 views

Can I ignore queries about extendedproperty?

I want to reuse the structure of a database in a new project. So using SSMS I use Generate Script and in settings I set to generate schema only. In the result there are too many queries about ...
Ali Sheikhpour's user avatar
1 vote
1 answer
617 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 ...
user193655's user avatar
4 votes
1 answer
413 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 ...
beldaz's user avatar
  • 1,690
2 votes
1 answer
2k 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 ...
igorsantos07's user avatar
1 vote
1 answer
2k 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 ...
Roman Shevtsiv's user avatar
3 votes
2 answers
2k 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 ...
Muflix's user avatar
  • 1,109
0 votes
2 answers
822 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 ...
Nathan Lutterman's user avatar
2 votes
1 answer
804 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 ...
Adam Matan's user avatar
  • 11.7k