Posted by Greg D. Moore \(Strider\) on 11/05/07 12:04

<johnhitashi@gmail.com> wrote in message
news:1194260831.038374.212460@y27g2000pre.googlegroups.com...
> Hi all,
>
> 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..

Not easily. You can script through and do some form of BCP of each table to
a file.
However, you can't guarantee a consistent backup this way unless you stop
ALL updates to the database while you perform the backup.


> & 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...
>

Google for that, there's definitely some commercial and probably some
freeware solutions out there.


> Thanks in Advance
>



--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

[Back to original message]