Mid Week Migration Example – Oracle to SQL Server

  Oracle to SQL Server Migration of VLDB (Very Large Database) with minimal cutover outage   Blue Crystal Solutions (BCS) was engaged by a client to migrate Oracle VLDB to SQL Server with minimal business impact when the databases were cutover from Oracle to SQL Server. The customers application imports csv source files into the […]

Oracle to SQL Server

 

Oracle to SQL Server Migration of VLDB (Very Large Database) with minimal cutover outage

 

Blue Crystal Solutions (BCS) was engaged by a client to migrate Oracle VLDB to SQL Server with minimal business impact when the databases were cutover from Oracle to SQL Server.

The customers application imports csv source files into the database but does provide business logic which allows the application to determine whether these files have already been processed. BCS used Microsoft Visual Studio and SSDT (SQL Server Data Tool) to create an SSIS project to generate the packages that provided the functionality to copy the data from Oracle to SQL Server. These packages were executed prior to the cutover and imported a large percentage of the data, then the application processed these backlogs of csv source file to synchronize the Oracle and SQL Server databases.

Any dirty data had to be cleansed due to the configuration difference between the Oracle database and SQL Server’s handling of upper and lower case of characters so the SSIS project had to identify all the dirty data to allow these to be fixed within the Oracle database and then the import process re-run for the table.

Data limitations exist in the SSIS project since the Oracle VLDB contains tables which had over 1B+ of rows causing the import to stop when this threshold was reached. As a workaround, dynamic select queries had to be implemented into the packages for the partition of these table. Cumulatively these partitions had to be less than 1 billion rows when imported at a time. Additionally, this improved the overall process time to import these tables as this allowed multiple SSIS projects to run in parallel of one another.

Learn More.

As you and your team return from the holiday break, it's time to re-engage with your IT environment and ensure a smooth transition back to work. To kickstart the year on a productive note, here are 20 tips to help you revitalize your tech and make the most of your IT environment post-holidays.

Welcome to the fascinating world of Cloud Economics (also known as FinOps or Cloud Financial Management). In this blog, cloud expert Michael Kubik explores the tangible benefits your organisation can reap from this practice.

You or your team might be wrapping up the year and gearing up for some well-deserved time off, or you’re working right through (like we are); it’s always good practice to ensure your IT environment is prepped and ready for a smooth and stress-free break. Here are 9 tips – some familiar and perhaps a couple newbies.

Blue Crystal Solutions: your trusted & innovative IT partner.

Australian owned and operated since 2004, we provide information technology services locally, nationally and beyond.

We are a specialised supplier of Cloud, Application, Database & Infrastructure, Operating System Management, Modernisation and Transformation services. With security at the forefront of everything we do, we can also work with your cyber teams to significantly improve your security posture whilst ensuring all your services with us are fortified by our integrated outage protection and 24×7 monitoring tool, BlueDiamond

Scroll to Top