prajash2511
4th August 2012, 23:01
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.

doblev
17th October 2012, 12:51
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>

jclju1
17th October 2012, 15:20
Is your application server connected to new database?