Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm a semi SQL user, not a DBA, just a regular programmer. One of my upcoming jobs require a SQL replication configuration. I have never done such configuration before

My colleagues have been advicing me to hire an SQL Consultant or DBA to do this.

I was also thinking that maybe I can just do this myself. There's lots of information in google on how to do this.

Any advice? Is this something that a semi SQL user shouldn't be doing? How complex is it to setup SQL replication?

Thanks for the advice

share|improve this question

closed as not a real question by Sven, voretaq7 Oct 25 '12 at 18:22

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

Merge? Transactional? Snapshot? What are you looking to accomplish? – DanBig Feb 13 '12 at 18:09
...what's a "semi SQL user", BTW?!? – Massimo Feb 13 '12 at 18:10

I suggest taking a look at the Replication topics covered in BOL on MSDN Library.

The first thing you'll need to do is determine if you require one-way or two-way synchronization - and which type of replication will suit your needs. From here you'll want to setup a test environment to familiarize yourself with the details, this is crucial.

If you have any questions feel free to post them to the SQL Server Replication Forum.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.