I'am trying to copy a DNN tab_id (page) with all it's elements from 1 DNN on a server to another DNN on onother server.  which are differant portals numbers.

Could anyone provide a based SQL statement that could acomplish this.

I have this but it mixes the modules inside the tabs.

any ideas I have 100+ pages in sevral sub diectories with vast links across the site via friendly URLS. don't want to manually migrate this as it defeates the CMS idea.

Insert into tabs ( TabOrder,PortalID ,TabName,IsVisible,ParentId,Level,IconFile,DisableLink,Title,Description,KeyWords,IsDeleted,Url,SkinSrc,ContainerSrc,TabPath,StartDate,EndDate,RefreshInterval,PageHeadText,IsSecure,PermanentRedirect)values (743,2,'Alzheimers_Disease',1,245,1,'',1,'Alzheimers Disease','Health information page which provides information on a wide variety of topics regarding Alzheimer''s disease.','alzheimer''s, alzheimer''s disease, alzheimer''s information, alzheimer''s disease information',1,'','[L]Skins/AffordableDrugs/AffordableDrugsSkin.ascx','','//Health_Information//Alzheimers_Disease','','',0,'',1,1);

 

Insert into [tabpermission] ( TabID,PermissionID ,AllowAccess,RoleID,UserID)values (278,3,1,-1,null);

Insert into [tabpermission] ( TabID,PermissionID ,AllowAccess,RoleID,UserID)values (278,3,1,15,null);

Insert into [tabpermission] ( TabID,PermissionID ,AllowAccess,RoleID,UserID)values (278,4,1,15,null);

Insert into [tabpermission] ( TabID,PermissionID ,AllowAccess,RoleID,UserID)values (278,3,1,16,null);

Insert into [tabpermission] ( TabID,PermissionID ,AllowAccess,RoleID,UserID)values (278,3,1,17,null);

Insert into [tabpermission] ( TabID,PermissionID ,AllowAccess,RoleID,UserID)values (278,3,1,-3,null);

update tabpermission set createdbyuserid=1, createdondate='6/28/2010 6:24:31', lastmodifiedbyuserid=1, lastmodifiedondate='6/28/2010 6:24:31' where tabid=278

Insert into [Modules] ( ModuleDefID,ModuleTitle ,AllTabs,IsDeleted,InheritViewPermissions,Header,Footer,StartDate,EndDate,PortalID)values (120,'Text/HTML',1,1,1,'','','','',2);

Insert into [TabModules] ( TabID,ModuleID ,PaneName,ModuleOrder,CacheTime,Alignment,Color,Border,IconFile,Visibility,ContainerSrc,DisplayTitle,DisplayPrint,DisplaySyndicate)values (278,660,'ContentPane',1,0,'center','','','',1,'',1,1,1);

 

 

insert into htmltext (moduleid,content,version,stateid,ispublished,createdbyuserid,createdondate,lastmodifiedbyuserid,lastmodifiedondate)

values (

660,'<h1 align="center">Alzheimer''s Disease</h1>

<p align="left">Welcome to the Affordable Drugs Alzheimer''s disease information page.  Alzheimer''s disease is sometimes referred to as Alzheimer''s dementia.  The information about Alzheimer''s disease contained on this page is intended for Alzheimer''s patients and their families as well as Alzheimer''s caregivers.  Here you can learn about Alzheimer''s symptoms, Alzheimer''s stages, Alzheimer''s treatments and more.  You can also find the best prices available on Alzheimer''s medications.  The information on this page is not intended to replace the professional advice of your physician.  For the latest Alzheimer''s articles visit our <a href="http://www.affordabledrugs.com/newsarticles.aspx">health news</a> section.</p>

<p align="left"><a href="/health_information/alzheimers_disease/what_is_alzheimers_disease.aspx">What is Alzheimer''s Disease?</a><br />

<a href="/health_information/alzheimers_disease/alzheimers_symptoms.aspx">Alzheimer''s Symptoms</a><br />

<a href="/health_information/alzheimers_disease/Stages_of_alzheimers_disease.aspx">Stages of Alzheimer''s Disease</a><br />

<a href="/health_information/alzheimers_disease/causes_of_alzheimers_disease.aspx">Causes of Alzheimer''s Disease</a><br />

<a href="/health_information/alzheimers_disease/Alzheimers_diagnosis.aspx">Alzheimer''s Diagnosis</a><br />

<a href="/health_information/alzheimers_disease/Alzheimers_medications.aspx">Alzheimer''s Medications</a></p>

<p align="center"><a href="/health_information.aspx">Back To Health Information Main Page</a></p>',1,1,1,1,'6/28/2010 6:25:43',1,'6/28/2010 6:25:43'

)