Hi J.DBA,
Have you installed the SSMA extension pack?
SSMA extension pack supports data migration, and Oracle providers to enable server-to-server connectivity.
>>I have one table with two rows in oracle, but SSMA updating all schema
from oracle.
You can select the schema that you want to migrate in Oracle Metadata Explorer.
Please refer to the following tutorials which might help:
How to Install SQL Server Migration Assistant for Oracle – Part 1
How to Install SQL Server Migration Assistant for Oracle Extension Pack – Part 2
Using SSMA for Oracle to migrate into SQL Server
Best Regards,
Amelia
""SQL Server related"" forum will be migrated to a new home on
Microsoft Q&A SQL Server!
We invite you to post new questions in the "SQL Server related" forum’s new home on
Microsoft Q&A SQL Server
!
For more information, please refer to the
sticky post.