thanks I always forget about that tool. It's not much of a db mostly mailing list, was hoping I could go in and just extract the tables in an sql, txt or xml file.
~Dave the disruptor~ "A criminal is a person with predatory instincts who has not sufficient capital to form a corporation." ---------------------------------------- From: Bob Flynn <[EMAIL PROTECTED]> Sent: Saturday, July 16, 2005 9:00 AM To: CF-Talk <[email protected]> Subject: exporting a ms sql db I assume you mean structure, data and all, correct? Have you looked at Aqua Data Studio (ADS)? It's from Aquafold (http://www.aquafold.com/). I have not looked into it's transfer capabilities (since you'll have to deal with the differences between MS SQL and MySQL), but you can connect to both from ADS. You can run it on a Mac and it's free. Very nice all-around Db tool. The only issue we ran into when running it from a Mac to MS SQL Db was the authentication. It acted funny with Windows auth. I haven't tried it in a while though since my Mac teammate left in May. I hope that is at least a start for you. Bob > i have to move a ms sql db to a mysql db, whats the best way? > > Remember I am on a mac and our good friends at m$ don't make cross > platform products (cuz they suck) but I guess I can fire up a pc if > need be. > > Anyone have any good programs to transfer or extract an sql file? I > tried a few but they wont let me transfer to localhost grrrrrrrrrrrr > > ~Dave the disruptor~ > "A criminal is a person with predatory instincts who has not > sufficient capital to form a corporation." > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:212067 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
