Re: Backup Structure Only

On Jul 13, 8:00 am, Trevor Best <googlegro...@xxxxxxxxxxxx> wrote:
Is there a way to back up the structure of the database only? i.e.
backup without the data.

I sometimes need to backup a database in one location andcomparethe
structure in another, can be a pain if there's 600MB of data that goes
with it.

Hi Trevor,

have a look at xSQL Software's (www.xsqlsoftware.com) xSQL Object - it
allows you to take snapshot of the database schema only (without the
data). You can then compare snapshots to live databases or snapshots
to snapshots etc.

Thanks,
JC
xSQL Software
http://www.xsqlsoftware.com

.

Relevant Pages

  • RE: Replication
    ... Snapshot replication copies over the entire database. ... will still need to backup the main instance of the database. ... > backup or snapshots multiple times a day would also work just fine. ...
    (microsoft.public.sqlserver.programming)
  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: RMAN restore of full backup fails completely
    ... You are not using a catalog database. ... You might have autobackup controlfile on, ... Your autobackup has been made *prior* to the backup! ... plus archivelog', when i try a restore on the other server however, the ...
    (comp.databases.oracle.server)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • Re: NTBACKUP error
    ... Are you putting the oracle tablespaces in backup mode before doing the ... start of the backup which they will be doing if the database is ... Shutting down archive processes ... Undo Segment 1 Onlined ...
    (comp.databases.oracle.server)