08 April 2012

How to access Azure WCF Endpoint with CRM plugin

CRM plugin only support add service reference on run-time, which means we have to bind and generate the classes using code behind whenever we want to access it.

We can use the following sample code to create the binding in code behind.
BasicHttpBinding myBinding = new BasicHttpBinding();
myBinding.Name = "ARV.MyService";
myBinding.Security.Mode = BasicHttpSecurityMode.None;
myBinding.Security.Transport.ClientCredentialType = HttpClientCredentialType.None;
myBinding.Security.Transport.ProxyCredentialType = HttpProxyCredentialType.None;
myBinding.Security.Message.ClientCredentialType = BasicHttpMessageCredentialType.UserName;
EndpointAddress endPointAddress = new EndpointAddress("http://eea5f8cbdbc749b0bcea2b6250cbae11.cloudapp.net/Myservice.svc");
MyServiceClient client = new MyServiceClient(myBinding, endPointAddress);
client.sendSMS();

26 March 2012

Update Rollup 7 for CRM 2011

Official available on 22 March 2012 for download now.
KB : 2600643
Download HERE

This RU introduce a new feature called Read Optimized Forms. By using this feature, an organization can let users decide whether they want to view records using a form that is optimized to load quickly.
The read-optimized form improves productivity for users who primarily consume data instead of editing records. It also helps prevent users from unintentional editing field values

24 March 2012

CRM 2011 SDK 5.0.10

We can download the latest CRM 2011 sdk v5.0.10 already!
 Release on 22/Mar, cheers

There is a new topic with guidance about two types of read-only forms: the new read-optimized forms included in Microsoft Dynamics CRM 2011 Update Rollup 7 and the Microsoft Dynamics CRM for Microsoft Office Outlook reading pane.

29 February 2012

Migrating SQL Database to SQL Azure

Microsoft SQL provides serveral options for users to migrate their on-premises instance of SQL database to SQL Azure. In this post, I will use the simplest method (generate script) to prepare script for SQL Azure. Before we begin, it is good to know the limitation of SQL Azure compare to on-premises instance type of SQL, we can found the full list at MSDN here.

One of the key concern is you have to use SQL server 2008 R2 version, SQl 2008 does not support the target database to be SQL Azure.

Navigate to the database you wish to migrate. Mouse right click, select task , then generate scripts.

A wizard screen called "generate and publish script" will pop up. Select your object and define the script location. Key thing here is click the advance button.
Inside the advance option;
Set "script for the database engine type" to SQL Azure Database
Set "Convert UDDTs to Base types" to True.
Set "Types of data to script" to schema and data 
Finsih...
Now, execute the scripts in SQL Azure management portal, you should able to see your data in the cloud :)

18 February 2012

CRM 4 and CRM2011 rollup information [sharing post]

Here is the detail information regarding Dynamics CRM 4 and 2011, posted by Greg Nichols. Well done !
Rollup version listing