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!


About SQLGator

Microsoft Data Platform MVP, Florida Gator, Star Wars fanatic and is there anything else...oh yeah PS4! I am a geek and SQL Server Business Intelligence Consultant, there are other technologies greater than these? Not so fast my friend! I also love to travel to new and exotic places.

Posted on August 1, 2012, in Career Advice and tagged . Bookmark the permalink. 2 Comments.

  1. 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 🙂

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: