Web Hosting Talk







View Full Version : Arghhh... exporting MS SQL tables to new server...


spiceman
01-21-2002, 09:49 PM
This is the only forum that I think can help me... cuz the majority of you guyz have done this before... pls read on...

Arghhh... I am dying here... I am changing webhosts and I need to export my existing database/tables to a new SQL server...

but my problem is BLOB datatypes... I tried DTS but i got errors on the BLOBs... I originally created memo fields and set the datatype as nText... what was the proper setting that I should've used...

Can i change the datatype without losing the data and still do the DTS? What can I do... are there other tools... any suggestions are welcomed...

STRYKA
:bawling: