Solved

CRM 4.0 and and outside SQL database

Posted on 2011-02-17
3
245 Views
Last Modified: 2012-05-11
Hi Experts,

If I needed to create a copy of the CRM account and lead tables, to make them accessible for a search through a separate SQL database that I would copy them into, does anyone have a recommendation on what is the most efficient way to accomplish this?  
Here's the request.  I'm supposed to create a solution where users can grab, on-demand, a  copy of the tables, and restore them into a separate SQL database.  
They will use this simplified database to search whether a client is already in the database, or if they are a new client, then we'll want to create a new LEAD in this database.  
(The idea behind this is to manage a homegrown loyalty program on a custom entity in the production CRM.)
Then, I'm supposed to take any data that has been added or changed to this outside database, and integrate it into the production CRM.  These changes would be: adding a new lead record, finding that someone exists in the database, recording that they attended an event on a certain day, ...etc.

This is starting to sound like the Offline Mode CRM where we sync it up when we are done.  We don't need a full-fledged offline version of CRM though, just the ability to search if someone exists already either a Lead or an Account.  

What are everyone's thoughts on the most efficient and supported way to do this?  
0
Comment
Question by:bucball2007
  • 2
3 Comments
 
LVL 17

Expert Comment

by:MIKE
ID: 34923691
Backup data on source system,...then Restore the database on the remote system on a nightly basis.

And or vice versa....

???
0
 

Accepted Solution

by:
bucball2007 earned 0 total points
ID: 34973274
Hi CRX,

Thanks for the feedback.  I've been trying out several different approaches. I only need about 10 columns on 5 or less entities copied into a separate sql database.  I think what I'm going to end up doing is a stored procedure to join and query exactly what I need, then insert it based on the project specs.  so far that seems to be working...

thanks!
0
 

Author Closing Comment

by:bucball2007
ID: 35005306
trying to keep the size down on the outside custom database, so I'm only pulling in exactly what I need, and I can query and join it to get it looking the way I want before I insert
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Query Optimization 14 42
Slow Connectivity over ODBC 8 32
SQL Replication question 9 41
TSQL query to generate xml 4 31
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

813 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now