Solved

SQL Server 2005 - Replication Setup

Posted on 2011-03-20
2
253 Views
Last Modified: 2012-05-11
I have a SQL Server 2005 Standard Great Plains 9.0 database publication and subscription residing on a Windows 2003 Enterprise SP2 box that were deleted due to an issue we were having with our SalesPad connectivity to Great Plains.  We cannot resort to a backup on this, so I need to recreate this replication from scratch.  I have no experience with setting up replication, and I have browsed a few articles so far testing how this would work with no real strides in progress.  I am the new IT Network Admin for this company, and they previously are outsourcing this database work to a consultant.  I know if I call him it will be another $500 or so just to set it up.  I am coming here in hopes I can avoid having to go back to this consultant.

The subscriber in this replication process is our report server that all of our users hit to run reports on using Jeff-Net Report Runner.  The data from the Great Plains (Publisher) server needs to be replicated in such a way that the Report Server (Subscriber) gets immediate updates.  I need this process to avoid a ton of load on the Publisher and the Subscriber.  I understand that with the first snapshot, it can take awhile to replicate, but after this is done, it goes smooth (please correct me if I am wrong, but this was how it was explained to me).  

A share on the Great Plains (Publisher) server for snapshots already exists from the original setup and I would like to continue to use this setup.
I need help re-setting this up and understanding from my requirements above, what options needs to be checked.
The Report Server (Subscriber) already as a copy of the Great Plains (Publisher) database that I want to replicate that is current as of yesterday afternoon.
The articles I need replicate to are only all the tables, none of the stored procedures, views, or user defined fields.
I tried after creating the Publication to create a Subscriber and it never worked (obviously I am doing something wrong or don't understand the next step).
The consultant I mentioned talked about having indexes and scripts built that drop everything and then bring them over from the publisher (does this make sense and can they be recreated?)
The consultant also mentioned he had custom indexing done to make the reports run faster, so I am guessing I am still going to have to contact him for these?  Or, can one of you help me recreate them? (This is probably not possible since you would need to be intimate with our database, but I thought I would ask).

Please feel free to respond back with any more detail you need and I will get it to you right away.  Thanks in advance for any help you experts can provide.
0
Comment
Question by:Mathius123
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 

Author Comment

by:Mathius123
ID: 35175595
I forgot to mention that the Subscriber is a 2005 and 2008 SQL Server running Windows 2003 Enterprise SP2.
0
 

Accepted Solution

by:
Mathius123 earned 0 total points
ID: 35175901
I caved and worked with the consultant to get this fixed.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Pivot Query Problem 9 53
How to simplify my SQL statement? 14 61
Help with SQL - TOP 10 by date and by group 13 45
SQL parsing XML works but want to do it another way 4 48
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question