go to the mysql bin directory on the cmd line. mysqldump -u username -p -d databasename > c:\dumpfile.sql password:******
Now go look at that file. It's all the creates and inserts you need. I would assume this would work for you 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 > >Cheers > >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/54 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:205727 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
