{"version":"1.0","provider_name":"Sage CRM \u2013 Tips, Tricks and Components","provider_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm","title":"Create Same Company in another Database - Sage CRM \u2013 Tips, Tricks and Components","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"u5G9EkvVnu\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/03\/16\/create-same-company-in-another-database\/\">Create Same Company in another Database<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2009\/03\/16\/create-same-company-in-another-database\/embed\/#?secret=u5G9EkvVnu\" width=\"600\" height=\"338\" title=\"&#8220;Create Same Company in another Database&#8221; &#8212; Sage CRM \u2013 Tips, Tricks and Components\" data-secret=\"u5G9EkvVnu\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/* ]]> *\/\n<\/script>\n","description":"When you create a company in your CRM database and at the same time looking to create the same company in another CRM database, then you can do this by defining below trigger for your source database: CREATE TRIGGER trig_insert_CompanyON [CRMSOURCEDB].[dbo].[Company]FOR INSERTAS DECLARE @Company_Id AS INTEXEC @Company_Id = [CRMDESTDB].dbo.eware_get_identity_id &#8216;Company&#8217; INSERT [CRMDESTDB].dbo.Company (comp_companyid,comp_name,comp_type)SELECT @Company_Id,comp_name,comp_typeFROM inserted"}