Re: Up to date data in warehouse

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Michael Vardinghus (michaelvardinghus_at_hotmail.com)
Date: 10/25/04 

Date: Mon, 25 Oct 2004 21:19:30 +0200

Thanks Allan

Can replication only be used between sql servers ? what if host is Oracle ?

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:urUezUsuEHA.2724@TK2MSFTNGP12.phx.gbl...
> Up to date to me means very little latency between the source(s) and the
> warehouse
>
> It all comes down to how must time you can afford to leave.
>
> DTS is not good for Realtime
> Replication is good for realtime
> Rolap is good for realtime.
>
>
>
>
>
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.konesans.com - Consultancy from the people who know
>
>
> "Michael Vardinghus" <michaelvardinghus@hotmail.com> wrote in message
> news:uQjBppnuEHA.3348@TK2MSFTNGP10.phx.gbl...
> > Normally this would be last night but what if you want it to be more
> > often....have someone tried this - and if so - how ?
> >
> > a) real time olap
> > b) be sure to filter records so only new records is being pullled out ..
> > and
> > scheduling this package more often than once a day .... how often ? per
> > hour
> > and perhaps even when the user says so in the host system ?
> >
> > /Michael Vardinghus
> >
> >
>
>

Relevant Pages

  • Re: implement BOTH peer-to-peer replication & merge replication
    ... you can use merge to do bi-directional replication with one or more ... What peer to peer will do which merge will not is allow all ... subscribers to act as publisher. ... i need to implement some load balancing by having two sql servers ...
    (microsoft.public.sqlserver.replication)
  • Re: Steps on configuring Peer to Peer Replication between two SQL 2005
    ... there are no domain requirements for replication. ... This communication is an original work and represents my sole ... Is it required to have both the SQL servers part of a domain or can ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication bandwidth
    ... look into WAN acceleration and wants me to tell him how much data our SQL ... I am not very familiar with SQL servers, ... Looking for a SQL Server replication book? ... I'm considering the transaction log file ...
    (microsoft.public.sqlserver.replication)
  • Re: About Replication
    ... Do you want to have 2 SQL Servers that need to ... be kept in sync, or do you need to do a transfer once? ... If it is once, use DTS, it is continuous, look at replication in BOL (Books ... Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: freeware for data guard
    ... does not want me to use dataguard and is asking me to find a freeware ... There are realtime replication solutions - like DRBD. ... If you can pause a database and do a 'sync' command to get everything written to disk, you can LVM snapshot the underlying LVM filesystem and duplicate *that* for backup. ...
    (linux.redhat)