Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Server 200 to Oracle - problem loading objects

user619067Feb 7 2008 — edited Mar 10 2008
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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 7 2008
Added on Feb 7 2008
11 comments
3,816 views