Mid Week Migration Example – Oracle to SQL Server

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.

Efficient database management is not just about storing and retrieving information; it's a strategic asset that, when harnessed correctly, can propel an organisation towards sustainable growth.

For those of you in Adelaide who were unable to experience AWS re:Invent Event held in Las Vegas this year, we’re bringing the event to you in Adelaide as an offical sponsor.

In the evolving world of technology, organisations, from large businesses to national government bodies, seek partners that provide reliable and innovative solutions to enhance operational efficiency and productivity. A standout in this sphere, Blue Crystal Solutions, headquartered in Adelaide with offices in Melbourne, Brisbane, Sydney, and Perth, offers precisely such expertise. Here’s how they stand tall in cloud consulting and beyond.

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, all your services are fortified by our integrated outage protection  and monitoring tool, BlueDiamond

Scroll to Top