The output directory in the page above is the directory where any log files or generated files will be placed. When we generate DDL or data move files, this is where they will get generated. Next page is the capture page. For using the files from Part 1, we need to choose offline which will then show the page below, which asks us to select the offline capture file.
Monday, 7 October 2013
Convert SQL Server to Oracle using files - Part 2
Ok, Now we have the files as generated and moved in part 1, we can now start SQL Developer to load the files. Start up SQL Developer and create a connection with the following privileges: CONNECT, RESOURCE and CREATE VIEW.