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
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 5th March 2010, 14:54
Virender's Avatar
Virender Virender is offline
Member
 
Join Date: Jun 2009
Posts: 34
Virender is on a distinguished road
Baan: Baan IV, ERP LN 6.1 FP7 - DB: Oracle, SQL Server - OS: Windows 2008
BaaN IV on Linux with which database
Baan: Baan IVc4
DB: Other/Unknown
OS: Other/Unknown
C/S: None/Unknown

I have following setup and want to know if Linux upgrade is feasible for me or not.

Server Configuration:
HCL INFINITI GLOBAL (2700 MS)
2' INTEL XEON processor 2.60 GHz, 512 MB CACHE INTEL CHIPSET,
RAM 2 GB ECC RAM (512*4), 3'73 GB 10K RPM ULTRA 3 HOT SWAPPABLE SCSI HDD,
RAID CONTROLLER WITH 64 MB CACHE FOR RAID 5
(Both Application and Database installed)

Current OS Server - WIN NT 4 SP 5
Application Ver - BaaN IV SP16
Database - SQL Server 7.0
Current database size approx 40GB.

I want to know -

1. If I can upgrade and migrate to Linux on my current server without any major hardware upgrade.
2. If yes, which Linux distribution (I have read REHL and OpenSuse supported currently).
3. Database - Which database is compatible, Can SQL server be utilised, what about MYSQL, will it able to handle 40GB database size, I need low cost ownership for my BaaN setup, if I go for oracle it will addon heavy license fee, low cost database option available?, disadvantages etc.)

Gurus, Kindly reply.
Vir
Reply With Quote
  #2  
Old 5th March 2010, 19:56
gsurya gsurya is offline
Junior Member
 
Join Date: May 2006
Posts: 7
gsurya is on a distinguished road
Baan: ERPLN - DB: Oracle - OS: Windows
With Baan IV - both Suse and REHL are supported, but database becomes the issue with Baan IV. MySQL is not supported with Baan IV - it is with LN.

Cheapest option is BISAM - but if your 40 GB is in a single company, not sure you want to fall back on that - depends on your number of users etc.

Next cheaper option will be Informix - you will get quite a good deal there - much better than Oracle.

Oracle on Linux also offers better deals than Oracle on other platforms.

You can also save costs on the user desktops by moving that to Open source platform like Ubuntu.
Reply With Quote
  #3  
Old 10th March 2010, 08:16
sushil's Avatar
sushil sushil is offline
Guru
 
Join Date: Jan 2006
Posts: 451
sushil is on a distinguished road
Baan: BAAN IV C4 - DB: Oracle - OS: Windows
Hello,

If you are worried abt Database + OS Costing with Minimum users then Try for Windows Small Business Server .

It comes with many other Applications along with SQL SERVER (Inbuilt).

Regards,
Sushil Kumar Mudaliar
Reply With Quote
  #4  
Old 10th March 2010, 17:03
mig28mx's Avatar
mig28mx mig28mx is offline
Guru
 
Join Date: Nov 2003
Location: Mexico
Posts: 427
mig28mx is on a distinguished road
Baan: IVc4 - DB: Oracle 9i, Oracle10g - OS: HP Unix 11, Intel RedHat ES
Some experience.

Hello, answering your questions:

1. If I can upgrade and migrate to Linux on my current server without any major hardware upgrade.
No problem seen on your current server configuration. Perhaps you will need more RAM. But it depends on the sizing that INFOR will perform for your migration project.

2. If yes, which Linux distribution (I have read REHL and OpenSuse supported currently).
Both distributions are supported by INFOR. I have migrated from HP-UX/9000 to RHES/INTEL successully. So I recommend RH.

3. Database - Which database is compatible, Can SQL server be utilised, what about MYSQL, will it able to handle 40GB database size, I need low cost ownership for my BaaN setup, if I go for oracle it will addon heavy license fee, low cost database option available?, disadvantages etc.)

SQL can be used. MYSQL is not longer support by INFOR. Oracle and DB/2 also. Even Bisam. The big question is: which fits best? On my experience, If you are satisfied with SQL, continue with them.

