SQL Server to Oracle 
Author Message
 SQL Server to Oracle
Does anyone know what the best way to migrate a database from SQL Server to
Oracle is?
SQL Server 7 on windows NT to Oracle 8 on the same server.

Josy



Sat, 13 Apr 2002 03:00:00 GMT
 SQL Server to Oracle

For those interested, I managed to get around this by creating a Microsoft
ODBC for Oracle DSN and using the SQL Server Import/Export Wizard to export
the tables to Oracle.  It took several goes - the first being very
unsuccessful, especially in transferring data, but the next was much better.
Tables that then still would not create I reviewed the data types for both
tablesets and fiddled a bit and eventually it all got through.
Quote:

>Does anyone know what the best way to migrate a database from SQL Server to
>Oracle is?
>SQL Server 7 on windows NT to Oracle 8 on the same server.

>Josy



Sun, 21 Apr 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. GA-Atlanta-98073--DBA Skills-MS SQL Server-ORACLE-Database Administrator (DBA)-SQL Server 6.5 / Oracle

2. GA-Atlanta-98073--DBA Skills-MS SQL Server-ORACLE-Database Administrator (DBA)-SQL Server 6.5 / Oracle

3. GA-Atlanta-97392--DBA Skills-MS SQL Server-ORACLE-Database Administrator (DBA)-SQL Server 6.5/Oracle

4. GA-Atlanta-98073--DBA Skills-MS SQL Server-ORACLE-Database Administrator (DBA)-SQL Server 6.5 / Oracle

5. sql server vs sybase sql server vs oracle

6. MD-Baltimore-86692--ORACLE-ORACLE Tools-MS SQL Server-DBA-Oracle or SQL

7. SQL Server to Oracle (Transact SQL to PL/SQL)

8. Linked Server from SQL Server to Oracle

9. SQL Server and Oracle Server

10. SQL Server with Oracle on the Same Server

11. SQL Server and Oracle on same server?

12. SQL Server have Oracle Parallel Server capability


 
Powered by phpBB® Forum Software