> I need to do an extract and conversion of some data from an older
> windows-based MS-SQL legacy system managed by another company, into
> our existing cake-based LAMP system.
>
> I don't think the data volume is very high. A few thousand rows, tops.
> All English. Simple product data.
>
> Has anyone gone through a similar exercise?
>
> I've thought of the following possibilities:
>
> - Export of the legacy tables as XML, process them using cake's XML
> library, and save into our cake-base LAMP system, or
> - import their XML into MySQL as is, and do the conversion entirely in
> SQL, or
> - use cakeDC's migration plugin (not sure it is even applicable to non-
> cake databases)
> - some other way??
>
>
> Any suggestions on the easiest way to approach this?
>
I'd try to migrate directly, without any XML. Get the data into a temp
mysql db and then write a quick PHP (Python, Perl, etc.) script to
finesse that into another, Cake-specific DB.
Check out this page:
http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html
Google should provide a lot of other info. I think there are likely
several tools to choose from.
Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
No comments:
Post a Comment