RE: MS SQL Data Warehousing and Oracle

From: "Thomas C Mueller" <Thomas C Mueller@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 29 Jul 2005 09:06:03 -0700

Marko,

Microsoft had a webcast on this very topic a few weeks ago. You can find it
at http://tinyurl.com/ay4zy. It is filled with best practices and things to
think about when pulling data from Oracle databases for use in SQL Server.

If you ever decide to migrate from Oracle to SQL Server you should check out
the SQL Server Migration Assistant (SSMA) at
http://www.microsoft.com/sql/migration/default.mspx.

--
Thomas C. Mueller
Business Intelligence Specialist
Berbee Information Networks Corporation

"MC" wrote:

> I'm looking for some advice/tips on implementing DW on SQL server with data
> from Oracle databases. What are the common problems, best practices,
> thingies like that?
>
> MC
.

References:
- MS SQL Data Warehousing and Oracle
  - From: MC

Prev by Date: Relational to DW.?
Previous by thread: Re: MS SQL Data Warehousing and Oracle
Next by thread: DW with WInXP
Index(es):
- Date
- Thread

Relevant Pages

Re: Connet to SQL Server?
... illustrate or show examples of bad practices. ... William (Bill) Vaughn ... > "William Vaughn" wrote: ... >>>I am a newbie to both .Net and Sql Server and I am trying to access the ...
(microsoft.public.dotnet.framework.adonet)
Re: Keeping a DataView in Memory
... ADO and ADO.NET Examples and Best Practices is written for developers transitioning to ADO.NET and has a wealth of fundamental material for those getting started. ... The 7th Edition takes up where the ADO.NET E&BP book leaves off and talks about the ADO.NET that ships with VS 2005 and far more on SQL Server, the tools and how to design successful applications. ... Set your DataView properties to filter or sort as needed. ...
(microsoft.public.dotnet.framework.adonet)
Re: SQL Server Standards Documentation
... >> The purpose of this document is to outline SQL Server standards and best ... These standards and best practices will be used ... >> will allow the DBAs to respond more quickly and proactively. ...
(microsoft.public.sqlserver.server)
Re: To saga
... Use ADO when accessing a client/server (c/s) DB, like SQL Server. ... To make the app flexible, use catalogs for attributes that can vary. ... One thing is to have best practices for ...
(microsoft.public.vb.general.discussion)
MS SQL Data Warehousing and Oracle
... from Oracle databases. ... What are the common problems, best practices, ... thingies like that? ...
(microsoft.public.sqlserver.datawarehouse)