Size is of 10gb, and 20 table to be imported to sqlserver

Yes I am using my own database and not system created,

I am doing it in the same way, one by one table each time.

using DTS, very time consuming.

however I thought...

thanks, I have downloaded this software,

steps

1. connected to oracle

2. connected to sqlserver

3. created the user in sqlserver same as oracle one.

4. selected to tables in the oracle to be migrated...

Thanks all,

I was looking for the below code...

select column_name,

table_name,

data_type,

case when i.name is not null then 1 else 0 end as is_identity,

case when k.name is not null then 1 else...