dumping data from database

[rozrabiak]

Hi:)
I need to dump data from database in to *.sql file. I try it using DUMP
DATABASE but it not work that I need it.

So, how can I dump data from database in to *.sql file and then run it
using: osql -E -i nameOfDumpedDat abase.sql


Thanks for help, greetings, gregory :)

[Simon Hayes]

Re: dumping data from database


"rozrabiak" <brak@maila.p l> wrote in message
news:c6r83b$5ra $1@news.onet.pl ...[color=blue]
> Hi:)
> I need to dump data from database in to *.sql file. I try it using DUMP
> DATABASE but it not work that I need it.
>
> So, how can I dump data from database in to *.sql file and then run it
> using: osql -E -i nameOfDumpedDat abase.sql
>
>
> Thanks for help, greetings, gregory :)[/color]

You can use bcp.exe or DTS to export data to a file and load it again, or if
you prefer INSERT statements then see here:

http://vyaskn.tripod.com/code.htm#inserts

If you want everything (objects and data), then BACKUP and RESTORE is often
the easiest way.

Simon

[Erland Sommarskog]

Re: dumping data from database

rozrabiak (brak@maila.pl) writes:[color=blue]
> I need to dump data from database in to *.sql file. I try it using DUMP
> DATABASE but it not work that I need it.
>
> So, how can I dump data from database in to *.sql file and then run it
> using: osql -E -i nameOfDumpedDat abase.sql[/color]

In Enterprise Manager, find the database, right-click, select All Tasks,
and in that submenu you find scripting options.

--
Erland Sommarskog, SQL Server MVP, sommar@algonet. se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[jdbcguy]

Re: dumping data from database

Erland Sommarskog <sommar@algonet .se> wrote in message news:<Xns94DAF1 247AB58Yazorman @127.0.0.1>...[color=blue]
> rozrabiak (brak@maila.pl) writes:[color=green]
> > I need to dump data from database in to *.sql file. I try it using DUMP
> > DATABASE but it not work that I need it.
> >
> > So, how can I dump data from database in to *.sql file and then run it
> > using: osql -E -i nameOfDumpedDat abase.sql[/color]
>
> In Enterprise Manager, find the database, right-click, select All Tasks,
> and in that submenu you find scripting options.[/color]

There is a Java program called Super*SQL which will unload any tables
you have into an ASCII file that you can then run or load into a
different database. For more information visit www.sqlmagic.com.