I am having a huge issue here! I have a MySQL database that exists on Godaddy. I am developing a .Net application that works off of a MSSQL database. The mssql database is built and the application coming along, however I need a way to merge the MySQL database to MSSQL. Normally this would be a simple task, but the original information contained in the MySQL database is bloated, incomplete, and inconsistent.
In turn, I cannot do a strait conversion. I need a way of producing a select statement from the MySQL database and insert information into MSSQL. Is there a way to communicate between the two data sources in this way?
The original database is still being used, so I need a process that can be tested now, but duplicated later when the application is complete and ready to implement.
In addition, GoDaddy will not allow me to commit stored procedures to the MySql database.