470,626 Members | 2,068 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,626 developers. It's quick & easy.

dumping data from database

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 nameOfDumpedDatabase.sql
Thanks for help, greetings, gregory :)
Jul 20 '05 #1
4 9092

"rozrabiak" <br**@maila.pl> wrote in message
news:c6**********@news.onet.pl...
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 nameOfDumpedDatabase.sql
Thanks for help, greetings, gregory :)


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
Jul 20 '05 #2
rozrabiak (br**@maila.pl) writes:
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 nameOfDumpedDatabase.sql


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

--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #3
Erland Sommarskog <so****@algonet.se> wrote in message news:<Xn**********************@127.0.0.1>...
rozrabiak (br**@maila.pl) writes:
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 nameOfDumpedDatabase.sql


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


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.
Jul 20 '05 #4
rozrabiak <br**@maila.pl> wrote in message news:<c6**********@news.onet.pl>...
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.


Hi, you could also look at this article which describes a Java utility
to dump both data and schema information to an SQL file.

http://isocra.com/articles/article.php?id=java_db_dump

We wrote it because we needed to synchronize two remote SQLServer
databases as well as a MySQL development database.

In fact it's pretty easy to integrate it into a JSP to give the same
sort of dumping functionality as phpMyAdmin but for SQLServer.
Jul 20 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by kamal | last post: by
6 posts views Thread by Greg Brant | last post: by
3 posts views Thread by rozrabiak | last post: by
2 posts views Thread by VMI | last post: by
1 post views Thread by Jo Blow | last post: by
11 posts views Thread by davids58 | last post: by
reply views Thread by xpcer | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.