I have to import all of the data from a MySQL server to SqlServer 2005. What is the best way to go about this? Thanks,
abidshahzad4u
2:59 pm on Jun 15, 2009 (gmt 0)
Use phpMyAdmin to export your whole database structure and data to MS SQL Server supported form.
andrewsmd
3:52 pm on Jun 15, 2009 (gmt 0)
I didn't know phpmyadmin could do that. I don't have it installed but I may for that feature. I ended up making an class that was abstracted enough to go into the database read everything and output the necessary ms sql queries to create the tables with all of the data, could have used your post a lot sooner abidshahzad4u. But thanks, I'll keep that in mind for future reference.
