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.)Hi Arne
"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
You may want to check out the suggestions on
http://www.karaszi.com/SQLServer/in...rate_script.asp
John|||So you are suggesting third party tools.
Thanks.
--
Arne Garvander
(I program VB.Net for fun and C# to get paid.)
"John Bell" wrote:

> Hi Arne
> "Arne Garvander" wrote:
>
> You may want to check out the suggestions on
> http://www.karaszi.com/SQLServer/in...rate_script.asp
> John|||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|||Hi Arne
"Arne Garvander" wrote:

> So you are suggesting third party tools.
> Thanks.
> --
> Arne Garvander
Some are tools, some are scripts to generate the INSERT statements. I would
go with BACKUP and RESTORE as suggested by Tracy or even BCP which are far
better ways to load significant amounts of data than loads of INSERT
statements.
John