October 9, 2014 at 8:20 am
I have an in-house database (that's actually part of a third-party product) running on 2008R2. We'd like to display some of the data on a new website we're working on (also running 2008R2). I'm more developer than administrator, so I'm wondering the best method for getting data from one to the other. Data doesn't have to be available real-time, daily replication is acceptable.
Again, this is display only, so two-way replication is not necessary.
I know of replication as a concept and have heard of Sync Framework, but have no experience with either and don't know where to start.
Last time I had to do something like this I probably would have created a linked server and an Agent to run once a day to run a stored procedure to copy the data. I'm sure the other methods are more efficient, so I'm looking for some pointers on getting started. Web searches return so much it makes my head spin, so if anyone knows of a tutorial or something, that would be helpful.
Edit: I should point out that I do not have access rights to install anything on either server. From my understanding, this would rule out Sync Framework. Is this correct?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply