Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Performance & Tuning

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 25th September 2009, 17:25
wjhale wjhale is offline
Junior Member
 
Join Date: Jul 2004
Location: Brookville, PA
Posts: 5
wjhale is on a distinguished road
Baan: IV c3 - DB: SQL Server 2008 - OS: Windows 2003
Post Moving from Oracle to SQL Server
Baan: Baan IVc3
DB: Oracle 10.2.0.x
OS: Windows 2003
C/S: Server

We have been operating for over ten years is a Baan IVc3/Oracle/Windows environment quite successfully. We are throwing arround the idea of moving from Oracle over to SQL Server 2008 to reduce the number of database systems we are maintaining and possibly reduce cost. I'm interested in hearing opinions on changing database platforms and methods to do so. Currently, I'm under the impression that to make this move would require exporting/importing Baan companies. Any ideas would be apreciated
Reply With Quote
  #2  
Old 26th September 2009, 10:34
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
correct

You are correct, you have to export and import your whole database.
Furthermore I like you to advise to contact Infor, they can offer special ASFU licenses which are normally cheaper. They can do this as well for Oracle.

Regards,
Han
Reply With Quote
  #3  
Old 28th September 2009, 05:39
vinceco252's Avatar
vinceco252 vinceco252 is offline
Guru
 
Join Date: Mar 2002
Location: Frederick, CO
Posts: 391
vinceco252 is on a distinguished road
Baan: Baan IVc3, IVc4, 5b, 5c, ERP LN 6.1, Infor ERP 10.x - DB: SQL Server, Oracle - OS: Windows, Linux, HPUX, AIX, (a little bit of) Solaris
I've done this for 3 customers this year (to SQL 2005, anyway...). If you would like assistance/advice, please feel free to contact me at vmurphy@ostusa.com.

Vince
__________________
Vincent Murphy
---------------
Senior ERP Consultant
OST
vmurphy@ostusa.com
Reply With Quote
  #4  
Old 28th September 2009, 06:51
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
Guru
 
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,855
Hitesh Shah is on a distinguished road
Baan: triton,Baan IVc4 , ERP Ln - DB: Oracle/Bisam/SQL 2000/SQL 2005 - OS: Sun Solaris/Windows 2003
part check list

Some of the points to take care off
1. Separate harddisks for logs and dbf files to ensure good performance
2. Good memory for sql server
3. Jobs to create online backups and create /update stats
4. Mapping baan users to sQL,db creation ,assognment of tables to database
5. Installation as per baan guide like sort mode , db ownership /roles
6. Configuration of msql parameters
7. Proper table sharing across companies to avoid extra table creations
8. If possible , leave archive companies in Oracle only to keep SQL lean and mean
9. Availability of msql commercial function in baan license else re-validate the same .
Reply With Quote
  #5  
Old 28th September 2009, 15:11
wjhale wjhale is offline
Junior Member
 
Join Date: Jul 2004
Location: Brookville, PA
Posts: 5
wjhale is on a distinguished road
Baan: IV c3 - DB: SQL Server 2008 - OS: Windows 2003
Thank you all for your input! It is much what I expected, but it is good to hear it from someone else. I expected the full database export/import. I believe the real pain in all of this will be convering the Baan users from Oracle to SQL Server security. Again, many thanks!
Reply With Quote
Sponsored Links
  #6  
Old 28th September 2009, 16:13
vinceco252's Avatar
vinceco252 vinceco252 is offline
Guru
 
Join Date: Mar 2002
Location: Frederick, CO
Posts: 391
vinceco252 is on a distinguished road
Baan: Baan IVc3, IVc4, 5b, 5c, ERP LN 6.1, Infor ERP 10.x - DB: SQL Server, Oracle - OS: Windows, Linux, HPUX, AIX, (a little bit of) Solaris
There are pretty easy ways to script the login creation on the SQL side. Just need to make sure to populate the ttdba tables correctly.

Vince
__________________
Vincent Murphy
---------------
Senior ERP Consultant
OST
vmurphy@ostusa.com
Reply With Quote
  #7  
Old 28th September 2009, 21:53
wjhale wjhale is offline
Junior Member
 
Join Date: Jul 2004
Location: Brookville, PA
Posts: 5
wjhale is on a distinguished road
Baan: IV c3 - DB: SQL Server 2008 - OS: Windows 2003
Are there particular features in SQL Server Enterprise Edition that makes it more friendly for Baan than Standard Edition?
Reply With Quote
  #8  
Old 29th September 2009, 06:11
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
Guru
 
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,855
Hitesh Shah is on a distinguished road
Baan: triton,Baan IVc4 , ERP Ln - DB: Oracle/Bisam/SQL 2000/SQL 2005 - OS: Sun Solaris/Windows 2003
features

Exact differences can be had here .

If u are satisified with 2 node clustering failover and other high availability/scaleability feaures , dont want point in time restore at row level and do not have immediate need for advanced needs for BI / Reporting , u may use standard edition.

Currently we use standard edition only.
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
ERP LN with SQL Server or Oracle??? Kshitij Operating Systems & Databases 13 22nd March 2008 00:34
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
Decision Manager & SQL Server 7.0 BisBoy Open World, Portal & Decision Manager 0 10th July 2003 13:11
Date Field Error during Load Oracle Data into Microsoft SQL server through ODBC wangxn Tools Administration & Installation 2 11th April 2002 14:07


All times are GMT +2. The time now is 05:03.


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