HELP - exporting database without DTS / Query Analyzer

Y

Yovav

I have an MS SQL account somewhere on the net
and I had problems using DTS for import/export data as
OBJECTs
(which including things like IDENTITY fields and Primary
key...)

Though SP3 is updated on both edges - I just can get a
working solution,

I'm was trying to export Table data & schema using an
amazing Tool I found: WebDataAdmin.msi
on:
http://www.microsoft.com/downloads/details.aspx?
familyid=f0d03472-5e6c-459e-a6d8-
6745a729c3c9&languageid=f49e8428-7071-4979-8a67-
3cffcb0c2524&displaylang=en


But it still gives me hard time on NTEXT fields that has
UNICODE (UTF-8) characters
so the import can NOT work (unrecognized characters...)


Finally:
~~~~~
1. Do U know any other tool like this one that allow
exporting data
(also with UNICODE characters)

2. Do U have an idea how can I fix this (great looking)
Tool from Microsoft
maybe I can tell it to create a UTF-8 file instead of
just ANSI file ? (HOW ?)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,768
Messages
2,569,575
Members
45,053
Latest member
billing-software

Latest Threads

Top