Dump SQLExpress Data

Does SQL Server have a command line program that can dump a whole database
into sql insert statements. I would like to reload the whole database on
another computer.
--
Arne Garvander
(I program VB.Net for fun and C# to get paid.)Arne Garvander wrote:
> Does SQL Server have a command line program that can dump a whole database
> into sql insert statements. I would like to reload the whole database on
> another computer.
>
Why not just use the BACKUP and RESTORE commands? Backup the database
on one machine, then restore it on the other. No need for insert
statements.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Try http://www.sqlscripter.com to generate data scripts.
"Arne Garvander" wrote:
> Does SQL Server have a command line program that can dump a whole database
> into sql insert statements. I would like to reload the whole database on
> another computer.
> --
> Arne Garvander
> (I program VB.Net for fun and C# to get paid.)