469,573 Members | 1,695 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,573 developers. It's quick & easy.

Backup Structure Only

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 and compare the
structure in another, can be a pain if there's 600MB of data that goes
with it.

Jul 13 '07 #1
6 9333
I do not believe you can backup just the db structure. Why not use a
tool like AdeptSQL Diff or Red Gate SQL Compare for a schema
comparison?

Jul 13 '07 #2
On Jul 13, 8:00 am, Trevor Best <googlegro...@besty.org.ukwrote:
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

Jul 13 '07 #3
Trevor Best (go**********@besty.org.uk) writes:
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 and compare the
structure in another, can be a pain if there's 600MB of data that goes
with it.
The new version of SQL Compare from Red Gate permits you to script the
database to a folder, and then you can compare a database to that folder.

You can also script the database from Enterprise Manager and SQL Server
Mgmt Studio, and then create a database from that script on the target.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jul 13 '07 #4
The free, open-source SchemaCrawler tool will do what you need. You
can take human-readable snapshots of the schema and/ or data, for
later comparison. Comparisons are done using a standard diff tool such
as WinMerge. SchemaCrawler outputs details of your schema (tables,
views, procedures, and more) in a diff-able plain-text format (text,
CSV, or XHTML). SchemaCrawler can also output data (including CLOBs
and BLOBs) in the same plain-text formats. A lot of examples are
available with the download to help you get started. You will need to
provide a JDBC driver for your database, such as the free jTDS driver
for SQL Server.

You can download a pre-packaged version of SchemaCrawler for SQL
Server to get you started quickly. SchemaCrawler is available at
SourceForge:http://schemacrawler.sourceforge.net/

Sualeh Fatehi.

Jul 16 '07 #5
Thanks all. I'm planning on upgrading SQL Compare anyway so will go
with Erland's suggestion.

Jul 17 '07 #6
On Jul 13, 4:33 pm, sqlmatt <sqlm...@gmail.comwrote:
I do not believe you can backup just the db structure. Why not use a
tool like AdeptSQL Diff or Red Gate SQL Compare for a schema
comparison?
yebbut, kinda need to get the databases to the same location to
compare them ;-)

Jul 17 '07 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by James | last post: by
7 posts views Thread by bobdirls | last post: by
1 post views Thread by Fabius | last post: by
1 post views Thread by Joachim Klassen | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.