-- use prj_carleyfoundry_import; MYSQL -- set nocount on; MSSQL select 'cf_AclResource', count(*) from cf_AclResource; select 'cf_AclResource2Role', count(*) from cf_AclResource2Role; select 'cf_AclResourcePrivilege', count(*) from cf_AclResourcePrivilege; select 'cf_AclRole', count(*) from cf_AclRole; select 'cf_AclRule', count(*) from cf_AclRule; select 'cf_Client', count(*) from cf_Client; select 'cf_Client2User', count(*) from cf_Client2User; select 'cf_Department', count(*) from cf_Department; select 'cf_DepartmentAndProcessSorter', count(*) from cf_DepartmentAndProcessSorter; select 'cf_DPermission', count(*) from cf_DPermission; select 'cf_DPrivilege', count(*) from cf_DPrivilege; select 'cf_DResource', count(*) from cf_DResource; select 'cf_DState', count(*) from cf_DState; select 'cf_DStatus', count(*) from cf_DStatus; select 'cf_Form', count(*) from cf_Form; select 'cf_FormElement', count(*) from cf_FormElement; select 'cf_FormElementProperty', count(*) from cf_FormElementProperty; select 'cf_FormElementPropertyValue', count(*) from cf_FormElementPropertyValue; select 'cf_FormSubmission', count(*) from cf_FormSubmission; select 'cf_FormSubmissionValue', count(*) from cf_FormSubmissionValue; select 'cf_Media', count(*) from cf_Media; select 'cf_Part', count(*) from cf_Part; select 'cf_Part2PartData', count(*) from cf_Part2PartData; select 'cf_Part2Process', count(*) from cf_Part2Process; select 'cf_Part2ProcessData', count(*) from cf_Part2ProcessData; select 'cf_Part2User', count(*) from cf_Part2User; select 'cf_PartVersion', count(*) from cf_PartVersion; select 'cf_Process', count(*) from cf_Process; select 'cf_Process2User', count(*) from cf_Process2User; select 'cf_User', count(*) from cf_User; select 'cf_User2Department', count(*) from cf_User2Department; select 'cf_User2Permission', count(*) from cf_User2Permission; select 'cf_zz_Admin', count(*) from cf_zz_Admin; select 'cf_zz_DFileType', count(*) from cf_zz_DFileType; select 'cf_zz_DLanguage', count(*) from cf_zz_DLanguage; select 'cf_zz_DNotFoundMode', count(*) from cf_zz_DNotFoundMode; select 'cf_zz_DPageHandler', count(*) from cf_zz_DPageHandler; select 'cf_zz_DPageItemGroup', count(*) from cf_zz_DPageItemGroup; select 'cf_zz_DPageItemType', count(*) from cf_zz_DPageItemType; select 'cf_zz_DPageOption', count(*) from cf_zz_DPageOption; select 'cf_zz_DraftHtmlBlock', count(*) from cf_zz_DraftHtmlBlock; select 'cf_zz_DraftHtmlBlockContent', count(*) from cf_zz_DraftHtmlBlockContent; select 'cf_zz_DraftPage', count(*) from cf_zz_DraftPage; select 'cf_zz_DraftPageContent', count(*) from cf_zz_DraftPageContent; select 'cf_zz_DraftPageItem', count(*) from cf_zz_DraftPageItem; select 'cf_zz_DraftPageItemConfig', count(*) from cf_zz_DraftPageItemConfig; select 'cf_zz_DraftPageOption', count(*) from cf_zz_DraftPageOption; select 'cf_zz_File', count(*) from cf_zz_File; select 'cf_zz_HtmlBlock', count(*) from cf_zz_HtmlBlock; select 'cf_zz_HtmlBlockContent', count(*) from cf_zz_HtmlBlockContent; select 'cf_zz_Log', count(*) from cf_zz_Log; select 'cf_zz_NotFound', count(*) from cf_zz_NotFound; select 'cf_zz_Page', count(*) from cf_zz_Page; select 'cf_zz_PageContent', count(*) from cf_zz_PageContent; select 'cf_zz_PageIndex', count(*) from cf_zz_PageIndex; select 'cf_zz_PageItem', count(*) from cf_zz_PageItem; select 'cf_zz_PageItemConfig', count(*) from cf_zz_PageItemConfig; select 'cf_zz_PageOption', count(*) from cf_zz_PageOption; select 'cf_zz_Redirection', count(*) from cf_zz_Redirection; select 'cf_zz_Settings', count(*) from cf_zz_Settings; select 'cf_zz_SettingsCategory', count(*) from cf_zz_SettingsCategory; select 'cf_zz_SettingsOptions', count(*) from cf_zz_SettingsOptions;