Forums / Developer / SQL 2000 Enterprise
Andreas Kaiser
Wednesday 04 July 2007 3:24:30 am
We have some tables in a SQL 2000 version 8.00.2039 (Enterprise Manager Edition) which should be read by ezp. We have been looking for the MSSQL Database Extension, but it seems not to be compatible.
So the solution seems to convert these tables to a MySQL database... The problem is that the MSSQL database is update every week, so a syncronation is needed (cron?)...
Anyone knows a good translations script or an alternate solution for this?
Anyone had experience with a similar scenario?
Thanks in advance
eZ Partner in Madrid (Spain) Web: http://www.atela.net/
Björn Dieding@xrow.de
Wednesday 04 July 2007 6:52:35 am
http://projects.ez.no/mssql use this....
We have released the mssql plugin under open source but didn`t tell anyone yet.
This extension should be able to read and write to sql2000 unless you use something like persistent objects...
Unfortunatelly we had to remove the eZ MSSQL 2000 support in favoir for the great 2005. But like i said. Usual queries should work fine.
Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs Looking for hosting? http://hostingezpublish.com ----------------------------------------------------------------------------- GMT +01:00 Hannover, Germany Web: http://www.xrow.com/
Thursday 05 July 2007 3:12:19 am
Thanks!
We will use it only for reading... so there should be no problem...