phpMyAdmin export not compatible with MS SQL

Posted on 2008-11-17
Medium Priority
Last Modified: 2012-05-05
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:

(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?
Question by:DarkHill
LVL 16

Accepted Solution

alain34 earned 2000 total points
ID: 22975273
Hello DarkHill,

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



Author Closing Comment

ID: 31517423
Perfect, thanks a bunch.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
It’s a season to be thankful, and we’re thankful for users like you who engage on site, solve technology problems, and network with others in the industry. What tech are we most thankful for? Keep reading.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses
Course of the Month16 days, 11 hours left to enroll

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question