CK:
I was able to use a form to submit the data (results of DB1 query) as an array in PHP then parse through the rows one by one inserting them in to the second DB!
Thanks so much for your help and suggestions!
omeek
Last Activity: Apr 7 '08, 06:17 AM
Joined: Apr 3 '08
Location:
-
Thanks for the suggestions! I think I'll start with #2 and if that fails, go with option 1.
Thanks!
-OliverLeave a comment:
-
Well, the way it is set up, I pull data from a database (db1) my work uses for thier ticketing software then I have that data inserted in to a table in a different database (db2) on the same server. A seperate database is used because if we were to use a table in the database I am puilling from (db1) it would void our support contract. I am doing this for a "shift hand-off" process where we need to import a list of tickets that are assigned...Leave a comment:
-
Thanks for the info. How do you specify username, password etc.. for multiple databases that have different credentials? I am only familiar with doing a single mssql_connect string to one DB.
I searched Google and, so far, only found how to do a insert/select within the same database. I'll keep searching..and thanks again for your response!Leave a comment:
-
Inserting data from one MSSQL DB to a different MSSQL DB
I'm new to MSSQL (Have used MySQL for a little while) and am completely stuck. I have searched the net for days now and am amazed at how little info is out there for MSSQL.
I am selecting multiple rows from one DB and need to insert those rows in to a table in a different DB and I can not figure out how to do it. Im using PHP. I have not been able to find a function for MSSQL similar to mysql_insert_ar ray.
The SELECT...
No activity results to display
Leave a comment: