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 |
|
clement.store
Starting Member
25 Posts |
 Posted - 2010-07-03 : 00:27:29
|
| Hello there,A - SQL server 2005 standard sp2 ( production for system A - preferably left intact)B - SQL server 2005/2008 R2 standard. ( for replicate /Mirror / .... from A )I have sql servers as the above. Here's my situation: My difficuluty is that I dont want to intefere with A but i need to syn data from A to B in order tocreate some dynamic views in B based on A for some reporting. ANd I need to keep A intact as much as possible except configuring for sync. Would u have any clue as for which means would be best for my scenario ?Thanks a lot!Clement |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-07-03 : 00:47:02
|
| Please do not cross post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=146825 |
 |
|
|
|
|
|
mirror , replicate or else...?