Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Urgent: SQL Server Migration Assistant For Oracle

Author  Topic 

shaihan
Starting Member

20 Posts

Posted - 2007-09-29 : 00:41:33
i am transfering an Oracle 10g database to SQL Server 2005. i have 2 pcs one with SQL Server 2005 with SSMA For Oracle Extension 3.1 installed, also with Oracle 10g client configured to connect the Oracle database in another pc. the other pc has Oracle 10g database server installed with SSMA For Oracle 3.1. whenever i try to migrate the data there is an exception which says

"Errors: SQL Server cannot access the source table"

i dont understand why its there. i hav successfully converted the schema and loaded them in SQL Server. can anybody tell me a soltuion asap.

S ]-[ /-\ | ]-[ /-\ N

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-29 : 00:52:57
Microsoft has knowledge base article for that, search their web.
Go to Top of Page
   

- Advertisement -