February 11, 2025 at 7:44 pm
Hi,
I am using the SSMA for Oracle v10.0. I have installed the SSMA for Oracle extension pack on the server that the SQL Server 2022 instance is running. The database 'sysdb' was created on the instance and I can successfully execute the 'Migrate Data' on the SSMA on this server.
However, if I re-run the SSMA on my laptop to refresh one table's data, the 'Migrate Data' get nothing migrated.
Starting data migration Engine
Data migration operation has finished.
0 table(s) successfully migrated.
0 table(s) partially migrated.
1 table(s) failed to migrate.
The default migration engine is "Server Side Data Migration Engine". When I change the migration engine to "Client Side Data Migration Engine" and execute 'Migrate Data' again, I get the following error:
Could not load file or assembly 'Oracle.ManagedDataAccess, Version=3.1.21.1, Culture=neutral, PublicKeyToken=89b483f429c47342'. The system cannot find the file specified.
My laptop has Oracle client installed and the client is the same version that I installed on the server. This Oracle client is working fine and I can verify the connection via Oracle SQL*Plus.
I don't want to login to server and just want to use my laptop to execute SSMA.
Is there anyone can help?
Thank you,
Zheng
February 12, 2025 at 8:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
March 5, 2025 at 1:36 pm
It looks like the issue is related to missing or incompatible assemblies on your laptop. The error suggests that Oracle.ManagedDataAccess cannot be found, which is required for SSMA to connect to Oracle.
Ensure the correct version of Oracle.ManagedDataAccess.dll is installed. Check if the DLL exists in your laptop’s GAC (Global Assembly Cache) or application directory. You may need to install or update the Oracle Managed Data Access package.
Download and install Oracle.ManagedDataAccess from NuGet or Oracle’s official site to match the version used on your server.
Ensure SSMA is installed correctly, including the necessary drivers and dependencies.
If none of these work, try running SSMA in administrator mode or reinstalling the extension pack to make sure all dependencies are properly set up.
March 7, 2025 at 10:22 pm
Update:
This error message was misleading. My laptop has correct Oracle client installed.
I found out the solution that disable the 'clr strict security'. This option was enabled by default.
Then synchronize the two Assemblies from SSMA SQL Server Metadata Explorer panel.
SSMA4OracleSQLServerCollections.NET
SSMA4OracleSQLServerExtensions.NET
Check the assemblies are created on corresponding database on SQL Server.
Then data can be loaded from Oracle without problem.
Thanks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply