Posted by Erland Sommarskog on 11/05/07 22:53

(johnhitashi@gmail.com) writes:
> I have sql server 2005 express edition installed. i want to
> take a backup of sql database Using the sql management studio, under
> tools, in tasks, i see a backup option , but this backup is in binary
> format.. i wanted to know is there a way to take sql database backup
> in text format..

The nature of a backup is such that it is not meaningful to have a
text format for it. The purpose of a backup is make it possible to
restore a consistent version of the database in case of a disaster.

> & also i want to compare the databases in same sql
> server 2005 server.. Is there any sql delta tool for this.. please do
> guide me with appropriate links, documents.. how can i do these...

Goto http://www.red-gate.com/ and have a look at SQL Compare and SQL Data
Compare.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]