Import data from mssql to mysql (for using at c5 site)
Permalink
hi
A client want to import data from a MSSQL Database on o remote server, to C5 Mysql database (for using this data at his website). Data Importing (Sync) should be done on a daily basis.
I was thinking about the methods for implementing such a thing, first thing comes to my mind was creating an automated job to run a script for synchronization.
- first i wanted to know if the whole approach is logical?
- also anyone knows any php library for on way sync between mssql-mysql?
- and could i consider libraries in other languages like python?
A client want to import data from a MSSQL Database on o remote server, to C5 Mysql database (for using this data at his website). Data Importing (Sync) should be done on a daily basis.
I was thinking about the methods for implementing such a thing, first thing comes to my mind was creating an automated job to run a script for synchronization.
- first i wanted to know if the whole approach is logical?
- also anyone knows any php library for on way sync between mssql-mysql?
- and could i consider libraries in other languages like python?
Hello,
Do you consider any 3-rd party tools ?
Sync tool at http://convertdb.com/mssql/mysql... might be helpful.
Do you consider any 3-rd party tools ?
Sync tool at http://convertdb.com/mssql/mysql... might be helpful.
the import script can be written in python, if your server supports it.
You might consider using an extra database, not the concrete5 database, which you can connect to through like described here:
http://www.concrete5.org/documentation/how-tos/developers/connectin...
Greets