Because we all know that maintaining two on-premise environments (e.g. dev & production) can be a pain, sometimes checking certain entities before solution import can be a time saver! To check the data type differences between the attributes of the same entity, on two different organizations, you can use the following SQL statement: — USAGE:… Continue reading Attribute Type differences
Category: SQL Server 2005
Solution Component Types
Any importable CRM solution holds within the *.zip file a component named solution.xml. In order to edit this, you need a better understanding of the <RootComponent> nodes (type attribute). For a complete list of root component types, you can use the following SQL statement: SELECT AttributeValue as Type, Value as [Root Component] FROM StringMap WHERE… Continue reading Solution Component Types