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 2008 Forums
 Analysis Server and Reporting Services (2008)
 detect changes of table's structure

Author  Topic 

lilinikco
Starting Member

28 Posts

Posted - 2010-10-12 : 00:48:21
hi all.
how cube can detect changes of table's structure in data source?because we change in table's structure weekly.plz guide me immediatlly.

lili@@

andrewhopkinson
Yak Posting Veteran

63 Posts

Posted - 2010-10-21 : 15:20:45
look into Red-Gate SQL Compare. It is a very useful tool for synchronizing databases (although not cubes).
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-10-22 : 00:32:49
can use DDL Triggers too
Go to Top of Page
   

- Advertisement -