how can I tranfer values from mssql to mysql
-
Hi There I need to tranfer the values of a field in MSSQL to fields in MYSQL Basically I have a database table in MSSQL with the following fields: Artist Name Title Plays And in MYSQL table I have the same fields: Artist Name Title Plays I need to transfer the amount of plays from the MSSQL table to the table in MYSQL which at the moment is equal to zero. I thought maybe some sort of Loop statement in my PHP page but am not sure how to lay it out properly and/or how to check the artist name and song title against each other so I don't put the plays in against the wrong artists and song title fields. Thank you for any pointers or advice in advance. Regards Ray
-
Hi There I need to tranfer the values of a field in MSSQL to fields in MYSQL Basically I have a database table in MSSQL with the following fields: Artist Name Title Plays And in MYSQL table I have the same fields: Artist Name Title Plays I need to transfer the amount of plays from the MSSQL table to the table in MYSQL which at the moment is equal to zero. I thought maybe some sort of Loop statement in my PHP page but am not sure how to lay it out properly and/or how to check the artist name and song title against each other so I don't put the plays in against the wrong artists and song title fields. Thank you for any pointers or advice in advance. Regards Ray
We have got an export utility inbuilt with MSSQL 2005 version (Earlier version also having this functionality). Using this utility you can easily transfer table data from one DB to another. On the other hand, if you want to do it pro grammatically then, what you need to do is to create and instance of your mysql server and another instance of your mssql server. Now start reading all the data from MSSQL, put it in a datatable and then when all the rows are finished reading, start transferring them to the instance created of the MySQL table one by one, column by column. Remember that select statement needs to be run for both MySQL and MSSQl table in the start, so as the the table instance are same for both the table during data transfer.
-
We have got an export utility inbuilt with MSSQL 2005 version (Earlier version also having this functionality). Using this utility you can easily transfer table data from one DB to another. On the other hand, if you want to do it pro grammatically then, what you need to do is to create and instance of your mysql server and another instance of your mssql server. Now start reading all the data from MSSQL, put it in a datatable and then when all the rows are finished reading, start transferring them to the instance created of the MySQL table one by one, column by column. Remember that select statement needs to be run for both MySQL and MSSQl table in the start, so as the the table instance are same for both the table during data transfer.
Brilliant thank you very much, sorry so long in replying to your answer. That has helped sort things and I do have a similar question which I will post a new thread for. again thank you for your reply and help Regards Ray