Go Back > Forum > CMS - Forum Integration > Blogs and Web links

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 39

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 4th August 2012, 23:01
prajash2511 prajash2511 is offline
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

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
Sponsored Links
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

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
Old 17th October 2012, 15:20
jclju1's Avatar
jclju1 jclju1 is offline
Join Date: Jan 2002
Posts: 561
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

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 05:26.

©2001-2017 - -