Baanboard.com

Go Back   Baanboard.com > Blogs > prajash2511's blog

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

 
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.

0
No votes yet

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

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 16:55.


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