> Hi All
>
> Question for all
>
> Im currently working on creating a Datawarehouse but am curious to
> what the most effective way to accomplish this task with. Here is the
> situation:
>
> 2 Servers (Server A and Server B)
>
> Server A has X databases
> Server B has 1 database
> Each night, I need to copy each database from Server A and combine
> them into the database on Server B.
> Basically a drop/create each night of the database on Server B and an
> append the Server A databases into the database on Server B. What
> would be the easiest way to accomplish this?