Printable View
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 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... any suggestions are welcomed...
STRYKA:bawling:
backup your database first and then copy backup files and restore on your new server
Try this first and if it does not work, drop me a note
Tried your idea and it worked...
but I actually got it to work another way... appears to have been a version problem... the New host was on SQL 2K and I was using SQL 7x...
so since I couldn't connect via the EM... i was trying to dump via the ODBC... and the BLOB gave errors...
But i upgraded to MS SQL and everything is kewl...
thanx...
However, I am looking to convert to PHP/MySQL. what datatype should i change ntext to so it imports clean into MySQL... or do I have to... i dunno... juss thinking out loud... longterm...
FYI... not all virtual hosts will allow you to do a restore on a backup;..