SSMA for Oracle - have to reenter password

%3CLINGO-SUB%20id%3D%22lingo-sub-3354109%22%20slang%3D%22en-US%22%3ESSMA%20for%20Oracle%20-%20have%20to%20reenter%20password%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3354109%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20using%20SSMA%20for%20Oracle%20and%20am%20prompted%20to%20the%20passwords%20for%20each%20connection%20when%20I%20select%20%22migrate%20data%2C%22%20even%20after%20establishing%20the%20connection%20when%20I%20first%20open%20the%20project.%20I%20have%20converted%20all%20the%20schemas%20already%20and%20am%20just%20migrating%20data%20now.%20An%20example%20of%20the%20steps%20I%20take%20can%20be%20found%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EOpen%20Project%3C%2FLI%3E%3CLI%3EConnect%20to%20Oracle%3C%2FLI%3E%3CLI%3EConnect%20to%20SQL%20Server%3C%2FLI%3E%3CLI%3EDo%20work%20%2F%20configuration%20for%20schema(s)%3C%2FLI%3E%3CLI%3ESelect%20schema%26nbsp%3B%3C%2FLI%3E%3CLI%3ESelect%20%22Migrate%20Data%22%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20I%20select%20Migrate%20Data%20the%20window%20to%20enter%20the%20password%20for%20oracle%20pops%20up%2C%20and%20after%20I%20enter%20that%2C%20the%20window%20to%20enter%20the%20password%20for%20SQL%20Server%20pops%20up.%20Only%20after%20I%20enter%20those%20will%20it%20migrate%20the%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20why%20this%20is%20happening%3F%20The%20documentation%20says%20that%20the%20connection%20should%20stay%20alive%20until%20the%20project%20is%20closed%20or%20I%20choose%20to%20disconnect.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3354109%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Edata%20migration%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello,

I am using SSMA for Oracle and am prompted to the passwords for each connection when I select "migrate data," even after establishing the connection when I first open the project. I have converted all the schemas already and am just migrating data now. An example of the steps I take can be found below:

 

  1. Open Project
  2. Connect to Oracle
  3. Connect to SQL Server
  4. Do work / configuration for schema(s)
  5. Select schema 
  6. Select "Migrate Data"

 

After I select Migrate Data the window to enter the password for oracle pops up, and after I enter that, the window to enter the password for SQL Server pops up. Only after I enter those will it migrate the data.

 

Does anyone know why this is happening? The documentation says that the connection should stay alive until the project is closed or I choose to disconnect.

0 Replies