asked on MSSQL to MYSQL conversion
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.
Thank you.
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.
Thank you.
MySQL ServerMicrosoft SQL Server
Last Comment
Lev Seltzer
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Lev Seltzer, do you still need help with this question?
ASKER
Thank you. Your solution was a bit complicated, and I was hoping someone else would respond.