You need to create the same structure in SQL server .

You can bcp out the datas from oracle and bcp in the same to SQL. No issues in bcp since the structure is same on both.

You need to manually create the users i think.

There are so many tools available for the migration.(i haven't used any)