Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 14th October 2005, 10:00
Paul P's Avatar
Paul P Paul P is offline
Guru
 
Join Date: Jul 2002
Location: Jakarta, Indonesia
Posts: 797
Paul P is on a distinguished road
Baan: BaanIV, BaanERP - DB: SQL Server, Informix, Oracle - OS: Windows, HP-UX
Is SQL Server any good?

Hi guys,

Are there many of you out there who use SQL Server with your BaanERP? Is it any good over long run? We found a case where SQL Server was happily serving BaanERP for 3 years until the company data get to 35 Gigs and SQL Server starts giving out "consistency error".

We have since advised the client to put its old data on archive, thus reducing the database size to around 18 Gigs. After that, we haven't received any new "consistency error"

For you guys who are using SQL Server:
  • what is your database size?
  • how many years have you been running your BaanERP company data over SQL Server?
  • do you archive or put everything on the live database?
  • is SQL Server reliable through all the years?
Thanks, guys

Rgds,
Paul
__________________
Pambudi

Visit my technology consulting blog
Reply With Quote
  #2  
Old 14th October 2005, 11:36
Darren Phillips's Avatar
Darren Phillips Darren Phillips is offline
Guru
 
Join Date: Aug 2001
Location: west wales, UK
Posts: 334
Darren Phillips is on a distinguished road
Baan: IV4c4 SCH1 SP14 /AGS2 - DB: SQL7/sql2000/Oracle 9 - OS: NT4 Enterprise / win2000/3
I have a customer running BaanIVc4 SCH1 using sql7 enterprise the database is 18GB, they have been running since 1997 but I only ever keep 2 years live data the rest is archived. May not be a good example as they are only a small site 20 seats
Reply With Quote
  #3  
Old 14th October 2005, 13:19
p.cole's Avatar
p.cole p.cole is offline
Senior Member
 
Join Date: Nov 2001
Location: Portsmouth, UK
Posts: 265
p.cole is on a distinguished road
Baan: Baan IVc4 SP20, ERP LN FP3 - DB: MSSQL 2005 - OS: W2K3
Paul P: Which version of SQL Server was your client running?
Reply With Quote
  #4  
Old 15th October 2005, 06:57
Paul P's Avatar
Paul P Paul P is offline
Guru
 
Join Date: Jul 2002
Location: Jakarta, Indonesia
Posts: 797
Paul P is on a distinguished road
Baan: BaanIV, BaanERP - DB: SQL Server, Informix, Oracle - OS: Windows, HP-UX
Thanks for sharing, Darren. There probably aren't that many companies using SQL Server, huh? I'm starting up a poll on DBMS powering Baan, since no such poll has been started before. Please take part in the poll too. It'll be interesting to find out how many (or few) people use SQL Server . p.cole, my client is on SQL Server 7 too

Rgds,
Paul
__________________
Pambudi

Visit my technology consulting blog
Reply With Quote
  #5  
Old 15th October 2005, 17:48
dave_23's Avatar
dave_23 dave_23 is offline
Guru
 
Join Date: Oct 2002
Location: Portland, OR
Posts: 1,303
dave_23 will become famous soon enough
Baan: All - DB: Oracle / MS SQL / DB2 - OS: All
Hi Paul,

There are quite a few companies using SQL Server. From some statistics
I heard at SSA U MSSQL is 2nd behind Oracle in the baan world...

Dave
Reply With Quote
  #6  
Old 16th October 2005, 00:59
Darren Phillips's Avatar
Darren Phillips Darren Phillips is offline
Guru
 
Join Date: Aug 2001
Location: west wales, UK
Posts: 334
Darren Phillips is on a distinguished road
Baan: IV4c4 SCH1 SP14 /AGS2 - DB: SQL7/sql2000/Oracle 9 - OS: NT4 Enterprise / win2000/3
One thing I have noticed with SQL 7 it seems to operate better if the memory usage is allocated rather than dynamic seems to stay up longer, less reboots required once I turned of dynamic memory usage. I am planning to upgrade them to sql 2000 then I can use the Level 2 baan driver which will save space and hopefully speed it up a bit as it will pass the work of maintaining the indexes to the DBMS.
Reply With Quote
Sponsored Links
  #7  
Old 20th October 2005, 09:22
Paul P's Avatar
Paul P Paul P is offline
Guru
 
Join Date: Jul 2002
Location: Jakarta, Indonesia
Posts: 797
Paul P is on a distinguished road
Baan: BaanIV, BaanERP - DB: SQL Server, Informix, Oracle - OS: Windows, HP-UX
Hi, Dave. Looking at the result of the poll on DBMS powering Baan, seems like you're right

Rgds,
Paul
__________________
Pambudi

Visit my technology consulting blog
Reply With Quote
  #8  
Old 20th October 2005, 18:54
Bob Freedman Bob Freedman is offline
Newbie
 
Join Date: Oct 2005
Posts: 2
Bob Freedman is on a distinguished road
Baan: Baan IV, BaanLN - DB: SQL Server - OS: WIndows 2000
SQL Server

We have been using SQL Server for almost 7 years on both Baan IV and Baan LN. We currently use SQL Server 2000, enterprise edition. Our databases are 59gb and 99gb respectively.

It works, is very low maintenance, we have had so few issues over the years that it's hardly worth talking about. I verify the dumps every morning, and it runs itself.
Reply With Quote
  #9  
Old 20th October 2005, 19:08
dave_23's Avatar
dave_23 dave_23 is offline
Guru
 
Join Date: Oct 2002
Location: Portland, OR
Posts: 1,303
dave_23 will become famous soon enough
Baan: All - DB: Oracle / MS SQL / DB2 - OS: All
ohhh, that would make me feel so lazy =)

Give me db2 any day, so complicated that your boss KNOWS you've
got to be smart!

Dave
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Baan and SQL Server delphin Performance & Tuning 1 21st April 2005 02:51
SQL Server 7.0 SP4 + BaanERP compatiblity Jabran Tools Administration & Installation 1 4th October 2004 12:49
Decision Manager & SQL Server 7.0 BisBoy Open World, Portal & Decision Manager 0 10th July 2003 14:11
Upgrade Baan IV (HP-UX, SQL Server 2000) cfasini Operating Systems & Databases 3 20th May 2003 14:56
Should Baan provide a level 2 database driver for SQL server 2000 on BaanIVc4? patvdv Polls and Surveys 6 28th March 2003 14:22


All times are GMT +2. The time now is 10:30.


©2001-2017 - Baanboard.com - Baanforums.com