<div>
Determined something wonky happened during the upgrade from 4.0 to 2011. Activity assignments were not correct after upgrade (contact associated with the activities were blank).
</div>


Determined something wonky happened during the upgrade from 4.0 to 2011. Activity assignments were not correct after upgrade (contact associated with the activities were blank).

<div>
<div class="content wysiwyg-content">
Recently upgraded from Dynamics 4.0 to 2011. With 4.0, I was able to directly query the database using the contact and account views:<br />
<br />
select * from Contact where ContactId = 'XXXX'<br />
<br />
However, this no longer works with 2011. It seems I have to specify the actual base and extension tables now, which is a royal pain. For accounts, my queries would need to pull in accountbase, accountextensionbase, and then the relevant address tables. I don't understand why I can't use the account view? <br />
<br />
Am I missing something?<br />
<br />
Thanks, <br />
<br />
Dave
</div>
</div>


Recently upgraded from Dynamics 4.0 to 2011. With 4.0, I was able to directly query the database using the contact and account views:

select * from Contact where ContactId = 'XXXX'

However, this no longer works with 2011. It seems I have to specify the actual base and extension tables now, which is a royal pain. For accounts, my queries would need to pull in accountbase, accountextensionbase, and then the relevant address tables. I don't understand why I can't use the account view? 

Am I missing something?

Thanks, 

Dave

Dynamics CRM 2011 Database Issue

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.

Microsoft Dynamics

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.