Solved

Get data from MS SQL and insert in MySQL database

Posted on 2013-05-29
3
348 Views
Last Modified: 2013-06-14
Hi,
I have a php page from where I need to query a MS SQL database and insert the results into a MySQL database in tmp tables.
I need to create two separate db connections, one for MS SQL and one for MySQL, however not sure how to proceed further with this.
Can some one point me in the right direction how to proceed further on this.

Thanks,
Mohit
0
Comment
Question by:Mohit_t
  • 2
3 Comments
 
LVL 22

Assisted Solution

by:Om Prakash
Om Prakash earned 250 total points
ID: 39206847
0
 
LVL 108

Accepted Solution

by:
Ray Paseur earned 250 total points
ID: 39207261
These functions might be what you want.  I say "might" because we do not have enough information to answer the question.  The version of PHP matters.  Also, we would need to know whether this is a one-time exercise or if it is something that is going to be repeated in the future.  Both of these DB extensions are potentially short-lived.
http://php.net/manual/en/function.mssql-connect.php
http://php.net/manual/en/function.mysql-connect.php

Going forward, you may find that this is what you need.  
http://php.net/manual/en/function.sqlsrv-connect.php
http://php.net/manual/en/mysqli.construct.php

More information on the removal of MySQL from PHP is available in this article.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/A_11177-PHP-MySQL-Deprecated-as-of-PHP-5-5-0.html
0
 
LVL 108

Expert Comment

by:Ray Paseur
ID: 39246888
Please see the EE grading guidelines.  The "default" grade is A.  You did not offer the follow-on information that was needed.
http://www.experts-exchange.com/help/viewHelpPage.jsp?helpPageID=26

What was so wrong with the answers that you chose to give a marked down grade?  I think we need to hear your explanation. Thanks, ~Ray
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Sql query for filter 12 23
MySQL left join performance 4 15
uploading image to a profile page 1 8
Square brackets 4 0
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
The viewer will learn how to dynamically set the form action using jQuery.

746 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now