Oracl 7.34 to SQL 2000

Oracl 7.34 to SQL 2000

Post by Bria » Sat, 27 Oct 2001 13:16:19



Anyone have any pointers or books on migrating data from Oracle 7.34 to SQL
2000?

Thank

Brian

 
 
 

Oracl 7.34 to SQL 2000

Post by FR » Sat, 27 Oct 2001 13:56:05


SQL 2OOO resource kit has most the info you need to get started


Quote:> Anyone have any pointers or books on migrating data from Oracle 7.34 to
SQL
> 2000?

> Thank

> Brian


 
 
 

Oracl 7.34 to SQL 2000

Post by Sue Hoegemeie » Sat, 27 Oct 2001 13:52:52


I did one to SQL Server 7 awhile back and found the
Migration whitepaper helpful. Check out:
http://www.microsoft.com/sql/techinfo/deployment/2000/MigrateOracle.asp

--Sue

On Fri, 26 Oct 2001 00:16:19 -0400, "Brian"


>Anyone have any pointers or books on migrating data from Oracle 7.34 to SQL
>2000?

>Thank

>Brian

 
 
 

1. Connecting to SQL Server 2000 from Oracle versions 7.34 and 8.1.7

I am currently in the design phase of programming a CRM Staging solution
and have a problem connecting from Oracle to SQL Server 2000. The basic
scenario is this:

For phase 1 of the project there will be a Siebel database that will
look after customer creation and updating across four business units
with four separate legacy systems (two on Oracle and two on SQL Server).
When a customer record is created/ updated in Siebel it will pass a
record to the staging database which in turn will determine which legacy
system/s need to be updated. A trigger will fire a stored procedure that
will send the data to the chosen legacy system. I have gained
connectivity to all databases using linked servers.

However, while the two SQL Server systems are able to communicate back
to us I cannot seem to find a way of getting Oracle to talk back to SQL
Server. I have installed Oracle drivers which enabled me to get the
linked server connectivity but our Oracle Dba cannot find a way without
purchasing extremely expensive software (transparent gateway) of getting
Oracle to talk back. Apparently Oracle will not release a new version of
the drivers to enable Oracle to talk to SQL Server. I tried creating a
trigger on an Oracle table from SQL Server but this does not work. I am
using the Microsoft OLEDB libraries.

Does anyone out there have any experience of this type of scenario or
any info as I am starting to worry about the feasibility of the project!

Thanks for reading, any responses will be gratefully received.

Giles.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

2. DBD & insert

3. JDBC 2.0 Driver for Oracle 7.34?

4. OLDDB Vs ADO-3.1 (same performance)

5. Oracle 7.34, 8.x, full outer join syntax

6. VFP3 and NT server errors

7. Personal Oracle 7.34

8. Why OEM (Win) cannot create datafiles > 1GB on AIX?

9. anyone use NBU 3.4 together with infx 7.34

10. VA-Fairfax-259193--ORACLE-Designer 2000-Developer 2000-PL/SQL-ORACLE Forms-ORACL

11. Nationwide-98574--ORACLE-ORACLE Forms-BAAN-Developer 2000-Designer 2000-Oracle Software Specialists