Baanboard.com

Go Back   Baanboard.com > Forum > CMS - Forum Integration > Blogs and Web links

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 4th August 2012, 23:01
prajash2511 prajash2511 is offline
Newbie
 
Join Date: Aug 2012
Posts: 1
prajash2511 is on a distinguished road
Baan: 6 - DB: ORACLE - OS: rhel
migration from oracle to sql server 2008

A new blog entry has been added:

migration from oracle to sql server 2008

Quote:
Dear Guru,
We are planning to migrate from Oracle db 10g to SQL server 2008 R. production server is  on linux. we take .s backup on daily basis.
we have created empty  tables (database) in sql server 2008 R2. Now we want to import this .s backup on this new windows server. 
How can we do that ? any help will be really appreciated. 
How to import (.S) backup.
Reply With Quote
  #2  
Old 17th October 2012, 12:51
doblev doblev is offline
Junior Member
 
Join Date: Feb 2012
Posts: 3
doblev is on a distinguished road
Baan: all - DB: all - OS: all
Answer

Quote:
Originally Posted by prajash2511 View Post
A new blog entry has been added:

migration from oracle to sql server 2008
You have to use the command bdbpost to import the table in the new environment and use the same field separator that you used to export the table, for example:

bdbpost -Kmnf -t"|" -D <Directory of .S file> -c<Company>
Reply With Quote
  #3  
Old 17th October 2012, 15:20
jclju1's Avatar
jclju1 jclju1 is offline
Guru
 
Join Date: Jan 2002
Posts: 555
jclju1 is on a distinguished road
Baan: Baan IV, Baan 5.0c, SSA ERP LN 6.1 - DB: bisam, Oracle, Informix, Sql Server - OS: Unix (all), Windows
Is your application server connected to new database?
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 On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Baan 5.0c : Move from Oracle to SQL Server NAB_BED Tools Administration & Installation 3 2nd May 2011 09:59
ERP LN with SQL Server or Oracle??? Kshitij Operating Systems & Databases 13 22nd March 2008 01:34
Oracle Database 10g and Microsoft SQL Server Head-to-Head Comparison Study NPRao Operating Systems & Databases 1 30th December 2006 00:47
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


All times are GMT +2. The time now is 00:37.


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