![sql server migration assistant sql server migration assistant](https://lh3.ggpht.com/_iMa7JWnVsSY/TTXsXpLv46I/AAAAAAAAABw/OgygleV6RE4/clip_image004_thumb[1].jpg)
On the Oracle DB Server the Oracle listener should have logged the connection request. Your first log into MS SQL Server & run SSMA which then connects to Oracle database. This error frequently results when the logged in USER does not have necessary privilege to access the desired table. Just wondering if any of you might have some experience using SSMA to migrate data over to MS SQL and whether you've encountered something like this before.SQL Server Migration Assistant for Oracle 7.7.0Oracle DB 12.1.0.2.0MS SQL Server 2008 R2 I know that the server I'm using as well as the connection information is correct because I can connect using Oracle SQL Developer. In the logs it says "Inner Exception #1: ORA-00942: table or view does not exist".
![sql server migration assistant sql server migration assistant](https://i.ytimg.com/vi/wPnk23uCVZo/maxresdefault.jpg)
Unfortunately when I try to connect the application errors out saying that an "Error occurred while collecting data". To do this I want to the Microsoft SQL Server Migration Assistant for Oracle (SSMA). 1.7K Training / Learning / CertificationĢ834791 wrote:I'm attempting to migrate some data from one of our Oracle databases to a Microsoft SQL Server.165.3K Java EE (Java Enterprise Edition).
![sql server migration assistant sql server migration assistant](http://www.negox.com/content/img/datacenter-architecture.png)
7.8K Oracle Database Express Edition (XE).3.7K Java and JavaScript in the Database.