DarkHill
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER