Greetings from Serbia,
as subject saids, does anyone had expirience with it?

I need to find a way to export a database, with all tables, and relations if
it is possible to a one or more txt files. This is my first task in this new
company (http://www.netcomp.co.yu/) and only idea which I have to export
table by table to txt file.

Thank you in advance,
Stanko.

If you only want to take the structure then you can look to SQLDMO

http://www.nigelrivett.net/#DMO



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Stanko Milosev" <stanko@-no-s-pa-mmilosev.co.yu> wrote

I need data too. I downloaded Bulk export task and example to export all
tables to csv from http://www.sqldts.com but I get error [SQL-DMO]The Bulk
Copy execution failed.

Thank you,
Stanko.

"Stanko Milosev" <stanko@-no-s-pa-mmilosev.co.yu> wrote

If you want all the tables and data then why not simply do a backup. You
can then restore that to another server and you will have everything.

--
Andrew J. Kelly SQL MVP


"Stanko Milosev" <stanko@-no-s-pa-mmilosev.co.yu> wrote

We need data to be transfered, smallest possible, because connections here
are terrible, so that remote transfer be fastest as possible.


Thank you, once again, for your time,
Stanko.

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

As Andrew has rightly suggested Backup and Restore may be the best and almost certainly the least complicated way of doing this.

Take a look at SQLLiteSpeed as well for compressing backups.



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Stanko Milosev" <stanko@-no-s-pa-mmilosev.co.yu> wrote

One compromise is to conduct a SQL backup to a file, then zip it with the
Maximum option. This may be the best approach. There's a high degree of
compression that can be realized.

Michael


"Stanko Milosev" <stanko@-no-s-pa-mmilosev.co.yu> wrote

I asked about backup, but I get answer that still database is too big, and
it take to long to be sent, is there maybe another way?

Stanko.

"Michael Clifford" <mjclifford (AT) hotmail_nospam (DOT) com> wrote

If you want ALL the data then you don't have much of a choice. If you break
it down and send the data over one table at atime it will take longer than
copying a backup. There is no magic here. Either you need all the data or
you don't. As others have suggested there are products that will compress
the backup (such as SQL LiteSpeed from www.imceda.com) down to about 20% of
the original size. That will make the process much faster.

--
Andrew J. Kelly SQL MVP


"Stanko Milosev" <stanko@-no-s-pa-mmilosev.co.yu> wrote