{"id":3883,"date":"2012-01-26T09:54:00","date_gmt":"2012-01-26T17:54:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/"},"modified":"2024-01-22T22:49:51","modified_gmt":"2024-01-23T06:49:51","slug":"the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/","title":{"rendered":"The Co-operative Group saves millions by switching from Oracle to SQL Server"},"content":{"rendered":"

We talk a lot about the features and technical \u201chow to\u201d behind SQL Server, but our favorite topic is showing real-world examples of how it helps our customers achieve their goals and save millions of dollars. One great example of this is <\/span><\/span>The Co-operative Group<\/span><\/span><\/a> and their switch from Oracle to SQL Server.<\/span><\/span><\/p>\n

The Co-operative Group operates 5,000 retail stores, and is one of the world\u2019s largest member-owned businesses. The Group\u2019s top strategic priority is expanding its membership base, and they set an aggressive goal to grow to 20 million members by 2020. <\/span><\/span><\/p>\n

But instead of helping the Group achieve its goals, technology and licensing models were a barrier to success. The Group\u2019s previous membership system was an Oracle solution, hosted by a provider that charged per member \u2013 a situation where scaling membership would have cost the company tens of millions of dollars. \u201cIt would have been financial suicide if we had tried to use the existing solution to accomplish our growth goals,\u201d said Chris Sproston, the head of software development at The Co-operative Group. <\/span><\/span><\/p>\n

To realize the company\u2019s goals, The Co-operative Group turned to SQL Server 2008 R2 and a variety of other Microsoft products and services. Working with Microsoft partner HCL Infosystems, they developed a solution that stores account information, records transactional data and supports web-based self-service account management. <\/span><\/span><\/p>\n

Using this new solution, The Co-operative Group improved member services with enterprise-wide reporting and analysis tools, and increased the security of customer information with highly specific access privileges and transparent data encryption. As a result, the company\u2019s IT department can now spend time innovating and adding features, instead of using its resources to manage new reports or queries. <\/span><\/span><\/p>\n

\u201cBecause SQL Server 2008 R2 is so scalable, we can expand from 6 million to 20 million members for 10 percent of what it would have cost on our old solution,\u201d said Chris Sproston, head of software development for The Co-operative Group.<\/span><\/span><\/p>\n

By implementing the Microsoft system, The Co-operative Group will be able to reduce the cost of its long-term growth goal by tens of millions of dollars. And that\u2019s the kind of success story we love to be able to share.<\/span><\/span><\/p>\n

For more information about The Co-operative Group\u2019s solution and how they plan to save millions by switching from Oracle to SQL Server, check out the <\/span><\/span>case study<\/span><\/span><\/a>.<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

We talk a lot about the features and technical \u201chow to\u201d behind SQL Server, but our favorite topic is showing real-world examples of how it helps our customers achieve their goals and save millions of dollars. One great example of this is The Co-operative Group and their switch from Oracle to SQL Server.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2445],"topic":[],"coauthors":[2487],"class_list":["post-3883","post","type-post","status-publish","format-standard","hentry","content-type-thought-leadership"],"yoast_head":"\nThe Co-operative Group saves millions by switching from Oracle to SQL Server - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Co-operative Group saves millions by switching from Oracle to SQL Server - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"We talk a lot about the features and technical \u201chow to\u201d behind SQL Server, but our favorite topic is showing real-world examples of how it helps our customers achieve their goals and save millions of dollars. One great example of this is The Co-operative Group and their switch from Oracle to SQL Server.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2012-01-26T17:54:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"The Co-operative Group saves millions by switching from Oracle to SQL Server\",\"datePublished\":\"2012-01-26T17:54:00+00:00\",\"dateModified\":\"2024-01-23T06:49:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/\"},\"wordCount\":399,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/\",\"name\":\"The Co-operative Group saves millions by switching from Oracle to SQL Server - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2012-01-26T17:54:00+00:00\",\"dateModified\":\"2024-01-23T06:49:51+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Co-operative Group saves millions by switching from Oracle to SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The Co-operative Group saves millions by switching from Oracle to SQL Server - Microsoft SQL Server Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"The Co-operative Group saves millions by switching from Oracle to SQL Server - Microsoft SQL Server Blog","og_description":"We talk a lot about the features and technical \u201chow to\u201d behind SQL Server, but our favorite topic is showing real-world examples of how it helps our customers achieve their goals and save millions of dollars. One great example of this is The Co-operative Group and their switch from Oracle to SQL Server.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2012-01-26T17:54:00+00:00","article_modified_time":"2024-01-23T06:49:51+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"The Co-operative Group saves millions by switching from Oracle to SQL Server","datePublished":"2012-01-26T17:54:00+00:00","dateModified":"2024-01-23T06:49:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/"},"wordCount":399,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/","name":"The Co-operative Group saves millions by switching from Oracle to SQL Server - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2012-01-26T17:54:00+00:00","dateModified":"2024-01-23T06:49:51+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/01\/26\/the-co-operative-group-saves-millions-by-switching-from-oracle-to-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"The Co-operative Group saves millions by switching from Oracle to SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/3883","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=3883"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/3883\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=3883"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=3883"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=3883"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=3883"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=3883"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=3883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}