phpMyAdmin export not compatible with MS SQL

I'm trying to export my MySQL data as a bunch of inserts to be run on my MS SQL database. In the past, phpMyAdmin would export it like so:

INSERT INTO table VALUES(1, 2, 3);
INSERT INTO table VALUES(4, 5, 6);
INSERT INTO table VALUES(7, 8, 9);

Which was perfect, however, the current version of phpMyAdmin I am using (2.11.6) exports it like this:

INSERT INTO table VALUES
(1, 2, 3),
(1, 2, 3),
(1, 2, 3);

Which probably takes less space, but is not compatible with MS SQL. How can I make it so it creates an INSERT record for each exported item?
LVL 7
DarkHillAsked:
Who is Participating?
 
alain34Connect With a Mentor Commented:
Hello DarkHill,

Phpmyadmin will enable you to do that. You just need to unselect the tick box 'Extended inserts' prior to running your export.

Regards,

alain34
0
 
DarkHillAuthor Commented:
Perfect, thanks a bunch.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.