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 |
|
irish_sophie
Starting Member
2 Posts |
 Posted - 2008-03-31 : 11:35:47
|
| Hi,I am very new to SQL Server. Plenty of SQL knowledge but the whoe SQL server enviornment is new. I am working with SQL Server 2005. My task is to generate reports without affecting our live database. I have setup a second server and installed SQL Server 2005 on that too. My thought was that maybe I could mirror or replicate the table I require over to this new server and run my queries from here. Is this easy to do ?I read that mirroring might not work as it is solely for back up /fall over purposes and that data on the mirrored server would not be accessible. I have also been looking at SSIS but at the moment this is all a bit like double dutch to me ! Can anyone point me in the right direction, preferably somewhere beginner friendly ie not overly complicated !!Thanks a mill,Sophie |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 11:40:22
|
| Use Transactional Replication. |
 |
|
|
irish_sophie
Starting Member
2 Posts |
Posted - 2008-04-01 : 05:46:24
|
| thanks sodeep.I was looking into using Transactional Replication alright but it seems quiet complex. Are there advantages to Transactional Replication over just taking a snapshot of the table required and manually adding triggers to the table of interest to update the table in the reporting database each time there is an insert?Thanks |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-01 : 11:15:13
|
| You don't have to apply triggers. Make sure your tables need to have PK. |
|
|
|
|
|
|
replicating data