{"id":335,"date":"2020-10-02T20:25:27","date_gmt":"2020-10-02T20:25:27","guid":{"rendered":"http:\/\/cimplesoft.com\/rangeus-admin\/?p=335"},"modified":"2024-03-20T20:30:17","modified_gmt":"2024-03-20T20:30:17","slug":"database-migration-sql-server-on-premise-to-oracle-in-amazon-web-services","status":"publish","type":"post","link":"https:\/\/cimplesoft.com\/index.php\/2020\/10\/02\/database-migration-sql-server-on-premise-to-oracle-in-amazon-web-services\/","title":{"rendered":"Database migration \u2013SQL Server on-premise to Oracle in Amazon Web Services"},"content":{"rendered":"[vc_row type=&#8221;full_width_content&#8221; full_screen_row_position=&#8221;middle&#8221; column_margin=&#8221;none&#8221; column_direction=&#8221;reverse&#8221; column_direction_tablet=&#8221;default&#8221; column_direction_phone=&#8221;default&#8221; scene_position=&#8221;center&#8221; left_padding_desktop=&#8221;5%&#8221; right_padding_desktop=&#8221;5%&#8221; text_color=&#8221;dark&#8221; text_align=&#8221;left&#8221; row_border_radius=&#8221;none&#8221; row_border_radius_applies=&#8221;bg&#8221; overlay_strength=&#8221;0.3&#8243; gradient_direction=&#8221;left_to_right&#8221; shape_divider_position=&#8221;bottom&#8221; bg_image_animation=&#8221;none&#8221; shape_type=&#8221;&#8221;][vc_column column_padding=&#8221;no-extra-padding&#8221; column_padding_tablet=&#8221;inherit&#8221; column_padding_phone=&#8221;inherit&#8221; column_padding_position=&#8221;all&#8221; background_color_opacity=&#8221;1&#8243; background_hover_color_opacity=&#8221;1&#8243; column_shadow=&#8221;none&#8221; column_border_radius=&#8221;none&#8221; column_link_target=&#8221;_self&#8221; gradient_direction=&#8221;left_to_right&#8221; overlay_strength=&#8221;0.3&#8243; width=&#8221;1\/1&#8243; tablet_width_inherit=&#8221;default&#8221; tablet_text_alignment=&#8221;default&#8221; phone_text_alignment=&#8221;default&#8221; column_border_width=&#8221;none&#8221; column_border_style=&#8221;solid&#8221; bg_image_animation=&#8221;none&#8221;][vc_column_text css=&#8221;.vc_custom_1601663200363{padding-bottom: 20px !important;}&#8221;]<b>Business need<\/b><\/p>\n<p>A leading telecom service required the live-migration of its critical 24X7 billing system with near-zero downtime. IT leadership at the company recognized the financial and reputation impact of any downtime. Their responsibility was to identify and execute a migration plan that would eliminate these risks. Due to the high visibility of this project, the company reached out to CimpleSoft based on our experience with zero downtime migrations between database platforms.<\/p>\n<p><b>Challenge<\/b><\/p>\n<p>The company needed to migrate and replicate live data between SQL Server and Oracle with near-zero downtime.<span class=\"Apple-converted-space\">\u00a0<\/span><\/p>\n<p><b>Our solution<\/b><\/p>\n<p>CimpleSoft designed a plan based on Oracle GoldenGate 12c to migrate the client\u2019s on-premises SQL Server database to Oracle RAC database hosted in Amazon Web Services (AWS). The plan leveraged best practices and a balanced approach using GoldenGate for both replication and initial load of data resulting in a successful migration to Amazon Web Services (AWS) with minimal business impact.<\/p>\n<p>CimpleSoft provided a balance of duties and having experience with both on-premise SQL Server and Oracle on AWS platform, CimpleSoft provided insight on the design, operation and tuning differences between the two, ensuring optimal performance and ongoing operational excellence. The plan included designing the AWS Oracle server platform, testing the platform with sample data and then establishing the GoldenGate replication between Oracle and SQL Server.<\/p>\n<p><b>Outcome\/Benefits<\/b><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>The production migration was accomplished over a three-month period.\u00a0 This allowed for adequate development and testing of the application prior to entering into production. The cutover to production in Amazon Web Services (AWS) itself was accomplished in less than four hours with no data loss.<span class=\"Apple-converted-space\">\u00a0<\/span><\/li>\n<li>Database performance results: Leveraging the experience of CimpleSoft, the firm was able to successfully execute a near-zero downtime database migration from SQL Server Database on premise to Oracle in AWS.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><b>Technology<\/b><\/p>\n<p>Oracle GoldenGate 12c, SQL Server, Oracle RAC, Amazon Web Services (AWS)[\/vc_column_text][vc_row_inner equal_height=&#8221;yes&#8221; content_placement=&#8221;middle&#8221; column_margin=&#8221;40px&#8221; column_direction=&#8221;default&#8221; column_direction_tablet=&#8221;default&#8221; column_direction_phone=&#8221;default&#8221; text_align=&#8221;left&#8221;][vc_column_inner column_padding=&#8221;no-extra-padding&#8221; column_padding_tablet=&#8221;inherit&#8221; column_padding_phone=&#8221;inherit&#8221; column_padding_position=&#8221;all&#8221; background_color_opacity=&#8221;1&#8243; background_hover_color_opacity=&#8221;1&#8243; column_shadow=&#8221;none&#8221; column_border_radius=&#8221;none&#8221; column_link_target=&#8221;_self&#8221; gradient_direction=&#8221;left_to_right&#8221; overlay_strength=&#8221;0.3&#8243; width=&#8221;1\/5&#8243; tablet_width_inherit=&#8221;default&#8221; column_border_width=&#8221;none&#8221; column_border_style=&#8221;solid&#8221; bg_image_animation=&#8221;none&#8221; enable_animation=&#8221;true&#8221; animation=&#8221;reveal-from-bottom&#8221; offset=&#8221;vc_col-md-2 vc_col-xs-4&#8243;][image_with_animation image_url=&#8221;336&#8243; animation=&#8221;Fade In&#8221; hover_animation=&#8221;none&#8221; alignment=&#8221;center&#8221; border_radius=&#8221;none&#8221; box_shadow=&#8221;none&#8221; image_loading=&#8221;lazy-load&#8221; max_width=&#8221;100%&#8221; max_width_mobile=&#8221;default&#8221;][\/vc_column_inner][vc_column_inner column_padding=&#8221;no-extra-padding&#8221; column_padding_tablet=&#8221;inherit&#8221; column_padding_phone=&#8221;inherit&#8221; column_padding_position=&#8221;all&#8221; background_color_opacity=&#8221;1&#8243; background_hover_color_opacity=&#8221;1&#8243; column_shadow=&#8221;none&#8221; column_border_radius=&#8221;none&#8221; column_link_target=&#8221;_self&#8221; gradient_direction=&#8221;left_to_right&#8221; overlay_strength=&#8221;0.3&#8243; width=&#8221;1\/5&#8243; tablet_width_inherit=&#8221;default&#8221; column_border_width=&#8221;none&#8221; column_border_style=&#8221;solid&#8221; bg_image_animation=&#8221;none&#8221; enable_animation=&#8221;true&#8221; animation=&#8221;reveal-from-bottom&#8221; delay=&#8221;50&#8243; offset=&#8221;vc_col-md-2 vc_col-xs-4&#8243;][image_with_animation image_url=&#8221;299&#8243; animation=&#8221;Fade In&#8221; hover_animation=&#8221;none&#8221; alignment=&#8221;center&#8221; border_radius=&#8221;none&#8221; box_shadow=&#8221;none&#8221; image_loading=&#8221;lazy-load&#8221; max_width=&#8221;100%&#8221; max_width_mobile=&#8221;default&#8221; delay=&#8221;50&#8243;][\/vc_column_inner][vc_column_inner column_padding=&#8221;no-extra-padding&#8221; column_padding_tablet=&#8221;inherit&#8221; column_padding_phone=&#8221;inherit&#8221; column_padding_position=&#8221;all&#8221; background_color_opacity=&#8221;1&#8243; background_hover_color_opacity=&#8221;1&#8243; column_shadow=&#8221;none&#8221; column_border_radius=&#8221;none&#8221; column_link_target=&#8221;_self&#8221; gradient_direction=&#8221;left_to_right&#8221; overlay_strength=&#8221;0.3&#8243; width=&#8221;1\/5&#8243; tablet_width_inherit=&#8221;default&#8221; column_border_width=&#8221;none&#8221; column_border_style=&#8221;solid&#8221; bg_image_animation=&#8221;none&#8221; enable_animation=&#8221;true&#8221; animation=&#8221;reveal-from-bottom&#8221; delay=&#8221;100&#8243; offset=&#8221;vc_col-md-2 vc_col-xs-4&#8243;][image_with_animation image_url=&#8221;337&#8243; animation=&#8221;Fade In&#8221; hover_animation=&#8221;none&#8221; alignment=&#8221;center&#8221; border_radius=&#8221;none&#8221; box_shadow=&#8221;none&#8221; image_loading=&#8221;lazy-load&#8221; max_width=&#8221;100%&#8221; max_width_mobile=&#8221;default&#8221; delay=&#8221;100&#8243;][\/vc_column_inner][vc_column_inner column_padding=&#8221;no-extra-padding&#8221; column_padding_tablet=&#8221;inherit&#8221; column_padding_phone=&#8221;inherit&#8221; column_padding_position=&#8221;all&#8221; background_color_opacity=&#8221;1&#8243; background_hover_color_opacity=&#8221;1&#8243; column_shadow=&#8221;none&#8221; column_border_radius=&#8221;none&#8221; column_link_target=&#8221;_self&#8221; gradient_direction=&#8221;left_to_right&#8221; overlay_strength=&#8221;0.3&#8243; width=&#8221;1\/5&#8243; tablet_width_inherit=&#8221;default&#8221; column_border_width=&#8221;none&#8221; column_border_style=&#8221;solid&#8221; bg_image_animation=&#8221;none&#8221; enable_animation=&#8221;true&#8221; animation=&#8221;reveal-from-bottom&#8221; delay=&#8221;150&#8243; offset=&#8221;vc_col-md-2 vc_col-xs-4&#8243;][image_with_animation image_url=&#8221;338&#8243; animation=&#8221;Fade In&#8221; hover_animation=&#8221;none&#8221; alignment=&#8221;center&#8221; border_radius=&#8221;none&#8221; box_shadow=&#8221;none&#8221; image_loading=&#8221;lazy-load&#8221; max_width=&#8221;75%&#8221; max_width_mobile=&#8221;default&#8221; delay=&#8221;150&#8243;][\/vc_column_inner][vc_column_inner column_padding=&#8221;no-extra-padding&#8221; column_padding_tablet=&#8221;inherit&#8221; column_padding_phone=&#8221;inherit&#8221; column_padding_position=&#8221;all&#8221; background_color_opacity=&#8221;1&#8243; background_hover_color_opacity=&#8221;1&#8243; column_shadow=&#8221;none&#8221; column_border_radius=&#8221;none&#8221; column_link_target=&#8221;_self&#8221; gradient_direction=&#8221;left_to_right&#8221; overlay_strength=&#8221;0.3&#8243; width=&#8221;1\/5&#8243; tablet_width_inherit=&#8221;default&#8221; column_border_width=&#8221;none&#8221; column_border_style=&#8221;solid&#8221; bg_image_animation=&#8221;none&#8221; enable_animation=&#8221;true&#8221; animation=&#8221;reveal-from-bottom&#8221; delay=&#8221;200&#8243; offset=&#8221;vc_col-md-2 vc_col-xs-4&#8243;][image_with_animation animation=&#8221;Fade In&#8221; hover_animation=&#8221;none&#8221; alignment=&#8221;center&#8221; border_radius=&#8221;none&#8221; box_shadow=&#8221;none&#8221; image_loading=&#8221;lazy-load&#8221; max_width=&#8221;100%&#8221; max_width_mobile=&#8221;default&#8221; delay=&#8221;200&#8243;][\/vc_column_inner][\/vc_row_inner][nectar_btn size=&#8221;large&#8221; button_style=&#8221;regular&#8221; button_color_2=&#8221;Accent-Color&#8221; icon_family=&#8221;iconsmind&#8221; url=&#8221;https:\/\/cimplesoft.com\/index.php\/all-case-studies\/&#8221; text=&#8221;View All Case Studies&#8221; icon_iconsmind=&#8221;iconsmind-Triangle-ArrowRight&#8221; margin_top=&#8221;30&#8243;][\/vc_column][\/vc_row]\n","protected":false},"excerpt":{"rendered":"<p>[vc_row type=&#8221;full_width_content&#8221; full_screen_row_position=&#8221;middle&#8221; column_margin=&#8221;none&#8221; column_direction=&#8221;reverse&#8221; column_direction_tablet=&#8221;default&#8221; column_direction_phone=&#8221;default&#8221; scene_position=&#8221;center&#8221; left_padding_desktop=&#8221;5%&#8221; right_padding_desktop=&#8221;5%&#8221; text_color=&#8221;dark&#8221; text_align=&#8221;left&#8221; row_border_radius=&#8221;none&#8221; row_border_radius_applies=&#8221;bg&#8221; overlay_strength=&#8221;0.3&#8243; gradient_direction=&#8221;left_to_right&#8221; shape_divider_position=&#8221;bottom&#8221; bg_image_animation=&#8221;none&#8221; shape_type=&#8221;&#8221;][vc_column column_padding=&#8221;no-extra-padding&#8221; column_padding_tablet=&#8221;inherit&#8221; column_padding_phone=&#8221;inherit&#8221; column_padding_position=&#8221;all&#8221; background_color_opacity=&#8221;1&#8243; background_hover_color_opacity=&#8221;1&#8243; column_shadow=&#8221;none&#8221; column_border_radius=&#8221;none&#8221; column_link_target=&#8221;_self&#8221; gradient_direction=&#8221;left_to_right&#8221; overlay_strength=&#8221;0.3&#8243;&#8230;<\/p>\n","protected":false},"author":2,"featured_media":341,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[11],"tags":[],"_links":{"self":[{"href":"https:\/\/cimplesoft.com\/index.php\/wp-json\/wp\/v2\/posts\/335"}],"collection":[{"href":"https:\/\/cimplesoft.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cimplesoft.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cimplesoft.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cimplesoft.com\/index.php\/wp-json\/wp\/v2\/comments?post=335"}],"version-history":[{"count":6,"href":"https:\/\/cimplesoft.com\/index.php\/wp-json\/wp\/v2\/posts\/335\/revisions"}],"predecessor-version":[{"id":1299,"href":"https:\/\/cimplesoft.com\/index.php\/wp-json\/wp\/v2\/posts\/335\/revisions\/1299"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cimplesoft.com\/index.php\/wp-json\/wp\/v2\/media\/341"}],"wp:attachment":[{"href":"https:\/\/cimplesoft.com\/index.php\/wp-json\/wp\/v2\/media?parent=335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cimplesoft.com\/index.php\/wp-json\/wp\/v2\/categories?post=335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cimplesoft.com\/index.php\/wp-json\/wp\/v2\/tags?post=335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}