How to create connection in phpmyadmin and msSQL ?

Asked By 10 points N/A Posted on -
qa-featured

Hi Experts

I want to export MSSQL tables to phpMyAdmin. Is there anyway to create phpMyAdmin MSSQL connection? I have tried a lot but positive results. Please share the process of doing it

SHARE
Best Answer by Zeb Wyman
Answered By 0 points N/A #169048

How to create connection in phpmyadmin and msSQL ?

qa-featured

Dear,

At first open your computer then download xampp software and install then open xampp software . run Apache and MySQL. then open your any browser write localhost on title bar and then enter .create your phpmyAdmin

 

Best Answer
Best Answer
Answered By 0 points N/A #169049

How to create connection in phpmyadmin and msSQL ?

qa-featured

Hi Williumm,

To connect MySQL database using phpMyAdmin you can try the following

Open your browser and go to www.HostMySite.com

Click on Control Panel Login

Long into the control Panel as an Account Administrator and select domain or technical contact for the domain.

Then click on MySQL Databases set UserName as database Server address as 10.10.0.229 DB Administration as phpMyAdmin

This should sort you out.

Thank you.

Answered By 0 points N/A #169050

How to create connection in phpmyadmin and msSQL ?

qa-featured

Hello,

Looking at the difference between the two files will show you some things to check out.

mysqldump --compatible=mssql -uroot -p some_database > output_file_mssql.sql

vs

mysqldump -uroot -p some_database > output_file.sql

If you cannot access a way for phpMyAdmin to create an exported file of the right format, then you'll need to edit the resulting exported file to make it work with MS SQL.

If you need to export data frequently, you can find that writing a short text processing script which you can run again as needed and will save your time.

And take care your text editor can properly handle the character encoding of the file generated by phpMyAdmin.

I hope this would help you.
 
Thanks,

Login/Register to Answer

Related Questions