DTS export keeps failing

DTS export keeps failing

Post by Eric » Mon, 20 Oct 2003 03:32:02

I have two SQL servers on our network. One of the servers has a huge
database that we need to move over to the OTHER SQL server on the network. I
am doing a simple export/import DTS package. The database does not exist on
the destination server so I am doing the DTS as "Copy all objects and data"
and instructing it to create the new database. Everything seems to go
smoothly until a certain part in the transfer and then I get the "failed to
transfer" error and when I look at the details, it says "The Text, ntext
and image data types cannot be compared or sorted except when using IS NULL
or LIKE operator". Why would I get this error? I'm just doing an export of
the data from one database into a new database. Does anyone know what this
is? Or maybe have any better ideas? I just need to get the database from one
server to the other. Seems like such a simple thing to do.


DTS export keeps failing

Post by Kesta » Mon, 20 Oct 2003 17:53:15

Why not just doing simple backup - restore..? Just backup your database on
source server, copy backup file to target server and restore it..

Kestutis Adomavicius