Oracle to SQL Server Migration using Server Migration Assistant for Oracle V2.0 - Help Needed

Hi all,

I am basically a front end guy and we need to do a dB migration from Oracle 9i to SQL Server (sitting in a shared environment).

For the start we wanna try out this tool. This tool provided by the MSN comes along with an extension pack that needs to be installed along with the tool.

http://www.microsoft.com/downloads/details.aspx?FamilyId=E35CEE88-C919-463F-B020-81468CD231DA&displaylang=en

It’s mentioned there that

Server component installation:
Locate a SQL Server machine which you want to migrate to. Run SSMAExtPack.exe on that machine locally.It will install a sysdb database with procedure and functions that emulate some of the Oracle system packages. You don't need to do anything on the server machine. All conversion tasks are done from the client SSMA tool.

Concern:

Since ours is a SQL server in a distributed environment it wont be possible for us to install the extension pack in all the systems that hosts the SQL server.

Queries

1) Is it necessary to install the extension pack in all the system our SQL Server is sitting?

or

2) Would it work if we install the tool in a separate system that holds the <extension pack+msn migration tool>, SQL Client and the Oracle client alone and complete the DB migration?

I need suggestion from the MSN tech support or anyone else with prior experiece whether its feasible to use the tool for our DB migration.

Note: Our Oracle DB contains only Tables and Indexes and there are no stored procedures. All the queries are dynamically built from the front end itself.

Sorry if I had posted this question in a wrong forum. I am new to this DB migration stuff.

If you cannot install the SQLpack on shared SQL, then you can try installing SSMAExtPack.exe on a client machine and create an empty database for the tables from Oracle, then arrange to port those tables back to shared SQL server.|||

Thanks Sathya for the suggestion..

So I reckon we need to create a DB on a stand alone SQL Server and transfer the tables and indexes from Oracle using the migration assistant.

From the standalone DB we need to transfer it to the shared environment. How do we migrate the tables from a standalone DB to the shared environment?

Can we use the SQL Server Data Transformation Services to migrate from temp SQL server DB to the shared environment or can you suggest any other tool provided by MSN you can suggest?

|||DTS is your friend in this case to transfer the data, but make sure to script out any triggers or SPs associated in this migration.