Re: Tell Me About Your DW Development Life Cycle

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Alejandro Leguizamo \(MVP\) (aleguizamo2_at_hotmail.com)
Date: 05/13/04 

Date: Wed, 12 May 2004 19:55:12 -0500

well, i'd suggest let them connect to the AS Server Enterpise using Excel.
It's one of the most common approaches to it 

-- 
ALEJANDRO LEGUIZAMO
Colombia - SQL Server MVP
"Deb Wolfe" <thedebwolfe@hotmail.com> wrote in message
news:857f01c43246$855ed260$a601280a@phx.gbl...
> What are some good ways to get development cubes into
> production?
>
> I currently use a developer's edition of SQL Server 2000
> with Analysis Services. In the past couple of years I
> have been responsible for running reports. The plan now
> is to let users run reports for themselves by connecting
> to the Enterprise version at the client site via some
> simple client tool.
>
> The database is relatively small--just over 1 gig. There
> are about 250K members (students) and 2 million facts
> (test scores). I am responsible for doing ETL and
> building cubes.
>
> What sounds good?
> 1) Build everything locally and then just copy the .mdf
> and .cab files to the Enterprise server.
>
> 2) Connect to the production server via VPN and run the
> ETL statements against that database. Connect to the
> Analysis Services Server and rebuild cubes. (Currently I
> get an error message when trying to connect to the remote
> server via Analysis Services although I can see it in
> Enterprise Manager).
>
> 3) And the other logical possiblity--local database
> (which is then copied to production) but remote analysis
> services cube building.
>
>

Relevant Pages

  • Tell Me About Your DW Development Life Cycle
    ... What are some good ways to get development cubes into ... I currently use a developer's edition of SQL Server 2000 ... Connect to the production server via VPN and run the ... Analysis Services Server and rebuild cubes. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Upgrading SBS 2000 to Enterprise versions
    ... Also once we shift from the standards to the enterprise version, do we still use the transition cals, or do we need to buy different ones? ... Once you remove the SBS server and move the FSMO roles to the Enterprise server...this is no longer an SBS domain..there are "contraints" remaining ... Windows Server and Exchange on new hardware, one machine for Server one for ...
    (microsoft.public.windows.server.sbs)
  • Re: Running Virtual server on 2003 std vs Enterprise
    ... of virtual server on the Enterprise Host have to be 4 instances of ... with Virtual Server 2005. ... and would all 4 of my virtuals be ... of the Host OS version. ...
    (microsoft.public.windows.server.setup)
  • Re: Which Version of Windows 2003?
    ... The performance difference between standard and enterprise is really a ... I actually run the same server you do, ... 4GB of RAM and because of this limitation (and other reasons that need not be ...
    (microsoft.public.windows.terminal_services)
  • Re: Which Version of Windows 2003?
    ... The performance difference between standard and enterprise is really a ... I actually run the same server you do, ... 4GB of RAM and because of this limitation (and other reasons that need not be ...
    (microsoft.public.windows.terminal_services)