Migration Tedium Pays Off
Today I am going through the tedium of checking row counts and randomly verifying data in round two of our conversion from Oracle to SQL Server. This is very monotonous and it would be incredibly easy to tell my boss that everything checked out ok. Who would notice if I skipped a few of these tests? Me. That thought would always be in the back of my head, is this data really the same data that was in Oracle or are we missing some data. It would be my Tell Tale Heart (Edgar Allen Poe references always make for a great blog post)!
Being a database administrator is never about glamour, but admittedly there are more entertaining parts of the job. However, do not overlook these minute details or you might be facing the opportunity to update your resume. Enjoy!
Posted on August 1, 2012, in Career Advice and tagged Random. Bookmark the permalink. 2 Comments.
If you did the migration via SSIS, you’d be more confident. What the preferred Oracle-To-SQL route anyway? I’d like to know 🙂
We are using Microsoft’s SSMA migration tool.