Quest Community

29 Dec 2010

by Trent Mera

Using LiteSpeed for SQL Server's Object Level Recovery feature, you can extract schema from an old backup and then compare it with your current schema using Toad for SQL Server. Here's how:

</p> <p></p><div style="clear:both;"></div></div> </div> </div> <div class="content-fragment-footer"></div> </div> <div class="content-fragment threaded-comments no-wrapper with-spacing responsive-1 " id="fragment-52451" data-reflow="_p_content,_p_singlecolumn,1,1,10"> <div class="content-fragment-content"> <div class="comment-form"> <div id="fragment-52451_statisticsWrapper" class="comment-statistics"></div> <div class="author" data-authorprofileurl="" > <div class="avatar"> <img src="/community/cfs-filesystemfile/__key/communityserver-components-imagefileviewer/system-images/anonymous.gif_2D00_44x44x2.png?_=636755852517552640" border="0px" alt="Anonymous" /> </div> </div> <fieldset> <ul class="field-list"> <li class="field-item post-body"> <span class="field-item-input"> <textarea id="fragment-52451_fragment-52451_createEditor" name="fragment-52451_fragment-52451_createEditor" style="width:100%;height:85px;" placeholder="Leave a comment..."></textarea><script type="text/javascript" src="https://www.quest.com/community/tinymce/tinymce.min.js"></script><script type="text/javascript" src="https://www.quest.com/community/tinymce/telligent/telligent.tinymce.min.js"></script><link rel="stylesheet" type="text/css" href="https://www.quest.com/community/tinymce/telligent/telligent.tinymce.ui.css"></link><script type="text/javascript" src="https://www.quest.com/community/tinymce/langs/en-US.js"></script><style> @font-face { font-family:'tinymce'; src:url('https://www.quest.com/community/tinymce/skins/telligent/fonts//tinymce.eot'); src:url('https://www.quest.com/community/tinymce/skins/telligent/fonts//tinymce.eot?#iefix') format('embedded-opentype'),url('https://www.quest.com/community/tinymce/skins/telligent/fonts//tinymce.woff') format('woff'),url('https://www.quest.com/community/tinymce/skins/telligent/fonts//tinymce.ttf') format('truetype'),url('https://www.quest.com/community/tinymce/skins/telligent/fonts//tinymce.svg#tinymce') format('svg'); font-weight:normal; font-style:normal } @font-face { font-family:'tinymce-small'; src:url('https://www.quest.com/community/tinymce/skins/telligent/fonts//tinymce-small.eot'); src:url('https://www.quest.com/community/tinymce/skins/telligent/fonts//tinymce-small.eot?#iefix') format('embedded-opentype'),url('https://www.quest.com/community/tinymce/skins/telligent/fonts//tinymce-small.woff') format('woff'),url('https://www.quest.com/community/tinymce/skins/telligent/fonts//tinymce-small.ttf') format('truetype'),url('https://www.quest.com/community/tinymce/skins/telligent/fonts//tinymce-small.svg#tinymce') format('svg'); font-weight:normal; font-style:normal } </style> <script language="javascript" type="text/javascript"> // <![CDATA[ if (!window.tinyMCE_TelligentEvolutionOptions) { tinyMCE_TelligentEvolutionOptions = new Object(); tinyMCE_TelligentEvolutionOptions._currentEditor = null; tinyMCE_TelligentEvolutionOptions._contentChangedHandle = null; tinyMCE_TelligentEvolutionOptions.UpdateBookmark = function(editor) { if (!editor) editor = tinyMCE.activeEditor; if (!editor) return; window.clearTimeout(editor._updateBookmarkHandle); editor._updateBookmarkHandle = window.setTimeout(function() { if (editor.selection) { editor._currentBookmark = editor.selection.getBookmark(2); } }, 99); }; tinyMCE_TelligentEvolutionOptions.MoveToBookmark = function(editor) { if (!editor) editor = tinyMCE.activeEditor; if (!editor) return; if (editor._currentBookmark) { try { editor.selection.moveToBookmark(editor._currentBookmark); } catch (e) { } } }; tinyMCE_TelligentEvolutionOptions.InitializeContentWindow = function() { tinyMCE_TelligentEvolutionOptions._currentEditor = tinyMCE.activeEditor; tinyMCE_TelligentEvolutionOptions.UpdateBookmark(); }; tinyMCE_TelligentEvolutionOptions.InsertContent = function(content, editor) { if (!editor) editor = tinyMCE.activeEditor; if (!editor) return; try { tinyMCE_TelligentEvolutionOptions.MoveToBookmark(editor); editor.execCommand('mceInsertContent', false, content) } catch(e) {} }; tinyMCE_TelligentEvolutionOptions.SetContent = function(content, editor) { if (!editor) editor = tinyMCE.activeEditor; if (!editor) return; try { editor.execCommand('mceSetContent', false, content) } catch (e) {} }; tinyMCE_TelligentEvolutionOptions.Setup = function(ed) { if (window.$) { try { $(document).bind('beforecustomizepage', function() { if (ed) { ed.remove(); } }); } catch (e) { } } ed.on('NodeChange', function() { tinyMCE_TelligentEvolutionOptions.UpdateBookmark(); window.clearTimeout(ed._contentChangedHandle); ed._contentChangedHandle = window.setTimeout(function() { if(tinyMCE.activeEditor === ed) { tinyMCE_TelligentEvolutionOptions.ContentChanged(ed); } }, 999); }); ed.on('change SetContent', function() { tinyMCE_TelligentEvolutionOptions.UpdateBookmark(); window.clearTimeout(ed._contentChangedHandle); ed._contentChangedHandle = window.setTimeout(function() { try { tinyMCE_TelligentEvolutionOptions.ContentChanged(ed); } catch(e) { } }, 999); }); ed.on('keydown', function (e) { if (ed._tinyMCE_TelligentEvolutionOptions_onKeyDownHandlers) { for (var i = 0; i < ed._tinyMCE_TelligentEvolutionOptions_onKeyDownHandlers.length; i++) { var response = ed._tinyMCE_TelligentEvolutionOptions_onKeyDownHandlers[i](e); if (response === false) { return false; } } } }, true); ed.on('LoadContent', function() { ed._oldContentValue = ed.getContent(); if (ed._oldContentValue == '<p> </p>') { ed._oldContentValue = ''; } try { ed.getWin().document.addEventListener('keydown', function() { ed.getWin().focus(); }); } catch (e) {} }); } tinyMCE_TelligentEvolutionOptions.ContentChanged = function(ed) { ed.save(); var oldContent = ed._oldContentValue; ed._oldContentValue = ed.getContent(); if (ed._oldContentValue == '<p> </p>') ed._oldContentValue = ''; if (oldContent == ed._oldContentValue) return; if (ed._tinyMCE_TelligentEvolutionOptions_onChangeHandlers) { for (var i = 0; i < ed._tinyMCE_TelligentEvolutionOptions_onChangeHandlers.length; i++) { ed._tinyMCE_TelligentEvolutionOptions_onChangeHandlers[i](); } } } tinyMCE_TelligentEvolutionOptions.GetBaseUrl = function() { try { if (window.parent && window.parent.Telligent_Modal) return window.parent.location + ""; } catch (e) {} return window.location + ""; }; tinyMCE_TelligentEvolutionOptions.AttachOnChangeHandler = function(id, f) { var ed = tinyMCE.get(id); if (ed) { if (!ed._tinyMCE_TelligentEvolutionOptions_onChangeHandlers) ed._tinyMCE_TelligentEvolutionOptions_onChangeHandlers = new Array(); ed._tinyMCE_TelligentEvolutionOptions_onChangeHandlers[ed._tinyMCE_TelligentEvolutionOptions_onChangeHandlers.length] = f; return; } window.setTimeout(function() { tinyMCE_TelligentEvolutionOptions.AttachOnChangeHandler(id, f) }, 499); } tinyMCE_TelligentEvolutionOptions.AttachOnKeyDownHandler = function(id, f) { var ed = tinyMCE.get(id); if (ed) { if (!ed._tinyMCE_TelligentEvolutionOptions_onKeyDownHandlers) ed._tinyMCE_TelligentEvolutionOptions_onKeyDownHandlers = new Array(); ed._tinyMCE_TelligentEvolutionOptions_onKeyDownHandlers[ed._tinyMCE_TelligentEvolutionOptions_onKeyDownHandlers.length] = f; return; } window.setTimeout(function() { tinyMCE_TelligentEvolutionOptions.AttachOnKeyDownHandler(id, f) }, 499); } tinyMCE_TelligentEvolutionOptions.ContextQueryString = '_pcurl=~%2Fquest%2Fb%2Fen%2Fposts%2Fhow-to-compare-a-database-schema-over-time'; tinyMCE_TelligentEvolutionOptions.DirectUploadContext = '9a3abe4d-7741-44ba-89c4-63309a06f9f0'; tinyMCE_TelligentEvolutionOptions.DirectUploadUrl = 'https:\/\/www.quest.com\/community\/multipleupload?UploadContext=9a3abe4d-7741-44ba-89c4-63309a06f9f0'; tinyMCE_TelligentEvolutionOptions.MediaMaxWidth = 550; tinyMCE_TelligentEvolutionOptions.MediaMaxHeight = 0; } // ]]> </script> <script language="javascript" type="text/javascript"> // <![CDATA[ tinymce.EditorManager.baseURL = "https://www.quest.com/community/tinymce"; (function() { var editor = tinymce.EditorManager.get('fragment-52451_fragment-52451_createEditor'); if (editor) { editor.remove(); } })(); tinymce.EditorManager.init({ selector:"#fragment-52451_fragment-52451_createEditor", relative_urls:false, setup:new Function('ed', 'tinyMCE_TelligentEvolutionOptions.Setup(ed);'), tinyautosave_key:'184758366-', evolution_contenttypeid:'9262536b-49a3-4494-802f-04dff10424ed', theme: 'modern', skin: 'telligent', resize: 'true', object_resizing: 'table,img,.mceInsertMediaItem', language: 'en-US', plugins: 'charmap,source,contextmenu,noneditable,fullscreen,hr,paste,searchreplace,visualblocks,visualchars,enhancements,modalpopups,tips,emoticons,embeddables,quotes,anchor,autolink,link,autoresize,lists,hashtags,mentions,media,preview,tinyautosave,submit,bottomtoolbar',submit_enabletoggle: true,menu: { edit : {title : 'Edit' , items : 'removehashtag removemention editmedia editimage removemedia editembeddable edittoken removetoken editlink previewmedia removelink undo redo | pastetext searchreplace | selectall'}, insert : {title : 'Insert', items : 'link media token embeddc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2 emoticon | anchor hr | charmap'}, format : {title : 'Format', items : 'bold italic underline | indent outdent |formats | removeformat'}, tools : {title : 'Tools' , items : 'tinyautosave preview source'} },statusbar: false, fontsize_formats: 'Small=75% Normal=inherit Large=150% Larger=200%', font_formats: 'Arial=arial,helvetica,sans-serif;Comic Sans=comic sans ms,comic sans,sans-serif;Courier New=courier new,courier;Default Font=inherit;Georgia=georgia,palatino;Helvetica=helvetica;Impact=impact,chicago;Tahoma=tahoma,arial,helvetica,sans-serif;Times New Roman=times new roman,times;Verdana=verdana,geneva', evolution_emoticons: true, evolution_upload:false, evolution_localfiles:true, enhancements_placeholder: 'Leave a comment...',autoresize_bottom_margin: 1,autoresize_overflow_padding: 0,autoresize_min_height: 60,height: 85,min_height: 60,enhancements_wrappercss:'mce-editor-submittable mce-editor-desktop',toolbar: 'bullist numlist submit',contextmenu: 'cell row column deletetable',evolution_embeddables: [{"name":"Code","typeid":"dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2","previewUrl":"/community/cfs-file/__key/system/images/embedcode.png","configurable":true}],browser_spellcheck : true,autolink_pattern: /((?:http|ftp|https):\/\/)([\w\-]{1,63}(?:\.[\w\-]{1,63}){0,127}(?:$[\w\-\.,@?!^=%&:/~\+#]{0,2046}$|[\w\-\.,@?!^=%&:/~\+#]{0,2047}[\w\-@?^=%&:/~\+#]){0,2048})/i,paste_data_images: true,submit_entermessage:'Enter to Comment',submit_buttontext:'Comment',submit_onsubmit:function() { jQuery.telligent.evolution.messaging.publish('widgets.comments.submit', { from: 'fragment-52451', login: false }); },submit_entertosubmit: true, document_base_url: tinyMCE_TelligentEvolutionOptions.GetBaseUrl(), images_dataimg_filter: function() { return false; }, anchor_bottom: false, anchor_top: false, content_css: 'https:\/\/www.quest.com\/community\/tinymce\/telligent\/telligent.tinymce.content.css',style_formats:[{ title: 'Inline', items: [ { title: 'Bold', icon: 'bold', format: 'bold'}, { title: 'Italic', icon: 'italic', format: 'italic'}, { title: 'Underline', icon: 'underline', format: 'underline'}, { title: 'Strikethrough', icon: 'strikethrough', format: 'strikethrough'}, { title: 'Superscript', icon: 'superscript', format: 'superscript'}, { title: 'Subscript', icon: 'subscript', format: 'subscript'},]}, { title: 'Blocks', items: [ { title: 'Paragraph', format: 'p'}, { title: 'Blockquote', format: 'blockquote'}, { title: 'Div', format: 'div'}, { title: 'Pre', format: 'pre'} ]}, { title: 'Alignment', items: [ { title: 'Left', icon: 'alignleft', format: 'alignleft'}, { title: 'Center', icon: 'aligncenter', format: 'aligncenter'}, { title: 'Right', icon: 'alignright', format: 'alignright'}, { title: 'Justify', icon: 'alignjustify', format: 'alignjustify'} ]}],valid_elements:'@[class|style|align|id|dir|lang|title],a[charset|href|hreflang|name|rel|rev|target|type],b,bdo,blockquote[cite],br[clear],dd,div,dl,dt,em,i,img[alt|border|height|hspace|longdesc|name|src|vspace|width],li,meta[charset|content|name|scheme],meter[max|min|value|high|low|optimum],ol[start|reversed],p,pre,progress[value|max],s,span,strike,strong,sub,sup,tt,u,ul',valid_styles: {'*':'clear,float,font-style,font-weight,text-align,text-decoration,text-indent,vertical-align'},protect:[/\<\!\-\-.*?\-\-\>/g,/\<\!\[CDATA\[.*?\]\]\>/g], directionality: 'ltr' }); // ]]> </script> </span> <span class="field-item-validation" style="display: none;"></span> </li> </ul> </fieldset> </div> <div class="best-replies-wrapper" id="fragment-52451_bestRepliesWrapper"> </div> <div id="fragment-52451_editorWrapperWrapper" style="display:none"> <textarea id="fragment-52451_fragment-52451_replyEditor" name="fragment-52451_fragment-52451_replyEditor" style="width:100%;height:85px;"></textarea> <script language="javascript" type="text/javascript"> // <![CDATA[ tinymce.EditorManager.baseURL = "https://www.quest.com/community/tinymce"; (function() { var editor = tinymce.EditorManager.get('fragment-52451_fragment-52451_replyEditor'); if (editor) { editor.remove(); } })(); tinymce.EditorManager.init({ selector:"#fragment-52451_fragment-52451_replyEditor", relative_urls:false, setup:new Function('ed', 'tinyMCE_TelligentEvolutionOptions.Setup(ed);'), tinyautosave_key:'1742678744-', evolution_contenttypeid:'9262536b-49a3-4494-802f-04dff10424ed', theme: 'modern', skin: 'telligent', resize: 'true', object_resizing: 'table,img,.mceInsertMediaItem', language: 'en-US', plugins: 'charmap,source,contextmenu,noneditable,fullscreen,hr,paste,searchreplace,visualblocks,visualchars,enhancements,modalpopups,tips,emoticons,embeddables,quotes,anchor,autolink,link,autoresize,lists,hashtags,mentions,media,preview,tinyautosave,submit,bottomtoolbar',submit_enabletoggle: true,menu: { edit : {title : 'Edit' , items : 'removehashtag removemention editmedia editimage removemedia editembeddable edittoken removetoken editlink previewmedia removelink undo redo | pastetext searchreplace | selectall'}, insert : {title : 'Insert', items : 'link media token embeddc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2 emoticon | anchor hr | charmap'}, format : {title : 'Format', items : 'bold italic underline | indent outdent |formats | removeformat'}, tools : {title : 'Tools' , items : 'tinyautosave preview source'} },statusbar: false, fontsize_formats: 'Small=75% Normal=inherit Large=150% Larger=200%', font_formats: 'Arial=arial,helvetica,sans-serif;Comic Sans=comic sans ms,comic sans,sans-serif;Courier New=courier new,courier;Default Font=inherit;Georgia=georgia,palatino;Helvetica=helvetica;Impact=impact,chicago;Tahoma=tahoma,arial,helvetica,sans-serif;Times New Roman=times new roman,times;Verdana=verdana,geneva', evolution_emoticons: true, evolution_upload:false, evolution_localfiles:true, autoresize_bottom_margin: 1,autoresize_overflow_padding: 0,autoresize_min_height: 60,height: 85,min_height: 60,enhancements_wrappercss:'mce-editor-submittable mce-editor-desktop',toolbar: 'bullist numlist submit',contextmenu: 'cell row column deletetable',evolution_embeddables: [{"name":"Code","typeid":"dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2","previewUrl":"/community/cfs-file/__key/system/images/embedcode.png","configurable":true}],browser_spellcheck : true,autolink_pattern: /((?:http|ftp|https):\/\/)([\w\-]{1,63}(?:\.[\w\-]{1,63}){0,127}(?:$[\w\-\.,@?!^=%&:/~\+#]{0,2046}$|[\w\-\.,@?!^=%&:/~\+#]{0,2047}[\w\-@?^=%&:/~\+#]){0,2048})/i,paste_data_images: true,submit_entermessage:'Enter to Reply',submit_buttontext:'Reply',submit_onsubmit:function() { jQuery.telligent.evolution.messaging.publish('widgets.threadedComments.submit') },submit_entertosubmit: true, document_base_url: tinyMCE_TelligentEvolutionOptions.GetBaseUrl(), images_dataimg_filter: function() { return false; }, anchor_bottom: false, anchor_top: false, content_css: 'https:\/\/www.quest.com\/community\/tinymce\/telligent\/telligent.tinymce.content.css',style_formats:[{ title: 'Inline', items: [ { title: 'Bold', icon: 'bold', format: 'bold'}, { title: 'Italic', icon: 'italic', format: 'italic'}, { title: 'Underline', icon: 'underline', format: 'underline'}, { title: 'Strikethrough', icon: 'strikethrough', format: 'strikethrough'}, { title: 'Superscript', icon: 'superscript', format: 'superscript'}, { title: 'Subscript', icon: 'subscript', format: 'subscript'},]}, { title: 'Blocks', items: [ { title: 'Paragraph', format: 'p'}, { title: 'Blockquote', format: 'blockquote'}, { title: 'Div', format: 'div'}, { title: 'Pre', format: 'pre'} ]}, { title: 'Alignment', items: [ { title: 'Left', icon: 'alignleft', format: 'alignleft'}, { title: 'Center', icon: 'aligncenter', format: 'aligncenter'}, { title: 'Right', icon: 'alignright', format: 'alignright'}, { title: 'Justify', icon: 'alignjustify', format: 'alignjustify'} ]}],valid_elements:'@[class|style|align|id|dir|lang|title],a[charset|href|hreflang|name|rel|rev|target|type],b,bdo,blockquote[cite],br[clear],dd,div,dl,dt,em,i,img[alt|border|height|hspace|longdesc|name|src|vspace|width],li,meta[charset|content|name|scheme],meter[max|min|value|high|low|optimum],ol[start|reversed],p,pre,progress[value|max],s,span,strike,strong,sub,sup,tt,u,ul',valid_styles: {'*':'clear,float,font-style,font-weight,text-align,text-decoration,text-indent,vertical-align'},protect:[/\<\!\-\-.*?\-\-\>/g,/\<\!\[CDATA\[.*?\]\]\>/g], directionality: 'ltr' }); // ]]> </script> </div> </div> <div class="content-fragment-footer"></div> </div> </div> </div> </div> <div class="layout-footer"></div> </div><input type="hidden" name="_p_state" id="_p_state" value="" /></div> <div class="single-column footer-fragments evolution-reflow-container" data-related="_f_page" id="_f_singlecolumn" style = "display:none"></div><div class="footer-fragments evolution-reflow-container" data-related="_f_singlecolumn" id="_f_page" data-reflow-width="670"><div class="layout"> <div class="layout-header"></div> <div class="layout-content content" id="_f_layout"><div class="layout-region content" id="_f_content"> <div class="layout-region-inner content"><div class="content-fragment scripted-content-fragment no-wrapper responsive-1 " id="footer-830" data-reflow="_f_content,_f_singlecolumn,1,1,0"> <div class="content-fragment-content"> <div id='questFooter'></div></div> <div class="content-fragment-footer"></div> </div> <div id="footer-831"></div> <div id="footer-832"></div> <div id="footer-833"></div> <div id="footer-834"></div> <div id="footer-835"></div> </div> </div> </div> <div class="layout-footer"></div> </div><input type="hidden" name="_f_state" id="_f_state" value="" /></div><script type="text/html" id="site-banner-notification-preferences-template"> <div class="notification-preference"> <span class="description">Do not notify me when someone <strong><%: notificationTypeName %></strong>?</span> <a href="#" class="confirm internal-link button submit-button" data-notificationtypeid="<%: notificationTypeId %>">Confirm</a> <a href="#" class="cancel internal-link button submit-button">Cancel</a> </div> </script> <script type="text/html" id="site-banner-list-template"> <div> <div class="multiple-column-list columns-1"> <div class="multiple-column-item column-1"> <ul class="content-list content"> </ul> <div class="loading">Loading...</div> <% if(footerContent) { %> <div class="content-list-footer"> <%= footerContent %> </div> <% } %> </div> </div> </div> </script> <script type="text/html" id="site-banner-bookmark-filter-template"> <ul class="navigation-list filter"> <% if(contentTypeIds && contentTypeIds.length > 0) { %> <li class="navigation-item conversations"> <a class="internal-link" href="#" data-contenttypeids="<%: contentTypeIds %>">Content</a> </li> <% } %> <% if(applicationContentTypeIds && applicationContentTypeIds.length > 0) { %> <li class="navigation-item conversations"> <a class="internal-link" href="#" data-contenttypeids="<%: applicationContentTypeIds %>">Application</a> </li> <% } %> <% if(containerTypes && containerTypes.length > 0) { %> <% foreach(containerTypes, function(containerType) { %> <li class="navigation-item conversations"> <a class="internal-link" href="#" data-contenttypeids="<%: containerType.id %>"><%: containerType.name %></a> </li> <% }); %> <% } %> </ul> </script> <script type="text/html" id="site-banner-notification-filter-template"> <ul class="navigation-list filter"> <li class="navigation-item all"> <a class="internal-link" href="#" data-filter="all">All</a> </li> <li class="navigation-item unread"> <a class="internal-link" href="#" data-filter="unread">Unread</a> </li> </ul> </script> <script type="text/html" id="site-banner-search-filter-template"> <% if(places && places.length > 0) { %> <ul class="navigation-list filter"> <% foreach(places, function(place) { %> <li class="navigation-item"> <a class="place internal-link" href="#" data-key="<%: place.key %>" data-value="<%: place.value %>" data-searchparam="<%: place.searchParameter %>" data-searchvalue="<%: place.searchValue %>"><%= place.name %></a> <% }); %> </ul> <% } %> <% if(filters && filters.length > 0) { %> <ul class="navigation-list filter"> <% foreach(filters, function(filter) { %> <li class="navigation-item"> <a class="type internal-link" href="#" data-key="<%: filter.key %>"><%= filter.name %></a> </li> <% }); %> </ul> <% } %> </script> <script type="text/javascript" src="/community/cfs-filesystemfile/__key/widgetfiles/3ebe0c66af914f76b0918052d3f84e03-5e8e1650092c434295fc1226a66a944e/siteBanner.js?_=636851741585463608"></script> <script type="text/javascript" src="/community/cfs-filesystemfile/__key/widgetfiles/3ebe0c66af914f76b0918052d3f84e03-5e8e1650092c434295fc1226a66a944e/siteBannerUI.js?_=636851741585463608"></script> <script type="text/javascript"> var headerSearchGroupId = "77"; jQuery(function(){ jQuery.telligent.evolution.widgets.siteBanner.register({ wrapper: '#header-842', messagePrefix: 'widget.header-842.', banner: jQuery('#site-banner'), siteFooter: 'root', handheldSearchFieldsLink: jQuery('#header-842_handheldSearchFieldsLink'), handheldSearchFields: jQuery('#header-842_searchFields'), handheldBannerLinksLink: jQuery('#header-842_handheldBannerLinksLink'), handheldBannerLinks: jQuery('#header-842_handheldBannerLinks'), searchFields: jQuery('#header-842_searchFields'), utilityDropdown: jQuery('#header-842_utilityDropdown'), bannerLinks: jQuery('#header-842_bannerLinks'), handheldBannerLinksCount: jQuery('#header-842_handheldBannerLinksCount'), bannerSiteLinks: jQuery('#header-842_bannerSiteLinks'), handheldSiteLinksLink: jQuery('#header-842_handheldSiteLinksLink'), handheldSiteLinks: jQuery('#header-842_handheldSiteLinks'), notificationsTemplate: 'site-banner-list-template', notificationsUrl: '/community/utility/scripted-file.ashx?_cf=notifications.vm\u0026_fid=842\u0026_wid=header-842\u0026_ct=header\u0026_cp=\u0026_ctt=a3b17ab0af5f11dda3501fcf55d89593\u0026_ctc=047b9db028f04b2b952c2113c772ab76\u0026_ctn=5e8e1650092c434295fc1226a66a944e\u0026_cc=0\u0026_ipd=10\u0026_pcurl=~%2Fquest%2Fb%2Fen%2Fposts%2Fhow-to-compare-a-database-schema-over-time', notificationsLink: jQuery('#header-842_notifications'), notificationsUnread: 0, notificationListFooterContent: '\u003ca href=\"/community/user/notifications\" class=\"view-all left\"\u003eView All\u003c/a\u003e\u003ca class=\"right\" href=\"${notificationSettingsUrl}\"\u003eSettings\u003c/a\u003e', notificationPreferenceTemplate: 'site-banner-notification-preferences-template', notificationssUnreadCountMessageSingular: 'You have {0} unread notification', notificationssUnreadCountMessagePlural: 'You have {0} unread notifications', notificationsFilterTemplate: 'site-banner-notification-filter-template', conversationsTemplate: 'site-banner-list-template', conversationsUrl: '/community/utility/scripted-file.ashx?_cf=conversations.vm\u0026_fid=842\u0026_wid=header-842\u0026_ct=header\u0026_cp=\u0026_ctt=a3b17ab0af5f11dda3501fcf55d89593\u0026_ctc=047b9db028f04b2b952c2113c772ab76\u0026_ctn=5e8e1650092c434295fc1226a66a944e\u0026_cc=0\u0026_ipd=10\u0026_pcurl=~%2Fquest%2Fb%2Fen%2Fposts%2Fhow-to-compare-a-database-schema-over-time', conversationsLink: jQuery('#header-842_conversations'), conversationsUnread: 0, conversationNotificationTypeId: '84e4c0a7-3a17-4dfe-b8a0-d7038aa04a84', conversationListFooterContent: '\u003ca href=\"${core_v2_urls.Conversations()}\" class=\"left\"\u003eView All\u003c/a\u003e\u003ca href=\"#\" data-messagename=\"widget.header-842.startconversation\" class=\"right\"\u003eNew Message\u003c/a\u003e', conversationsUnreadCountMessageSingular: 'You have {0} unread message', conversationsUnreadCountMessagePlural: 'You have {0} unread messages', conversationNewConversationModalUrl: '$core_v2_encoding.JavascriptEncode($core_v2_urls.AddConversation())', bookmarksTemplate: 'site-banner-list-template', bookmarksUrl: '/community/utility/scripted-file.ashx?_cf=bookmarks.vm\u0026_fid=842\u0026_wid=header-842\u0026_ct=header\u0026_cp=\u0026_ctt=a3b17ab0af5f11dda3501fcf55d89593\u0026_ctc=047b9db028f04b2b952c2113c772ab76\u0026_ctn=5e8e1650092c434295fc1226a66a944e\u0026_cc=0\u0026_ipd=10\u0026_pcurl=~%2Fquest%2Fb%2Fen%2Fposts%2Fhow-to-compare-a-database-schema-over-time', bookmarksLink: jQuery('#header-842_bookmarks'), bookmarksListFooterContent: '\u003ca class=\"left\" href=\"${bookmarksUrl}\"\u003eView All\u003c/a\u003e', bookmarksContentTypes: '$core_v2_encoding.JavascriptEncode($contentTypes)', bookmarksApplicationContentTypes: '$core_v2_encoding.JavascriptEncode($applicationContentTypes)', bookmarksContainerContentTypes: '$core_v2_encoding.JavascriptEncode($containerContentTypes)', bookmarksFilterTemplate: 'site-banner-bookmark-filter-template', bookmarksIsBookmarked: false , bookmarksCurrentContentId: '', bookmarksBookmarks: 'Bookmarks', bookmarkAdded: 'Bookmark Added', bookmarkRemoved: 'Bookmark Removed', userPopupTemplate: 'site-banner-list-template', // userContentTemplate: 'site-banner-user-template', userLink: jQuery('#header-842_user'), searchType: 'Default', searchTemplate: 'site-banner-list-template', searchUrl: '/community/utility/scripted-file.ashx?_cf=search.vm\u0026_fid=842\u0026_wid=header-842\u0026_ct=header\u0026_cp=\u0026_ctt=a3b17ab0af5f11dda3501fcf55d89593\u0026_ctc=047b9db028f04b2b952c2113c772ab76\u0026_ctn=5e8e1650092c434295fc1226a66a944e\u0026_cc=0\u0026_ipd=10\u0026_pcurl=~%2Fquest%2Fb%2Fen%2Fposts%2Fhow-to-compare-a-database-schema-over-time', searchInput: jQuery('#header-842_Search'), searchFooterContent: '\u003ca data-messagename=\"widget.header-842.advancedsearch\" id=\"header-842_advancedsearch\" href=\"#\"\u003eAdvanced Search\u003c/a\u003e', searchFilterTemplate: 'site-banner-search-filter-template', searchAdvancedUrl: '/community/search?{0}', searchAdvancedUserUrl: '/community/members?{0}', searchFilterContentName: 'Content', searchFilterGroupsName: 'Groups', searchFilterPeopleName: 'People', searchPlaceApplicationId: '047b9db0-28f0-4b2b-952c-2113c772ab76' , searchPlaceApplicationName: 'In Blog' , searchPlaceGroupId: 'c464b15c-6573-4bfe-96f7-51cd56af5993' , searchPlaceGroupLocalId: '77' , searchPlaceGroupName: 'In Quest' , searchPlaceAnywhereName: 'Anywhere', advancedSearchId: 'header-842_advancedsearch', searchShowPeople: true, siteNavigationType: 'exclude' }); }); </script> <script>jQuery.telligent.evolution.template.register('fragment-52451_loadMoreTemplate',function(h,d){var s=[];with(d){with(h){s.push(' <li class=\"load-more '); if(previous) { s.push(' previous '); } else { s.push(' next '); } s.push('\" '); if (loadInline) { s.push(' data-inline=\"inline\" '); } s.push('>\r\n '); if(previous) { s.push('\r\n <a class=\"previous\" href=\"#\" '); if (loadInline) { s.push(' data-inline=\"inline\" '); } s.push('>Load Previous <\/a>\r\n '); } else { s.push('\r\n <a class=\"next\" href=\"#\" '); if (loadInline) { s.push(' data-inline=\"inline\" '); } s.push('>Load Next <\/a>\r\n '); } s.push('\r\n <span class=\"ui-loading\" data-width=\"24\" data-height=\"24\"><\/span>\r\n<\/li>\r\n\r\n');}}return s.join('');});</script> <script>jQuery.telligent.evolution.template.register('fragment-52451_newRepliesTemplate',function(h,d){var s=[];with(d){with(h){s.push(' <div class=\"threaded new-replies '); if(offscreen) { s.push(' offscreen '); } s.push('\" '); if(offscreen) { s.push(' style=\"width: ');s.push(String( width ));s.push('px\" '); } s.push('>\r\n <a href=\"#\" data-messagename=\"ui.replies.new\" data-replyid=\"');s.push(String( replyId ));s.push('\">\r\n '); if(newReplies == 1) { s.push('\r\n ');s.push(String( newReplies ));s.push(' new reply\r\n '); } else { s.push('\r\n ');s.push(String( newReplies ));s.push(' new replies\r\n '); } s.push('\r\n <\/a>\r\n<\/div>\r\n\r\n');}}return s.join('');});</script> <script>jQuery.telligent.evolution.template.register('fragment-52451_replyTemplate',function(h,d){var s=[];with(d){with(h){s.push(' <li class=\"threaded content-item '); if(isDeleted) { s.push(' deleted '); } s.push('\"\r\n data-id=\"');s.push(escape(String( id )));s.push('\"\r\n data-parentid=\"');s.push(escape(String( parentId )));s.push('\"\r\n data-createddate=\"');s.push(escape(String( createdDate )));s.push('\"\r\n data-yesvotes=\"');s.push(escape(String( yesVotes )));s.push('\"\r\n data-novotes=\"');s.push(escape(String( noVotes )));s.push('\">\r\n\r\n <div class=\"rendered-content\">\r\n ');s.push(String( body ));s.push('\r\n <div class=\"typing-status-wrapper\"><\/div>\r\n <div class=\"new-replies-wrapper\"><\/div>\r\n <\/div>\r\n\r\n <div class=\"newreply\"><\/div>\r\n\r\n <ul class=\"content-list threaded\"\r\n data-sortby=\"');s.push(String( sortBy ));s.push('\" \r\n data-sortorder=\"');s.push(String( sortOrder ));s.push('\"><\/ul>\r\n\r\n<\/li>\r\n\r\n');}}return s.join('');});</script> <script>jQuery.telligent.evolution.template.register('fragment-52451_replyFormTemplate',function(h,d){var s=[];with(d){with(h){s.push(' <div class=\"reply-form '); if (editingReplyId) { s.push(' edit '); } else { s.push(' create '); } s.push('\" '); if (editingReplyId) { s.push(' data-editing=\"');s.push(String( editingReplyId ));s.push('\" '); } s.push('>\r\n '); if(!editingReplyId) { s.push('\r\n \r\n <div class=\"author\" data-authorprofileurl=\"\" >\r\n <div class=\"avatar\">\r\n <img src=\"\/community\/cfs-filesystemfile\/__key\/communityserver-components-imagefileviewer\/system-images\/anonymous.gif_2D00_44x44x2.png?_=636755852517552640\" border=\"0px\" alt=\"Anonymous\" \/>\r\n <\/div>\r\n <div class=\"meta\">\r\n <span class=\"user-name\">\r\n <span class=\"ui-userpresence ui-tip \" style=\"display: none;\"\r\ndata-userid=\"2101\" \r\ndata-contentid=\"98b6a4f2-c325-48f1-a4d4-dfac2a59f6b9\" \r\ndata-contenttypeid=\"e9ed4118-60ed-4f2b-a026-5705b8793d05\" \r\ndata-present=\"\" \r\ndata-presentlabel=\"Online\" \r\ndata-notpresentlabel=\"Offline\" \r\ndata-tip=\"\"><\/span>\r\n Anonymous\r\n <\/span>\r\n <\/div>\r\n <\/div>\r\n '); } s.push('\r\n\r\n <div class=\"editor\"><\/div>\r\n\r\n<\/div>\r\n\r\n');}}return s.join('');});</script> <script>jQuery.telligent.evolution.template.register('fragment-52451_typingIndicatorTemplate',function(h,d){var s=[];with(d){with(h){s.push(' <div class=\"threaded typing-status\">');s.push(String( displayName ));s.push(' is typing a reply...<\/div>\r\n\r\n');}}return s.join('');});</script> <script>jQuery.telligent.evolution.template.register('fragment-52451_replyListTemplate',function(h,d){var s=[];with(d){with(h){s.push(' <ul class=\"content-list threaded\"\r\n data-sortby=\"');s.push(String( sortBy ));s.push('\" \r\n data-sortorder=\"');s.push(String( sortOrder ));s.push('\"><\/ul>\r\n\r\n');}}return s.join('');});</script> <script>jQuery.telligent.evolution.template.register('fragment-52451_headerTemplate',function(h,d){var s=[];with(d){with(h){s.push(' <div class=\"threaded-filter\" id=\"fragment-52451_filter\">\r\n <ul class=\"filter order margin-bottom margin-top\">\r\n <li class=\"filter-option\" data-sortby=\"CreatedDate\" data-sortorder=\"Ascending\">\r\n <a class=\"navigable\" href=\"?CommentSortBy=CreatedDate&CommentSortOrder=Ascending\">Oldest<\/a>\r\n <\/li>\r\n <li class=\"filter-option\" data-sortby=\"Votes\" data-sortorder=\"Descending\">\r\n <a class=\"navigable\" href=\"?CommentSortBy=Votes&CommentSortOrder=Descending\">Best<\/a>\r\n <\/li>\r\n <li class=\"filter-option\" data-sortby=\"CreatedDate\" data-sortorder=\"Descending\">\r\n <a class=\"navigable\" href=\"?CommentSortBy=CreatedDate&CommentSortOrder=Descending\">Newest<\/a>\r\n <\/li>\r\n <\/ul>\r\n<\/div>\r\n\r\n');}}return s.join('');});</script> <script>jQuery.telligent.evolution.template.register('fragment-52451_statisticsTemplate',function(h,d){var s=[];with(d){with(h){s.push(' <ul class=\"attribute-list\">\r\n<li class=\"attribute-item count\">\r\n <span class=\"value\">\r\n '); if(commentCount == 1) { s.push('\r\n ');s.push(String( commentCount ));s.push(' comment\r\n '); } else { s.push('\r\n ');s.push(String( commentCount ));s.push(' comments\r\n '); } s.push('\r\n <\/span>\r\n<\/li>\r\n<li class=\"attribute-item users\">\r\n <span class=\"value\">\r\n '); if(userCount == 1) { s.push('\r\n ');s.push(String( userCount ));s.push(' member is here\r\n '); } else { s.push('\r\n ');s.push(String( userCount ));s.push(' members are here\r\n '); } s.push('\r\n <\/span>\r\n<\/li>\r\n<\/ul>\r\n\r\n');}}return s.join('');});</script> <script type="text/javascript" src="/community/cfs-filesystemfile/__key/widgetfiles/e4e96f3241434dc7bc4a04d39c30192f-5e8e1650092c434295fc1226a66a944e/ui.js?_=636755851846466182"></script> <script type="text/javascript"> jQuery(document).ready(function() { jQuery.telligent.evolution.widgets.comments.register({ commentId: null , preFocus: false , wrapperId: 'fragment-52451', wrapper: '#fragment-52451', container: '#fragment-52451_preRenderedWrapperId', bestRepliesWrapperId: 'fragment-52451_bestRepliesWrapper', contentId: 'fc7c1d98-31a5-498e-870e-06cfe306901b', contentTypeId: 'f7d226ab-d59f-475c-9d22-4a79e3f0ec07', sortOrder: 'Descending', sortBy: 'Votes', flattenedSortBy: 'CreatedDate', flattenedSortOrder: 'Ascending', flattenedDepth: 2, pageSize: 5, endlessScroll: true , listRepliesUrl: '/community/utility/scripted-file.ashx?_cf=callback-model-list-replies.vm\u0026_fid=52451\u0026_wid=fragment-52451\u0026_ct=page\u0026_cp=post\u0026_ctt=a3b17ab0af5f11dda3501fcf55d89593\u0026_ctc=047b9db028f04b2b952c2113c772ab76\u0026_ctn=5e8e1650092c434295fc1226a66a944e\u0026_cc=0\u0026_ipd=0\u0026_pcurl=~%2Fquest%2Fb%2Fen%2Fposts%2Fhow-to-compare-a-database-schema-over-time', addReplyUrl: '/community/utility/scripted-file.ashx?_cf=callback-model-add-reply.vm\u0026_fid=52451\u0026_wid=fragment-52451\u0026_ct=page\u0026_cp=post\u0026_ctt=a3b17ab0af5f11dda3501fcf55d89593\u0026_ctc=047b9db028f04b2b952c2113c772ab76\u0026_ctn=5e8e1650092c434295fc1226a66a944e\u0026_cc=0\u0026_ipd=0\u0026_pcurl=~%2Fquest%2Fb%2Fen%2Fposts%2Fhow-to-compare-a-database-schema-over-time', editReplyUrl: '/community/utility/scripted-file.ashx?_cf=callback-model-edit-reply.vm\u0026_fid=52451\u0026_wid=fragment-52451\u0026_ct=page\u0026_cp=post\u0026_ctt=a3b17ab0af5f11dda3501fcf55d89593\u0026_ctc=047b9db028f04b2b952c2113c772ab76\u0026_ctn=5e8e1650092c434295fc1226a66a944e\u0026_cc=0\u0026_ipd=0\u0026_pcurl=~%2Fquest%2Fb%2Fen%2Fposts%2Fhow-to-compare-a-database-schema-over-time', getReplyUrl: '/community/utility/scripted-file.ashx?_cf=callback-model-get-reply.vm\u0026_fid=52451\u0026_wid=fragment-52451\u0026_ct=page\u0026_cp=post\u0026_ctt=a3b17ab0af5f11dda3501fcf55d89593\u0026_ctc=047b9db028f04b2b952c2113c772ab76\u0026_ctn=5e8e1650092c434295fc1226a66a944e\u0026_cc=0\u0026_ipd=0\u0026_pcurl=~%2Fquest%2Fb%2Fen%2Fposts%2Fhow-to-compare-a-database-schema-over-time', listBestUrl: '/community/utility/scripted-file.ashx?_cf=callback-model-list-best.vm\u0026_fid=52451\u0026_wid=fragment-52451\u0026_ct=page\u0026_cp=post\u0026_ctt=a3b17ab0af5f11dda3501fcf55d89593\u0026_ctc=047b9db028f04b2b952c2113c772ab76\u0026_ctn=5e8e1650092c434295fc1226a66a944e\u0026_cc=0\u0026_ipd=0\u0026_pcurl=~%2Fquest%2Fb%2Fen%2Fposts%2Fhow-to-compare-a-database-schema-over-time', loadMoreTemplate: 'fragment-52451_loadMoreTemplate', newRepliesTemplate: 'fragment-52451_newRepliesTemplate', replyTemplate: 'fragment-52451_replyTemplate', typingIndicatorTemplate: 'fragment-52451_typingIndicatorTemplate', replyListTemplate: 'fragment-52451_replyListTemplate', replyFormTemplate: 'fragment-52451_replyFormTemplate', emptyGuid: '00000000-0000-0000-0000-000000000000', deleteCommentPanelUrl: '#_cptype=panel\u0026_cpcontexttype=Explicit\u0026_cppanelid=5aabcf9a-e27b-49e7-93cf-060498d68763\u0026commentid=00000000-0000-0000-0000-000000000000', loginUrl: 'https://www.quest.com/community/id-in?returnUrl=https%3A%2F%2Fwww.quest.com%2Fcommunity%2Fquest%2Fb%2Fen%2Fposts%2Fhow-to-compare-a-database-schema-over-time', headerTemplate: 'fragment-52451_headerTemplate', filterWrapper: '#fragment-52451_filter', replyEditor: { appendTo: function(container) { try { if (tinyMCE.get('fragment-52451_fragment-52451_replyEditor')) { tinyMCE.get('fragment-52451_fragment-52451_replyEditor').plugins.enhancements.moveTo(container); } else { jQuery('#fragment-52451_fragment-52451_replyEditor').appendTo(container); } } catch(e) { }; try { tinyMCE_TelligentEvolutionOptions.AttachOnKeyDownHandler('fragment-52451_fragment-52451_replyEditor',function(e) { jQuery.telligent.evolution.messaging.publish('widgets.threadedComments.typing', { container: container }) }); } catch(e) { }; }, remove: function() { // removing the editor technically just moves it back to a hidden location var wrapper = '#fragment-52451_editorWrapperWrapper'; try { if (tinyMCE.get('fragment-52451_fragment-52451_replyEditor')) { tinyMCE.get('fragment-52451_fragment-52451_replyEditor').plugins.enhancements.moveTo(wrapper); } else { jQuery('#fragment-52451_fragment-52451_replyEditor').appendTo(wrapper); } } catch(e) { }; }, val: function(val) { if (typeof(val) !== 'undefined') { tinyMCE_TelligentEvolutionOptions.SetContent(val, tinyMCE.get('fragment-52451_fragment-52451_replyEditor')); } return (tinyMCE.get('fragment-52451_fragment-52451_replyEditor').getContent() || '').replace(/(?:^\W*<p[^>]*>(?: )?<\/p>|<p[^>]*>(?: )?<\/p>\W*$)/gi, '') }, focus: function() { try { tinyMCE.get('fragment-52451_fragment-52451_replyEditor').plugins.enhancements.focusAndView(); } catch (e) { } } }, text: { more: 'More', peopleWhoVoted: 'People who voted on this reply', noVotes: 'No Votes', successMessage: 'Your comment has been posted.', moderateMessage: 'Thank you, your comment requires moderation so it may take a while to appear.' }, statisticsWrapper: '#fragment-52451_statisticsWrapper', statisticsTemplate: 'fragment-52451_statisticsTemplate', totalComments: 0, presentUsers: 0, storeTempDataCallbackUrl: '/community/utility/scripted-file.ashx?_cf=callback-model-store-temp.vm\u0026_fid=52451\u0026_wid=fragment-52451\u0026_ct=page\u0026_cp=post\u0026_ctt=a3b17ab0af5f11dda3501fcf55d89593\u0026_ctc=047b9db028f04b2b952c2113c772ab76\u0026_ctn=5e8e1650092c434295fc1226a66a944e\u0026_cc=0\u0026_ipd=0\u0026_pcurl=~%2Fquest%2Fb%2Fen%2Fposts%2Fhow-to-compare-a-database-schema-over-time', loginUrl: 'https://www.quest.com/community/id-in?returnUrl=https%3A%2F%2Fwww.quest.com%2Fcommunity%2Fquest%2Fb%2Fen%2Fposts%2Fhow-to-compare-a-database-schema-over-time', tempBody: '', createEditor: { attachOnChange: function() { try { tinyMCE_TelligentEvolutionOptions.AttachOnKeyDownHandler('fragment-52451_fragment-52451_createEditor',function(e) { jQuery.telligent.evolution.messaging.publish('widgets.comments.typing', { from: 'fragment-52451' }) }); } catch(e) { }; }, val: function(val) { if (typeof(val) !== 'undefined') { tinyMCE_TelligentEvolutionOptions.SetContent(val, tinyMCE.get('fragment-52451_fragment-52451_createEditor')); } return (tinyMCE.get('fragment-52451_fragment-52451_createEditor').getContent() || '').replace(/(?:^\W*<p[^>]*>(?: )?<\/p>|<p[^>]*>(?: )?<\/p>\W*$)/gi, '') }, focus: function() { try { tinyMCE.get('fragment-52451_fragment-52451_createEditor').plugins.enhancements.focusAndView(); } catch (e) { } } } }); }); </script> <script type="text/javascript" src="/community/cfs-filesystemfile/__key/defaultwidgets/7bb87a0cc5864a9392ae5b9e5f9747b7-212f71d69e37457887f33f32918f6ae2/ui.js?_=636755839544219450"></script> <script type="text/javascript"> jQuery(function(){ jQuery.telligent.evolution.widgets.userHover.register({ getUserInformationUrl: '/community/utility/scripted-file.ashx?_cf=get-user-information.vm\u0026_fid=832\u0026_wid=footer-832\u0026_ct=footer\u0026_cp=\u0026_ctt=a3b17ab0af5f11dda3501fcf55d89593\u0026_ctc=047b9db028f04b2b952c2113c772ab76\u0026_ctn=5e8e1650092c434295fc1226a66a944e\u0026_cc=0\u0026_ipd=10\u0026_pcurl=~%2Fquest%2Fb%2Fen%2Fposts%2Fhow-to-compare-a-database-schema-over-time', getRecentActivityUrl: '/community/utility/scripted-file.ashx?_cf=get-recent-activity.vm\u0026_fid=832\u0026_wid=footer-832\u0026_ct=footer\u0026_cp=\u0026_ctt=a3b17ab0af5f11dda3501fcf55d89593\u0026_ctc=047b9db028f04b2b952c2113c772ab76\u0026_ctn=5e8e1650092c434295fc1226a66a944e\u0026_cc=0\u0026_ipd=10\u0026_pcurl=~%2Fquest%2Fb%2Fen%2Fposts%2Fhow-to-compare-a-database-schema-over-time' }); }); </script> <script type="text/html" id="footer-834_tip_template"> <div class="tourtip"> <div class="tourtip-message"> <%= message %> </div> <ul class="tourtip-actions"> <% if(state.index() > 0) { %> <li> <a href="#" class="tourtip-previous">Previous</a> </li> <% } %> <% if(state.index() < (state.count() - 1)) { %> <li> <a href="#" class="tourtip-next">Next</a> </li> <% } %> <% if(state.index() === (state.count() - 1)) { %> <li> <a href="#" class="tourtip-finish">Ok, got it!</a> </li> <% } else { %> <li> <a href="#" class="ui-tip tourtip-skip" title="Continue this tour in 24 hours.">Later</a> </li> <% } %> </ul> </div> </script> <script type="text/javascript" src="/community/cfs-filesystemfile/__key/defaultwidgets/7bb87a0cc5864a9392ae5b9e5f9747b7-22e271b19ea14e54a503441c1f4f167e/ui.js?_=636626225406163464"></script> <script type="text/javascript"> jQuery(function(){ jQuery.telligent.evolution.widgets.tourTips.register({ tipTemplate: 'footer-834_tip_template', minWidth: 750, suppressDuration: 86400 }); }); </script> <script type="text/javascript"> //<![CDATA[ jQuery.telligent.evolution.ui.components.moderate.defaults = { reportedText: 'Thank you for your report', flagText: 'Report as abusive', flaggedText: 'Reported as abusive' }; //]]> </script>  </body> </html>