Anyone experience with importing Oracle SQL tables in MS SQL 7.0, is
this a natural progression.
I have to setup a data warehouse in SQL 7.0 built from Oracle tables,
any suggeston or ideas on what to look out for??
Lajos
by Lajos G. Gu » Thu, 03 Aug 2000 04:00:00
I have to setup a data warehouse in SQL 7.0 built from Oracle tables,
any suggeston or ideas on what to look out for??
Lajos
by Karste » Tue, 08 Aug 2000 04:00:00
You can connect both databases in realtime. And you can have your oracle
database still operative during filling your datawarehouse.
Karsten
Quote:> Anyone experience with importing Oracle SQL tables in MS SQL 7.0, is
> this a natural progression.
> I have to setup a data warehouse in SQL 7.0 built from Oracle tables,
> any suggeston or ideas on what to look out for??
> Lajos
by Trey Johnso » Tue, 08 Aug 2000 04:00:00
Yes. We have had positive experiences transforming data from Oracle to SQL
Server. If the move has limited data transformations or none then you can
move it to your production SQL Server tables. Otherwise, you should stage
the data in a separate set of relational tables or text files.
You will want to use the Microsoft Supplied ORACLE driver.
Trey Johnson
Encore Development
Quote:> Anyone experience with importing Oracle SQL tables in MS SQL 7.0, is
> this a natural progression.
> I have to setup a data warehouse in SQL 7.0 built from Oracle tables,
> any suggeston or ideas on what to look out for??
> Lajos
by Vasu » Thu, 19 Oct 2000 04:00:00
How did you do this.
> You will want to use the Microsoft Supplied ORACLE driver.
> Trey Johnson
> Encore Development
> > Anyone experience with importing Oracle SQL tables in MS SQL 7.0, is
> > this a natural progression.
> > I have to setup a data warehouse in SQL 7.0 built from Oracle tables,
> > any suggeston or ideas on what to look out for??
> > Lajos
1. Opinions Please: MSSQL 7.0 & Oracle 7.2/7.3
Instead of connecting "real-time" to the Oracle 7.2/7.3 data files
sitting on the Unix server my thought is to have these files FTP'd
from the Unix box onto my Windows 2000 Server and then have MSSQL DTS
services perform the connect, mapping etc.
I reviewed the DTS services and when setting up an ODBC or OLEDB
driver for Oracle it wanted the Oracle server name, password etc. I'm
truly not planning on running the Oracle server on my Windows 2000 box
just having the data files residing there.....
Any thoughts from the "seniors" in the crowd....
Lajos
2. how to arrange the steps precedence in dts?
3. Database Consultant - 5 years DBA, Oracle 6 - 7.2 - 7.3, PL/SQL, UNIX, backup/recovery - NE
4. SQR
6. Re- Combo Box Within A Grid.txt
7. Oracle 7.3 performance vs. Oracle 7.2 performance