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.
| Author |
Topic |
|
Gordopolis
Starting Member
4 Posts |
 Posted - 2010-04-09 : 08:37:03
|
| Hi,Is it possible to configure SQL CDC so that change data is stored in a separate database from the source database?The benefit I am aiming for is so that the bloaty change data could then be stored on a sql server residing on cheaper disk space.Thanks,Gordopolis |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-09 : 09:07:24
|
What is SQL CDC?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Gordopolis
Starting Member
4 Posts |
Posted - 2010-04-09 : 09:13:12
|
| CDC = Change Data Capture, a new feature of SQL 2008. There is not much to it - see this short (15 minute) webcast for the lowdown on it:http://channel9.msdn.com/posts/ashishjaiman/CDC-Change-Data-Capture-SQL-Server-2008/ |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
Gordopolis
Starting Member
4 Posts |
Posted - 2010-04-09 : 10:27:32
|
| Excellent find WebFred!Cheers :) |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-09 : 10:35:31
|
thx 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
SQL CDC - store changes in another database?