{"id":19656,"date":"2021-10-22T20:03:41","date_gmt":"2021-10-22T14:33:41","guid":{"rendered":"http:\/\/ismiletechnologies.com\/?page_id=19656"},"modified":"2023-07-07T21:54:50","modified_gmt":"2023-07-07T16:24:50","slug":"continuous-delivery-of-database-changes-for-a-major-shipping-distributor","status":"publish","type":"page","link":"https:\/\/ismiletechnologies.com\/en_us\/case-studies\/continuous-delivery-of-database-changes-for-a-major-shipping-distributor\/","title":{"rendered":"Continuous delivery of database changes for a Major Shipping Distributor"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
<\/div>\n\t\t\t\t\t\t
\n\t\t\t\n\t\n<\/svg>\t\t<\/div>\n\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t

Case Study<\/h4>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t

Continuous delivery of database changes for a Major Shipping Distributor<\/h1>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tDownload PDF<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t
<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

The client is the leading distributor of shipping, industrial and packaging materials to businesses throughout North America. They are committed to delivering high-quality products and services to their customers.<\/span><\/span>\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t

Need<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

The client was facing an issue in synchronizing the independent pipelines of their databases and applications. Eventually, they need experts to store changes in source control, automate deployment steps, and share knowledge and responsibility between the development teams and the DBA team.<\/span><\/span>\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t\t

Solution<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

iSmile\u00a0technologies worked closely with the client to develop the process for applications to synchronize with the databases. The process is also known as Database Shift Left. After describing all the database changes with the scripts, they were applied through the source control. This database development process included continuous integration and delivery activities, which will take part in deployment pipelines.\u00a0<\/span>\u00a0<\/span><\/p>

Different approaches are applied to describe database changes. Their approaches were Migration based and state-based approaches, which intended to work on small batches to avoid errors.<\/span>\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t\t

Outcome<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

The solution helped the client in the continuous integration and delivery of database changes. The practice reflects the future growth of the organization as per their changing needs.<\/span><\/span>\u00a0<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t

\n\t\t\t
\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

Case Study Download PDF The client is the leading distributor of shipping, industrial and packaging materials to businesses throughout North America. They are committed to delivering high-quality products and services to their customers.\u00a0 Need The client was facing an issue in synchronizing the independent pipelines of their databases and applications. Eventually, they need experts to […]<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":16502,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"elementor_header_footer","meta":{"footnotes":""},"class_list":["post-19656","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/pages\/19656","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/comments?post=19656"}],"version-history":[{"count":17,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/pages\/19656\/revisions"}],"predecessor-version":[{"id":39188,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/pages\/19656\/revisions\/39188"}],"up":[{"embeddable":true,"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/pages\/16502"}],"wp:attachment":[{"href":"https:\/\/ismiletechnologies.com\/en_us\/wp-json\/wp\/v2\/media?parent=19656"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}