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

User login

Frontpage Sponsor


As a Customer What would do to keep your ERP Implementation intact
Proactively define Business Process-- Take the Project Ownership
Handover everything to System Integrator from drawing BP till implementation of ERP
Hire more inhouse skilled & capable IT Resource to work directly with SI
Rely on SI Architects/Consultants
Total votes: 1

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 4th August 2012, 22: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
Old 17th October 2012, 11: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, 14:20
jclju1's Avatar
jclju1 jclju1 is offline
Join Date: Jan 2002
Posts: 584
jclju1 is on a distinguished road
Baan: Baan IV, Baan 5.0c, Infor LN - DB: Oracle, Sql Server, PostgreSQL - OS: Unix, Linux, Windows
Is your application server connected to new database?
Reply With Quote
Sponsored Links

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 08:59
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

All times are GMT +2. The time now is 21:08.

©2001-2018 - -