>- see footer for list info -< if you had access to the back end you can use DTS to export to a text file, then use mySql-Front to import it to mySQL, longer way, http://www.unixreview.com/documents/s=8472/ur0307c/ mySql-Front.
You have access to back end if you get http://www.microsoft.com/sql/msde/default.asp which gets a copy of msde 2000 from which you could use dts or a local version of sql 2000 to again use dts to import as text file if you have admin/permissions etc?? Colm -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jolly Green Giant Sent: Thursday, January 27, 2005 3:58 PM To: List - NE CF UG; cfdjlist Subject: [work] [CF-Dev] Moving SQL db to another Host >- see footer for list info -< I am moving to another host. The SQL dbs that I have on the original will be moved to a MySQL db. Now how I'm going to do that is the issue. short text, like names, is not a problem. But I have comment fields, and other text fields that have non-printable characters that should be preserved to the new db. What's the best way to do this when I don't have access to the back end? I'll just have to rely on CF to do the export/importing. Some of the options I've thought of... I could use WDDX to serialize the query. I could use tobase64 to convert the data to create a text export file. David /JGG _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 0504-2, 01/27/2005 Tested on: 1/27/2005 5:55:02 PM avast! - copyright (c) 1988-2004 ALWIL Software. http://www.avast.com _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
