Forums / Developer / SQL 2000 Enterprise

SQL 2000 Enterprise

« 
Previous topic
|
Developer
|
Next topic
 »
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/

eZ debug

Timing: Jan 21 2025 16:11:48
Script start
Timing: Jan 21 2025 16:11:48
Module start 'content'
Timing: Jan 21 2025 16:11:48
Module end 'content'
Timing: Jan 21 2025 16:11:48
Script end

Main resources:

Total runtime0.1369 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0057 588.7422180.8438
Module start 'content' 0.00570.0055 769.585993.7422
Module end 'content' 0.01130.1255 863.3281522.1094
Script end 0.1368  1,385.4375 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00352.5636200.0002
Check MTime0.00130.9804200.0001
Mysql Total
Database connection0.00090.658210.0009
Mysqli_queries0.090165.83911410.0006
Looping result0.00110.79611390.0000
Template Total0.125291.510.1252
Template load0.00070.512710.0007
Template processing0.124590.967410.1245
Override
Cache load0.00050.368210.0005
Sytem overhead
Fetch class attribute can translate value0.00120.902210.0012
XML
Image XML parsing0.00030.183910.0003
General
dbfile0.00805.8456200.0004
String conversion0.00000.003030.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs