I have an MSSQL database on my server, which I update regularly. I have a view on this database that I want to regularly export from MSSQL and import into a MYSQL database. This MySQL database is hosted on iPage hosting. One option I was given to do this was to select a particular SQL format (MSSQL) on phpmyadmin, but iPage does not offer this (or any) option on the import screen.
I tried creating a CSV file for the data, but it didn't import properly One problem with the data is that it contains a large text field that contains HTML, commas, quotes, etc.
Any suggestions that would work quickly on a regular basis? I can access the MSSQL file via MSACCESS 2007 or MS Server management studio 2014. I also have a CSM and can export in EXCEL, HTML, or XML.