How to create connection in phpmyadmin and msSQL ?

Asked By m williumm 10 points N/A Posted on - 02/04/2013

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

• Status: Open
• Question Views: 888
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: PHP

Best Answer by Zeb Wyman

Go To Solution

Answered By jakir_hh 0 points N/A #169048

How to create connection in phpmyadmin and msSQL ?

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

 

About jakir_hh

Questions
3

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 02/04/2013
• Question Category: PHP

Best Answer

Best Answer

Answered By Zeb Wyman 0 points N/A #169049

How to create connection in phpmyadmin and msSQL ?

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.

About Zeb Wyman

Questions
1

Answers
3

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 02/21/2013
• Question Category: PHP

Answered By Russel C Brannon 10 points N/A #169050

How to create connection in phpmyadmin and msSQL ?

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,

About Russel C Brannon

Questions
8

Answers
99

Best Answers
29

• Vote Up 0 Vote Down

• Posted on - 03/16/2013
• Question Category: PHP