Export database to a txt file. -- sql server dts

sql server dts : Export database to a txt file.

Andrew J. Kelly
2/13/2005 4:10:32 PM

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

[quoted text, click to view]

Allan Mitchell
2/13/2005 6:46:31 PM

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

[quoted text, click to view]

Stanko Milosev
2/13/2005 7:38:41 PM

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.

Stanko Milosev
2/13/2005 8:08:28 PM

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.

[quoted text, click to view]

Allan Mitchell
2/13/2005 9:47:59 PM

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

[quoted text, click to view]

Stanko Milosev
2/13/2005 10:36:17 PM

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.

[quoted text, click to view]

Michael Clifford
2/14/2005 8:03:13 AM

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

[quoted text, click to view]

Andrew J. Kelly
2/15/2005 12:18:16 AM

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

[quoted text, click to view]

Stanko Milosev
2/15/2005 1:09:20 AM

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.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

View Other Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007

home · blog · groups

Questions? Comments? Contact the dn