1.0Suherman Bloghttps://suherman.asia/w2adminhttps://suherman.asia/w2/author/adminIntroduction to Database Snapshot (2) - Suherman Blogrich600338<blockquote class="wp-embedded-content" data-secret="oQHRDFLhDM"><a href="https://suherman.asia/w2/introduction-to-database-snapshot-2.html">Introduction to Database Snapshot (2)</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://suherman.asia/w2/introduction-to-database-snapshot-2.html/embed#?secret=oQHRDFLhDM" width="600" height="338" title="“Introduction to Database Snapshot (2)” — Suherman Blog" data-secret="oQHRDFLhDM" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script type="text/javascript">
/* <![CDATA[ */
/*! This file is auto-generated */
!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);
/* ]]> */
</script>
Bagian 1. Setelah kita mencoba bagaimana membuat sebuah database Snapshot disini, selanjutnya kita akan mencoba untuk melihat apa yang terjadi apabila di database source terjadi aktivitas transaksi. pertama kita coba ambil sample misalkan table Production.Product SELECT ProductID,Name FROM AdventureWorks.Production.Product ORDER BY ProductID GO SELECT ProductID,Name FROM Snapshot_AW.Production.Product ORDER BY ProductID … Continue readinghttp://mugi.or.id/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/suherman/image_5F00_thumb_5F00_02646353.png