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 December 2007, 06:40
Kshitij Kshitij is offline
Junior Member
 
Join Date: Jul 2007
Posts: 8
Kshitij is on a distinguished road
Baan: BAAN 5c - DB: SQL SERVER 2000 - OS: Windows
ERP LN with SQL Server or Oracle???

Hi All,

We have the company evaluating usage of ERP LN on Sql Server vs Oracle.
If anyone has any specific information about advantages and disadvantages of Oracle over Sql Server?

What are the common problems faced with LN-Oracle and LN-SqlServer

Regards,
KT
Reply With Quote
  #2  
Old 6th December 2007, 04:15
flysurfing flysurfing is offline
Member
 
Join Date: Aug 2007
Posts: 72
flysurfing is on a distinguished road
Baan: Ln 6.1 - DB: Mysql 2005 ENTERPRISE - OS: Windows server 2003
Could you specify how many users will logon on LN ?

Mulder
Reply With Quote
  #3  
Old 7th December 2007, 03:00
Kshitij Kshitij is offline
Junior Member
 
Join Date: Jul 2007
Posts: 8
Kshitij is on a distinguished road
Baan: BAAN 5c - DB: SQL SERVER 2000 - OS: Windows
Around 30-50 users
Reply With Quote
  #4  
Old 7th December 2007, 03:31
alexlow alexlow is offline
Senior Member
 
Join Date: Nov 2006
Location: malaysia
Posts: 102
alexlow is on a distinguished road
Baan: baan until LN - DB: several - OS: both world
which version of mssql, flavor of oracle? other than that you still need to consider the TCO. this debate will never end.
Reply With Quote
  #5  
Old 7th December 2007, 08:10
flysurfing flysurfing is offline
Member
 
Join Date: Aug 2007
Posts: 72
flysurfing is on a distinguished road
Baan: Ln 6.1 - DB: Mysql 2005 ENTERPRISE - OS: Windows server 2003
Frankly speaking take the cheapest one !
Reply With Quote
  #6  
Old 7th December 2007, 09:52
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
Oracle vs MSSQL

In my opinion either of them will do the job.

Things to consider:
- is one of these RDBMS already being used in the company: take that one;
- MSSQL can be received often very cheap if you already use a lot of other MS products;
- with MSSQL you have to stick to windows server, with Oracle you can choose another OS;

Please note that you can use the Oracle Standard Edition version which is a lot cheaper that the enterprise edition. I am not familiar with MSSQL versions/costs.

Regards,
Han
Reply With Quote
  #7  
Old 7th December 2007, 15:13
alexlow alexlow is offline
Senior Member
 
Join Date: Nov 2006
Location: malaysia
Posts: 102
alexlow is on a distinguished road
Baan: baan until LN - DB: several - OS: both world
this comparison doc might be useful.

http://www.wisdomforce.com/dweb/reso...0g_compare.pdf

however my personal opinion is that if you want scalability, have the budget and expertise than go for unix base oracle, if not for fast and easy deploy just choose mssql.
Reply With Quote
Sponsored Links
  #8  
Old 7th December 2007, 21:10
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
Quote:
Originally Posted by Kshitij View Post
Around 30-50 users

Why not Linux / Oracle or even Linux / MySQL then?

Otherwise, Han is right, go with what the site already is familiar with.

If they don't already have DB experts then find out what their other systems are: Windows or Unix. If they're on windows then go with MSSQL
if they're on unix go with Oracle (or informix, db2.. the linux option, whichever)

Basically - the summary - for 30 - 50 users the Database choice is not a concern.

Dave
Reply With Quote
  #9  
Old 8th December 2007, 04:33
Kshitij Kshitij is offline
Junior Member
 
Join Date: Jul 2007
Posts: 8
Kshitij is on a distinguished road
Baan: BAAN 5c - DB: SQL SERVER 2000 - OS: Windows
Thanks guys.

Han, Client doesnt have expertise with Unix. Unix with Oracle is out.
So we will go with Microsoft OS.

Alex, Thanks for the pdf file.

Regards
Kshitij
Reply With Quote
  #10  
Old 12th December 2007, 15:18
benito's Avatar
benito benito is offline
Guru
 
Join Date: Jan 2002
Location: Eastern US
Posts: 514
benito is on a distinguished road
Baan: ERPLn 10.2.1 / BaanIVc4 - DB: Oracle11/Informix - OS: Unix/Linux
of course

