export database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carnefrisca@Work - 31 Jul 2008 10:49 GMT

hi to all,
there is a way to export my databases in sql format(data dump?) ?
i don't need to export it like bck.

thank a lot for the answer

Reply to this Message

Uri Dimant - 31 Jul 2008 10:58 GMT

Hi
Do you want to export data as well or only db's structure? What is the
version of SQL Server?

> hi to all,
> there is a way to export my databases in sql format(data dump?) ?
> i don't need to export it like bck.
>
> thank a lot for the answer

Reply to this Message

Carnefrisca@Work - 31 Jul 2008 11:14 GMT

Uri Dimant ha scritto:

> Hi
> Do you want to export data as well or only db's structure? What is the
> version of SQL Server?

SQL Server 2005
I want the db's structure and the data too.

Reply to this Message

Uri Dimant - 31 Jul 2008 11:39 GMT

Well,why don't you want to keep a backup of the database? Perhaps you would
be better of looking at some third party tools such as RedGate to do the job

> Uri Dimant ha scritto:
>> Hi
[quoted text clipped - 3 lines]
> SQL Server 2005
> I want the db's structure and the data too.

Reply to this Message

vinu - 31 Jul 2008 11:03 GMT

hi

see this link might be usefull

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

Signature

vinu
http://oneplace4sql.blogspot.com/

> hi to all,
> there is a way to export my databases in sql format(data dump?) ?
> i don't need to export it like bck.
>
> thank a lot for the answer

Reply to this Message

Plamen Ratchev - 31 Jul 2008 13:48 GMT

The SQL Server Database Publishing Wizard can generate both object and data
scripts:
http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410
-371A838E570A&displaylang=en

Plamen Ratchev
http://www.SQLStudio.com

Reply to this Message