Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 (Solved) Passing live data to datawarehouse

Author  Topic 

srk03
Starting Member

2 Posts

Posted - 2009-06-12 : 11:38:04
Hi Guys,

I want to know if there is a way to pass live data from multiple SQL Server databases to one single database.

I don't need a copy. I need a continuous live copy of entire databases to flow into one database.

I trying to pass all the data from these systems to my datawarehouse database.

Any help is greatly appreciated.

Thanks

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-06-12 : 12:08:05
search for replication please.

Greetings
Webfred


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

srk03
Starting Member

2 Posts

Posted - 2009-06-12 : 13:11:05
Thanks, I don't know why I didn't think about Replication.

Go to Top of Page
   

- Advertisement -