We need to migrate about 200 tables. But when it pulls up the list, it takes
about 20 min.
Not to mention it lists all the accessable tables for that uses causing it
to list about 2000 tables.


Krishna Kandula
Sr. Data Analyst
Oracle Certified Professional DBA
Tiermed Systems LLc.
952 345 2050(O)
317 840 1926(C)


-----Original Message-----
From: Chetan Parmar
[mailto:oracledba-ezmlmshield-x19366898.[Email address protected]
Sent: Friday, December 03, 2004 3:51 PM
To: LazyDBA Discussion
Subject: RE: Migrate tables from Oracle to Sql Server 2000


When you say "really slow" exactly how slow? How many tables/rows are you
migrating and how long did it take?

-----Original Message-----
From: Krishna Kandula
[mailto:oracledba-ezmlmshield-x70765827.[Email address protected]
Sent: Friday, December 03, 2004 4:45 PM
To: LazyDBA Discussion
Subject: Migrate tables from Oracle to Sql Server 2000

Hi Group,
does any one have any experience in migrating tables from Oralce to Sql
server 2000?
We used the Sql Server--Enterprise manager and it is really slow.
I was wondering if there is a good tool on Oracle side.
we have Oracle 9.2.0.4 on Windows 2000 server.

Any suggestion is appreciated.


Thanks

Krishna



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: see
http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree to
these terms:http://www.lazydba.com/legal.html


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page