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 19th May 2003, 16:06
cfasini cfasini is offline
Newbie
 
Join Date: May 2003
Posts: 2
cfasini is on a distinguished road
Upgrade Baan IV (HP-UX, SQL Server 2000)

Hi,
I have to upgrade my Baan IV architecture from SP6 to SP11.
At the moment the application is running on UNIX HP-UX server using Baan
database (not databases like Informix, Oracle).
I have to change the database server, I have 3 options:

1) migrate the database to Oracle -> I have to spend a lot of money to
upgrade the UNIX server

2) migrate the database to SQL Server -> In this option the Baan
application remains on UNIX and the database runs on a Windows server, do
you know any issues about it? Are there any problems?

3) Migrate everything to Windows and SQL Server 2000 -> What is your
experience in a Baan system running on Windows 2000 and SQL Server
2000?

Thank you for your help.

Carlo
Reply With Quote
  #2  
Old 19th May 2003, 21:51
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
In my opinion you wrote the same text in alt.baan.com isn't it?

An important question to know when you talk about upgrading is why?

Option 2 is not possible as Baan doesn't have a SQL Server driver on UNIX.

Option 1 and 3 are possible for a small to medium amount of users. For a large amount of users I advise to use a UNIX platform. As you are currently using the baan database I assume you are a small to medium customer so option 1 and 3 fit for you. Dependend on what you want you can choose any of them.

You mentioned that you need a larger machine for Oracle, but when puting Baan and MSQL on the same box you have to buy an even larger machine. Another thing you can consider is to buy a LINUX machine with Oracle on it. Baan can connect to this machine as any other system with Oracle on it as the connection goes via Oracle.

Hope this helps,
Dick
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
  #3  
Old 20th May 2003, 09:51
cfasini cfasini is offline
Newbie
 
Join Date: May 2003
Posts: 2
cfasini is on a distinguished road
Firstly I want to say thank you for your useful advice.

I'm a consultant, my customer have about 40 users on Baan and we would like to have an ODBC connection with the database in order to develop a datawarehouse.
The customer IT manager told me that there are no ODBC connection to Baan database, he can only extract data in a text file, so we are evaluating to use a commercial database (but, if it is too expensive I think that I'll populate the datawarehouse loading data from text file).
Think to put the database server on Linux is a good idea, are you sure that there are no problems about the connection to the database?

Thank you again

Carlo

P.S.
Yes, I wrote the same text on alt.comp.baan.
Reply With Quote
  #4  
Old 20th May 2003, 13:56
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
As the Oracle connection is handled in via the Oracle libs in the Baan database driver is created by Oracle devilers itself, the Baan driver can connect to any other Oracle database on whatever platform.

But, if only a few queries are to be expected it is of course possible to use some Baan tools to query and format the database on whatever you need.

Hope this helps,
Dick
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
Sponsored Links
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
Upgrade From SQL 7.0 To SQL 20000 santosh Operating Systems & Databases 4 12th January 2004 17:01
upgrade to SQL Server 2000 jpadilla Operating Systems & Databases 3 17th July 2003 13:40
BaaN IVc4 installation with SQL 2000 g_Jericho Tools Administration & Installation 3 27th December 2002 07:51
BSP-US (LLC) added as a Baan Education Alliance svandenh General Discussion & Chat 1 20th August 2001 19:44


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


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