Dynamics crm

Posted on 2016-09-17
Last Modified: 2016-09-30
Is it possible to use 2 databases with the same structure at the same time.  Searching etc will search both and combine results.
Question by:Kevin Robinson
  • 3
  • 2
LVL 29

Expert Comment

by:Feridun Kadir
ID: 41803266
No, not using the CRM application. If you are using CRM on premises, you can write SQL queries to combine results from the filtered views in each database.

Author Comment

by:Kevin Robinson
ID: 41803310
yes I would be using dynamics crm 2016
LVL 29

Expert Comment

by:Feridun Kadir
ID: 41804483
OK, but is it CRM Online or On-Premises?

Author Comment

by:Kevin Robinson
ID: 41804489
sorry yes it will be on-premises
LVL 29

Accepted Solution

Feridun Kadir earned 500 total points
ID: 41804587
Thanks for confirming. Then that does mean you can get your SQL DBA to write queries that search both CRM databases; you could use the queries in SSRS reports.

However, you can't make the search box in the CRM application search more than database as per my original response.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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
Updating accounts - MS CRM 2013 4 106
Dynamics CRM Online: Add Button on Sub-Grid 8 400
CRM 2011 Cascade Quote to Order and Order to Invoice 4 78
T-SQL:  Manipulating Rows 50 178
Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
In a recent question ( here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

791 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