July 2, 2010 at 10:25 pm
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 to
create 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
July 3, 2010 at 1:23 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic947146-291-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply