Link to home
Start Free TrialLog in
Avatar of DarkHill
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?
ASKER CERTIFIED SOLUTION
Avatar of alain34
alain34
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of DarkHill
DarkHill

ASKER

Perfect, thanks a bunch.