SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    Jan 2002
    Posts
    96
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Arghhh... exporting MS SQL tables to new server...

    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

  2. #2
    SitePoint Guru
    Join Date
    Jan 2001
    Location
    Alkmaar, Netherlands
    Posts
    710
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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

  3. #3
    SitePoint Enthusiast
    Join Date
    Jan 2002
    Posts
    96
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Got it - but one other 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;..
    Last edited by stryka; Jan 23, 2002 at 12:12.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •