How does the Migration Workbench migrate Microsoft SQL Server outer joins to Oracle outer joins?
The Migration Workbench does not convert full outer joins to an Oracle database. The Migration Workbench converts a SQL Server inner join to an Oracle join as illustrated in the following code example: select * from a inner join b on a.col1=b.col2; select * from a , b where a.col1=b.col2; The Migration Workbench converts left joins and right joins in SQL Server to an Oracle database, for example: select * from a left join b on a.col1=b.col2; remember the table to the right of left join and add (+) to it’s columns. select * from a, b where a.col1=b.col2(+); select * from a right join b on a.col1=b.col2; remember the table to the left of right join and add (+) to it’s columns. select * from a, b where a.col1(+)=b.
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?
