We are talking about importing from MySQL to MSSQL here, no? I've had a modicum of success in the past by exporting to something like Excel might understand (using DBtools or somesuch), and then importing that file into MSSQL using DTS (if neccessary, making row format alterations in the exported file first).
HTH, Ian ----- Original Message ----- From: "Bryan Stevenson" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Thursday, May 05, 2005 11:06 PM Subject: Re: import from MySQL to MS SQL > >I don't think you can actually expect to export from one database > vender to > >another and not expect to have to tweak a few things. > > Do a simple export/import from access to mysql and see what happens, > it > > ain't disney nor pixel fairy dust, it won't be "exact" or "perfect" > nor > > should you expect it to be. > > I know dave...but 21 tables...and because MySQL has somehow allowed > NULLS in > NOT NULL fields....I think my complaint is warranted ;-) > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > phone: 250.480.0642 > fax: 250.480.1264 > cell: 250.920.8830 > e-mail: [EMAIL PROTECTED] > web: www.electricedgesystems.com/ > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205784 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
