I'm trying to export from Oracle into Sqlserver2005 a database. I can connect and transfer the tables but I'm facing two problems.
I'm using the Import / export mechanism in SqlServer2005
1. Although I'm tranferring the tables I cannot transfer the primary keys and the indexes. How am I suppose to do that? I want to move also the primary keys from Oracle to my Sql server 2005 database
2. Oracle contains a lot of users . For eg. I'm having the same table in different user.
I want to be able to isolate the users retrieved from the import / export connection wizard. How am I suppose to tell Sqlserver 2005 , bring me only for user Myuser ? Is there any way to do that ?
Appreciate any help you could give me.
View Complete Post