Skip to main content
Database Administrators

Return to Question

Terminology.
Link
MDCCL
MDCCL
  • 8.5k
  • 3
  • 31
  • 62

Is it possible to backup a subset of a DBdatabase in MSMicrosoft SQL Server?

Removing "schema" from title, as it's misleading; additional grammar tweaks.
Source Link
RDFozz
RDFozz
  • 11.7k
  • 4
  • 24
  • 38

Is schema-only backupit possible forto backup a subset of a DB in MS SQL?

Is there a way forUsing Microsoft SQL serverServer, where we canis there a way to backup a subset of a production database? I only want the database structure, and a very small amount of transaction data for a few selected tables.

I want to use this backup file to refresh development database.

For oracleOracle I see this is achieved using this powershellPowershell script:

userid="/ as sysdba"
compression=all
directory=TEST_DIR
flashback_time=systimestamp
dumpfile=XX.dmp
logfile=xx.log
schemas=XXXXX
query=SCHEMA.TABLE:"where <condition>
exclude=TABLE:"IN (x)"

Is schema-only backup possible for MS SQL?

Is there a way for Microsoft SQL server, where we can backup a subset of a production database? I only want the database structure, and a very small amount of transaction data for a selected tables.

I want to use this backup file to refresh development database.

For oracle I see this is achieved using this powershell script:

userid="/ as sysdba"
compression=all
directory=TEST_DIR
flashback_time=systimestamp
dumpfile=XX.dmp
logfile=xx.log
schemas=XXXXX
query=SCHEMA.TABLE:"where <condition>
exclude=TABLE:"IN (x)"

Is it possible to backup a subset of a DB in MS SQL?

Using Microsoft SQL Server, is there a way to backup a subset of a production database? I only want the database structure, and a very small amount of transaction data for a few selected tables.

I want to use this backup file to refresh development database.

For Oracle I see this is achieved using this Powershell script:

userid="/ as sysdba"
compression=all
directory=TEST_DIR
flashback_time=systimestamp
dumpfile=XX.dmp
logfile=xx.log
schemas=XXXXX
query=SCHEMA.TABLE:"where <condition>
exclude=TABLE:"IN (x)"
title, english++
Source Link
edit approved Jun 12, 2018 at 17:41
peterh
edit approved Jun 12, 2018 at 17:41
peterh
  • 2.1k
  • 8
  • 28
  • 41

sqlserver db Is schema-only backup possible for MS SQL?

For SQL Server isIs there a way for Microsoft SQL server, where we can backup a subset of a production database,I? I only want the database structure, and a very small amount of transaction data for a selected tables.

I want to use this backup file to refresh development database.

For oracle iI see this is acheivedachieved using this powershell script example below userid="/ as sysdba" compression=all directory=TEST_DIR flashback_time=systimestamp dumpfile=XX.dmp logfile=xx.log schemas=XXXXX query=SCHEMA.TABLE:"where exclude=TABLE:"IN (x)"

userid="/ as sysdba"
compression=all
directory=TEST_DIR
flashback_time=systimestamp
dumpfile=XX.dmp
logfile=xx.log
schemas=XXXXX
query=SCHEMA.TABLE:"where <condition>
exclude=TABLE:"IN (x)"

sqlserver db backup

For SQL Server is there a way where we can backup subset of production database,I only want the database structure and a very small amount of transaction data for selected tables.

I want to use this backup file to refresh development database.

For oracle i see this is acheived using powershell script example below userid="/ as sysdba" compression=all directory=TEST_DIR flashback_time=systimestamp dumpfile=XX.dmp logfile=xx.log schemas=XXXXX query=SCHEMA.TABLE:"where exclude=TABLE:"IN (x)"

Is schema-only backup possible for MS SQL?

Is there a way for Microsoft SQL server, where we can backup a subset of a production database? I only want the database structure, and a very small amount of transaction data for a selected tables.

I want to use this backup file to refresh development database.

For oracle I see this is achieved using this powershell script:

userid="/ as sysdba"
compression=all
directory=TEST_DIR
flashback_time=systimestamp
dumpfile=XX.dmp
logfile=xx.log
schemas=XXXXX
query=SCHEMA.TABLE:"where <condition>
exclude=TABLE:"IN (x)"
Source Link
Sai Kishan
Sai Kishan
  • 31
  • 1
  • 2