Go Back > Blogs > prajash2511's blog

User login

Frontpage Sponsor


Where is your Baan/LN hardware located?
On Premise
Hosted Data Center
Cloud (Azure/AWS - Not Infor Cloudsuite)
Infor Cloudsuite
Total votes: 6

Baanboard at LinkedIn

Reference Content

migration from oracle to sql server 2008
By prajash2511 at 4 Aug 2012 - 21:01

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.

No votes yet

by doblev on October 17, 2012 - 10:51am
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>

by jclju1 on October 17, 2012 - 1:20pm
jclju1's picture
Is your application server connected to new database?

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

©2001-2018 - -