Oracle is the Rolls Royce of the DB, but expensive. On my case, it worth the cost. I don´t have big problems with the database, performance and stability are great. I have published my path to RHES on the board. Maybe you can take a look.

Hope this helps.
__________________
We talk Baan!
Reply With Quote
Sponsored Links
  #5  
Old 10th March 2010, 18:16
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
I haven't tried it, but IBM's released DB2 community edition. it's free and runs on linux.

http://www-01.ibm.com/software/data/db2/express/

the only downside is:
DB2 Express-C may be run on any sized system with any amount of processors and memory, however DB2 Express-C will limit total resource utilization as follows:
Processor: 2 cores
Memory: 2 GB
Operating Systems:
Linux (32bit, 64bit, POWER)
Windows (32bit, 64bit)
Solaris (64-bit Intel)
Mac OS X (64-bit Intel *beta*)

But if you're whole DB is 40GB you probably don't need much more than this:


Dave
Reply With Quote
  #6  
Old 11th March 2010, 11:09
Virender's Avatar
Virender Virender is offline
Member
 
Join Date: Jun 2009
Posts: 34
Virender is on a distinguished road
Baan: Baan IV, ERP LN 6.1 FP7 - DB: Oracle, SQL Server - OS: Windows 2008
SQL server not supported

Hi Mig

As per your comments, migration looks possible.
But as per Infor, SQL server is not supported on Linux platform.
Can you make it sure how can we use it, do we need to install any package etc to make it compatible.

Thanks
Virender


Quote:
Originally Posted by mig28mx View Post
Hello, answering your questions:

1. If I can upgrade and migrate to Linux on my current server without any major hardware upgrade.
No problem seen on your current server configuration. Perhaps you will need more RAM. But it depends on the sizing that INFOR will perform for your migration project.

2. If yes, which Linux distribution (I have read REHL and OpenSuse supported currently).
Both distributions are supported by INFOR. I have migrated from HP-UX/9000 to RHES/INTEL successully. So I recommend RH.

3. Database - Which database is compatible, Can SQL server be utilised, what about MYSQL, will it able to handle 40GB database size, I need low cost ownership for my BaaN setup, if I go for oracle it will addon heavy license fee, low cost database option available?, disadvantages etc.)

SQL can be used. MYSQL is not longer support by INFOR. Oracle and DB/2 also. Even Bisam. The big question is: which fits best? On my experience, If you are satisfied with SQL, continue with them.

Oracle is the Rolls Royce of the DB, but expensive. On my case, it worth the cost. I don´t have big problems with the database, performance and stability are great. I have published my path to RHES on the board. Maybe you can take a look.

Hope this helps.
Reply With Quote
  #7  
Old 11th March 2010, 12:31
Han Brinkman's Avatar
Han Brinkman Han Brinkman is offline
Guru
 
Join Date: Aug 2001
Location: The Netherlands
Posts: 1,155
Han Brinkman has a spectacular aura aboutHan Brinkman has a spectacular aura about
Baan: All - DB: Oracle/ms-sql/db2 - OS: *nix/windows
Hello Virender,

Look at the technical notes of the portingset for BaanIV, it contains a matrix what databases are supported.

You can use Oracle or Informix. If you can live with the disadvantages of bisam than you can use that too. However if it's still a production server than I recommend to use Oracle (informix is used less and less). If it's only used for archiving you could spare money by using bisam and also by using a non enterprise version of linux although these linux versions are not supported officially by infor.

Regards,
Han
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
How to split Baan Application and Baan Database ? baaniac Operating Systems & Databases 4 2nd June 2009 03:48
Using Baan with Linux jr.ferreira General Discussion & Chat 16 23rd August 2005 15:59
Ervaren Baan specialist ICT Builder Jobs and Resumes 3 5th February 2005 06:37
Baan on Linux patvdv Operating Systems & Databases 62 5th December 2002 14:35
Baan on Linux montanac Operating Systems & Databases 2 30th January 2002 09:29


All times are GMT +2. The time now is 02:01.


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