Can I use the Migration Workbench to migrate multiple Microsoft Access databases to a single Oracle user?
Yes. To migrate multiple Microsoft Access databases to a single Oracle user, give all of the Microsoft Access databases the same name. All of the Microsoft Access databases must have the same name because the Migration Workbench uses the name of the Microsoft Access MDB file as the user name for the destination Oracle user. Ensure that all the Microsoft Access databases with the same name reside in different directories from each other. Then, use the Capture Wizard to select the databases for a simultaneous migration. Microsoft Access databases that have been captured in the Source Model appear individually, however, they all appear with the same name. You can identify a database by viewing its path in the Source Model property sheet. When you view the Oracle Model, you see that there is only one user. This user contains all schema objects from the multiple Source Model databases. You can have a Microsoft Access application database that contains linked tables to another Microsoft Acce
Related Questions
- Can I migrate from Microsoft SQL Server or Sybase Adaptive Server to an Oracle7 database using the Migration Workbench?
- Can I use the Migration Workbench to migrate multiple Microsoft Access databases to a single Oracle user?
- How does the Migration Workbench migrate Microsoft SQL Server outer joins to Oracle outer joins?
