Backup data from database.

Hi all experts,
I would like to know if there are any method to generate an SQL
insert statements which contain all the data inside one of my database?
I do not want to backup the mdf files. Thanks alot.
Thanks
Rena.You can use bcp.exe or DTS to export just the data. If you really want
Insert statements, Narayana created a procedure -
http://vyaskn.tripod.com/code/generate_inserts.txt.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"rena" <rena@.hotmail.com> wrote in message
news:%23yvXBvHFEHA.3132@.TK2MSFTNGP12.phx.gbl...
> Hi all experts,
> I would like to know if there are any method to generate an SQL
> insert statements which contain all the data inside one of my database?
> I do not want to backup the mdf files. Thanks alot.
> Thanks
> Rena.
>|||... and a few other options:
http://www.karaszi.com/sqlserver/in...rate_script.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in m
essage
news:eHYiUBKFEHA.2416@.TK2MSFTNGP12.phx.gbl...
> You can use bcp.exe or DTS to export just the data. If you really want
> Insert statements, Narayana created a procedure -
> http://vyaskn.tripod.com/code/generate_inserts.txt.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "rena" <rena@.hotmail.com> wrote in message
> news:%23yvXBvHFEHA.3132@.TK2MSFTNGP12.phx.gbl...
>