SQL 2000 Enterprise

Author Message

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/

Andreas Kaiser

Thursday 05 July 2007 3:12:19 am

Thanks!

We will use it only for reading... so there should be no problem...

eZ Partner in Madrid (Spain)
Web: http://www.atela.net/

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.