	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

6.7

Needing to replicate pieces of CRM database

Asked by mortimer452 in MS SQL Server, SQL Server 2005, Microsoft Applications

Tags: SQL Server, Replication, Microsoft CRM

I have a customer using Microsoft CRM to manage a large contacts database and scheduling safety training seminars.

A new project requires me to have up-to-date contact and scheduling information available via the company's website, which currently uses a separate database with a subset of the contacts and meeting schedules in CRM. The current database is updated manually and often gets out-of-sync with what's in CRM.

What I need are the Account and Opportunity entity data out of CRM (a handful of tables) replicated to another SQL server our website will use to integrate data into an online self-reservation application. Ideally, I could use SQL Server replication and publish the handful of tables I need into a remote SQL database, and integrate the data from there. However, I can't seem to find any documentation on whether or not SQL replication is supported or will break CRM.

This will be a one-way publish only, CRM is the "master" list of contacts and opportunities, the destination DB will be read-only. I'd prefer to use SQL replication, since I'm familiar with it and can easily set it up to publish changes real-time, but I'm afraid it will cause problems with CRM. SSIS may be an option as well, but the amount of data is enormous, and changed very frequently, it would be tough to setup something to identify which records have been changed/added since the last transfer to keep it efficient.

Is SQL replication possible with CRM? How does CRM normally work in a geographically separate environment, keeping data in sync with multiple locations?

Any help is appreciated!

View the Solution FREE for 30 Days

20100315-EE-VQP-143 - Hierarchy / EE_QW_3_20080625

Hall of Fame

1. aneeshatti...207,659
2. angelIII169,509
3. rrjegan17156,101
4. acperkins147,974
5. ralmada129,120
6. RiteshShah110,193
7. chapmandew88,961
8. myrotarycar76,059
9. Sharath_...72,285
10. reza_rad67,804
11. EugeneZ65,994
12. matthews...65,195
13. mark_wills59,014
14. Bodestone55,350
15. HainKurt48,088
16. mwvisa139,284
17. CGLuttrell39,208
18. pcelba36,607
19. tigin4435,869
20. MikeWalsh30,580
21. zadeveloper28,518
22. GDG_DBA24,964
23. tickett24,800
24. sameer2...21,656
25. Thomasian21,200

1. angelIII12,963,349
2. aneeshatti...6,258,352
3. acperkins5,168,088
4. ScottPletc...4,590,513
5. chapmandew3,470,089
6. arbert2,245,195
7. Lowfatsp...2,185,450
8. EugeneZ1,998,680
9. imran_fast1,485,025
10. rafrancisco1,460,132
11. BrandonG...1,357,912
12. rrjegan171,327,738
13. mark_wills1,308,691
14. nmcdermaid1,271,761
15. matthews...1,255,004
16. Hilaire1,221,775
17. Nightman1,158,168
18. bhess11,118,487
19. Mr_Peer...1,087,815
20. ptjcb1,074,620
21. dtodd1,034,228
22. appari922,901
23. RiteshShah844,646
24. adathelad836,908
25. Sirees776,352

Needing to replicate pieces of CRM database

Asked by mortimer452 in MS SQL Server, SQL Server 2005, Microsoft Applications

Tags: SQL Server, Replication, Microsoft CRM

About this solution