I think your company made a better choice. Your user base is too small to invest in a more expensive Oracle and hire a dedicated db admin. Additionally, SQL Server performance had been catching up with Oracle. Don't forget the other perks that came with it also, the Reporting Services (I think it's pretty cool), the Integration Services (seamless interface with Excel and other MS products) and lastly the analysis services.

ben

Quote:
Originally Posted by Kshitij View Post
Thanks guys.

Han, Client doesnt have expertise with Unix. Unix with Oracle is out.
So we will go with Microsoft OS.

Kshitij
Reply With Quote
  #11  
Old 13th December 2007, 04:56
alexlow alexlow is offline
Senior Member
 
Join Date: Nov 2006
Location: malaysia
Posts: 102
alexlow is on a distinguished road
Baan: baan until LN - DB: several - OS: both world
yes, it will be a better choice, also one have to take into consideration the overhead of maintaining multiple login and password environment.

by using mssql you can sync the erpln with AD users account, hence single sign-on conveniently. (with exception having password sync system, yet have limitation)
Reply With Quote
  #12  
Old 4th January 2008, 16:14
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
Quote:
Originally Posted by benito View Post
I think your company made a better choice. Your user base is too small to invest in a more expensive Oracle and hire a dedicated db admin. Additionally, SQL Server performance had been catching up with Oracle. Don't forget the other perks that came with it also, the Reporting Services (I think it's pretty cool), the Integration Services (seamless interface with Excel and other MS products) and lastly the analysis services.

ben
Ben,

Even small companies need a good DBA. I see too often an expensive server with a DBA that had to learn the DB administration by a cheap on line course. None of the database perform when you go for click-click finish! If you do not want to run into trouble a well educated DBA is required whatever database you choose.

Best regards,
Dick
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
  #13  
Old 5th March 2008, 22:14
californialife californialife is offline
Junior Member
 
Join Date: Aug 2007
Posts: 4
californialife is on a distinguished road
Baan: Baan IV c4 - DB: Oracle - OS: Windows NT
We are in the process of upgrading to LN from IVC4, currently on WinNT4 and Oracle 7.3.4. While we like Oracle and had proposed to move to Linux OS (Novell SLES2) and Oracle backend, we are implementing several of the add-on modules like Mobile Service, Workflow, etc., which want to have Windows / SQL. We've just started re-evaluating our path and wondered whether to forego Linux / Oracle or attempt to mix the two. We have a 70 concurrent user setup, about half of which is actually used at any given time. Total named users will ultimately be about 120, but round the world so no heavy loading at any given time. Any thoughts on this, or maybe another forum would be a better place to address this?

Last edited by californialife : 5th March 2008 at 22:15. Reason: Updated info.
Reply With Quote
  #14  
Old 22nd March 2008, 00:34
Dieter's Avatar
Dieter Dieter is offline
Senior Member
 
Join Date: Aug 2001
Location: Germany
Posts: 101
Dieter is on a distinguished road
Baan: ERP LN 6.1 FP3 - DB: Oracle, MS SQL - OS: SuSE Linux, W2K3
Quote:
Originally Posted by californialife View Post
we are implementing several of the add-on modules like Mobile Service, Workflow, etc., which want to have Windows / SQL.
Be aware of the fact that Workflow and Mobile service might require different versions of MS-SQL than ERP LN. Take special attention when you want to implement Windows in a 64-Bit version. Check out the availability of EVERY piece of software you want to run on the machine. Don´t forget the Java versions that are necesarry (e.g. for Workflow). Two different Java environments on one machine could be a pain ...

Oracle on SLES is rock solid. My advice: When you like Oracle run it on SLES and run the other software (Workflow and Mobile Service) on smaller machines (could be PC´s) with Windows.

Regards

Dieter
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
Application Support Analyst - India, Chennai Jothilingam Jobs and Resumes 1 27th March 2010 15:18
Oracle Database 10g and Microsoft SQL Server Head-to-Head Comparison Study NPRao Operating Systems & Databases 1 29th December 2006 23:47
SQL Server 7.0 SP4 + BaanERP compatiblity Jabran Tools Administration & Installation 1 4th October 2004 11:49
SSA ERP-NL / Baan V6 is it Vaporware ? tjbyfield General Discussion & Chat 18 1st October 2004 10:50
Decision Manager & SQL Server 7.0 BisBoy Open World, Portal & Decision Manager 0 10th July 2003 13:11


All times are GMT +2. The time now is 22:59.


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