SQL Server 200 to Oracle - problem loading objects
Here's what I've done so far:
1. Download and install SQLDeveloper (C:\Oracle\sqldeveloper 1.2.1.32.13)
2. Create omwbuser (w/ role=dba) in Oracle test database (hc02) (9.2.0.7.0).
3. From Explorer, double-click sqldeveloper.exe
4. File > New > Database connection (clicked Test button, but whatever it was that popped up, disappeared before I could read it.)
5. Assuming it worked, click Connect button. Try a better test "select name from v$database;". Works.
6. Migration > Repository Management > Create Repository ("Repository Built Successfully")
7. Migration > SQL Server Offline Capture > Create Database Capture Scripts.
Choose C:\Oracle\sqldeveloper\sqldeveloper\temp
Generate for Windows Batch File
Microsoft SQL Server (2000)
8. Email scripts to Sql Server dba to execute. Get files back.
9. Copy 16 SS2K_SYS<objectname>S.dat files to C:\Oracle\sqldeveloper\sqldeveloper\temp
10. Migration > SQL Server Offline Capture > Load Database Capture Script Output
Open C:\Oracle\sqldeveloper\sqldeveloper\temp\sqlserver2000.ocp
Window pops up labelled "Capturing Database", but I don't see any entries under "Object Type" or "No of Objects Captured".
Lower down in the pop up window it says "Capture Done".
What am I missing?