SSMA 8.24.0 to migrate an Oracle 9i database to SQL Server 2012

David VANDEVELDE 6 Reputation points
2022-02-03T11:11:02.413+00:00

Hello,

I'm trying to use SSMA 8.24.0 to migrate an Oracle 9i database to SQL Server 2012.
Unable to connect to oracle database (connection string mode) : ORA-01017: invalid username/password;logon denied.

Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.x.xx.x)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=MyServiceName)));User Id=MyUser;Password=MyPass ;

MyServiceName is well declared in tnsnames.ora

Can you help me ? Thank you

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
568 questions
{count} vote

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.