Bryan Stevenson wrote: >>Or go the other way, export out of MySQL and import into MSSQL instead of >>pulling in. You should be able to export in many different flavors. >> >> > >The 30 day eval of the MySQL admin tool I'm using only exports 1 table at a >time!!....so I'll go the ODBC route...but thanks Connie > > Check out the free MySQL admin tool - also on the MySQL website (http://dev.mysql.com/downloads/) - the back up options on there should be able to give you an complete export to SQL. You will need to look at the setting to see if you can get it to export in ansi standard SQL rather than ansi with a mysql twist. At the very least you can get a stack of SQL out and tweak it by hand.
I think Intel, Yahoo, Lycos, Associated Press, CISCO, Sony, McAfee, Hewlett-Packard, lastminute.com, Nokia, Nasa ........... would disagree with you on your suggestion that MySQL is not an enterprise solution, but as you say you've made your decision, so I'll leave it at that. ;) Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:205730 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
