I have linked a MYSQL DB to my MSSQL DB and am now required to transfer the data held in MYSQL to the new relevant tables in MSSQL, the only problem is that all the fields in MYSQL have been set to varchar. How can I pull the information from MYSQL and convert it to the required format before putting it into the MSSQL tables?
The query I am trying at the moment but doesn't work is:
(<server>, 'select <DOB> from <table>')
I am also having problems pulling fields which have NULL or blank values into MSSQL using:
(<server>, 'select * from <table>')
Any help or advise would be appreciated!!