export table with text and ntext fields

hello,
i have to export more tables. This tables has all kind of fields
(date,text,ntext ...)
What is the best way to export this data so that the data could be later
imported on a other server ...(CSV? ....)
any ideas?
thanks
XavierDid you try using DTS?
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"Xavier" <Xavier@.discussions.microsoft.com> wrote in message
news:0CDC2879-14FF-4CA6-A947-CD4B5650F683@.microsoft.com...
> hello,
> i have to export more tables. This tables has all kind of fields
> (date,text,ntext ...)
> What is the best way to export this data so that the data could be later
> imported on a other server ...(CSV? ....)
> any ideas?
> thanks
> Xavier
>|||yes - but i could not use it - because the customer did not allow dts...
I have to use only T-Sql cmds ...which the customer eill run on his server
in the Q-Analyser , so my question is:
if i have a table 3 fieldtypes (date/text/ntext) - and i want to save the
values in a flatfile(csv?) how can i do this - and what delimiter should i
use? - to be sure that the content can be restored on the other side ...
thanks
"SriSamp" wrote:

> Did you try using DTS?
> --
> HTH,
> SriSamp
> Email: srisamp@.gmail.com
> Blog: http://blogs.sqlxml.org/srinivassampath
> URL: http://www32.brinkster.com/srisamp
> "Xavier" <Xavier@.discussions.microsoft.com> wrote in message
> news:0CDC2879-14FF-4CA6-A947-CD4B5650F683@.microsoft.com...
>
>|||You will then have to use BCP.
Check these sources to get started on the same:
http://www.databasejournal.com/feat...cle.php/3391761 and
http://www.sql-server-performance.com/bcp.asp
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"Xavier" <Xavier@.discussions.microsoft.com> wrote in message
news:58F11DD1-840C-4F0C-BC69-C5EECA49B3D0@.microsoft.com...
> yes - but i could not use it - because the customer did not allow dts...
> I have to use only T-Sql cmds ...which the customer eill run on his
> server
> in the Q-Analyser , so my question is:
> if i have a table 3 fieldtypes (date/text/ntext) - and i want to save the
> values in a flatfile(csv?) how can i do this - and what delimiter should
> i
> use? - to be sure that the content can be restored on the other side ...
> thanks
>
>
>
> "SriSamp" wrote:
>|||Surely there is an out to text file in QA?
SriSamp wrote:
> You will then have to use BCP.
> Check these sources to get started on the same:
> http://www.databasejournal.com/feat...cle.php/3391761 and
> http://www.sql-server-performance.com/bcp.asp|||Yes, there is. But if you are exporiting (N)TEXT, am not sure of the length
of these in the tables that are mentioned, since QA limits the max
characters to around 8K.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"Adrian Edwards" <abc@.abc.com> wrote in message
news:dlatvb$4rh$1@.nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com...
> Surely there is an out to text file in QA?
> SriSamp wrote:|||thanks for the suggestion,
it works well...
My only problem is what shell i do if the content of ntext is larger then 8
k
best regards
Xavier
"SriSamp" wrote:

> You will then have to use BCP.
> Check these sources to get started on the same:
> http://www.databasejournal.com/feat...cle.php/3391761 and
> http://www.sql-server-performance.com/bcp.asp
> --
> HTH,
> SriSamp
> Email: srisamp@.gmail.com
> Blog: http://blogs.sqlxml.org/srinivassampath
> URL: http://www32.brinkster.com/srisamp
> "Xavier" <Xavier@.discussions.microsoft.com> wrote in message
> news:58F11DD1-840C-4F0C-BC69-C5EECA49B3D0@.microsoft.com...
>
>